R12.1.3 : after Applying patches p10117018_R12.PJT.B_R12_GENERIC,p11839583_R12.PJT.B_R12_GENERIC,p1
Hi,
after Applying patches p10117018_R12.PJT.B_R12_GENERIC,p11839583_R12.PJT.B_R12_GENERIC,p12312729_R12.PJ_PF.B_R12_LINUX,p12887533_R12.PJI.B_R12_GENERIC.
SQL> select OWNER, OBJECT_NAME,OBJECT_TYPE,LAST_DDL_TIME from dba_objects where status='INVALID' order by owner;
OWNER OBJECT_NAME OBJECT_TYPE LAST_DDL_T
--------- ------------------------------- --------------- ----------
APPS GMS_AWARD_DIST_ENG PACKAGE BODY 22-OCT-13
APPS GMS_LD_PKG PACKAGE BODY 22-OCT-13
Now there are only two invalid object.
Packages versions :
select text from user_source where name='GMS_LD_PKG' and line=2;
TEXT
--------------------------------------------------------------------------------
-- $Header: gmsenxfs.pls 120.2 2005/09/02 02:50:52 appldev ship $
after Applying patches p10117018_R12.PJT.B_R12_GENERIC,p11839583_R12.PJT.B_R12_GENERIC,p12312729_R12.PJ_PF.B_R12_LINUX,p12887533_R12.PJI.B_R12_GENERIC.
SQL> select OWNER, OBJECT_NAME,OBJECT_TYPE,LAST_DDL_TIME from dba_objects where status='INVALID' order by owner;
OWNER OBJECT_NAME OBJECT_TYPE LAST_DDL_T
--------- ------------------------------- --------------- ----------
APPS GMS_AWARD_DIST_ENG PACKAGE BODY 22-OCT-13
APPS GMS_LD_PKG PACKAGE BODY 22-OCT-13
Now there are only two invalid object.
Packages versions :
select text from user_source where name='GMS_LD_PKG' and line=2;
TEXT
--------------------------------------------------------------------------------
-- $Header: gmsenxfs.pls 120.2 2005/09/02 02:50:52 appldev ship $
Tagged:
0