home

FND_GLOBAL

FND_REQUEST

select object_name,
object_type,
status       
from dba_objects       
where object_name='FND_GLOBAL'      
and owner='APPS';

 

alter package FND_GLOBAL compile body;

 

CREATE fnd_global

FND_GLOBAL

@$FND_TOP/patch/115/sql/AFSCGBLS.pls

@$FND_TOP/patch/115/sql/AFSCGBLB.pls

 

Check the version

FND_TOP/patch/115/sql/strings AFSCGBLB.pls | grep -i header 

login to Sqlplus as Apps user and run:        
select text from dba_source         
where name = 'FND_GLOBAL'        
and line < 5;

 

FND_REQUEST

/u02/oracle/TEST/apps/apps_st/appl/fnd/12.0.0/patch/115/sql

AFCPREQS.pls package header

AFCPREQB.pls - package body

 

FND_CONC_GLOBAL
     a)AFCPGBLS.pls
     b)AFCPGBLB.pls

 

 

FND_SUBMIT
    a) AFCPRSSS.pls
    b)AFCPRSSB.pls