DBA Data[Home] [Help]

APPS.BNE_INTEGRATOR_UTILS dependencies on USER_OBJECTS

Line 19: -- 25-MAR-2004 DGROVES Bug 3510393 Changed DBA_OBJECTS to USER_OBJECTS --

15: -- 29-NOV-2002 KPEET Updated procedure CREATE_INTERFACE_FOR_API. --
16: -- 01-OCT-2003 TOBERMEI Updated procedure CREATE_INTERFACE_FOR_API. --
17: -- 01-OCT-2003 TOBERMEI Updated procedure CREATE_API_PARAMETER_LIST. --
18: -- 19-JAN-2004 DGROVES Bug 3059157 --
19: -- 25-MAR-2004 DGROVES Bug 3510393 Changed DBA_OBJECTS to USER_OBJECTS --
20: -- 16-FEB-2005 DGROVES Bug 4187173 Added new columns to UPSERT_INTERFACE_COLUMN
21: -- 28-FEB-2005 DGROVES Bug 4046464 default mandatory flag columns. --
22: -- 07-JUL-2005 DVAYRO Bug 4477511 Added new column for NE_LAYOUT_COLS_PKG--
23: -- 26-JUL-2006 DAGROVES Bug 4447161 Added P_USE_FND_METADATA flag to CREATE_INTERFACE_FOR_TABLE(),

Line 304: USER_OBJECTS B

300: SYSDATE CREATION_DATE,
301: CP_USER_ID LAST_UPDATED_BY,
302: SYSDATE LAST_UPDATE_DATE
303: FROM SYS.ARGUMENT$ A,
304: USER_OBJECTS B
305: WHERE A.OBJ# = B.OBJECT_ID
306: AND B.OBJECT_NAME = CP_API_PACKAGE_NAME
307: AND A.PROCEDURE$ = CP_API_PROCEDURE_NAME
308: AND A.LEVEL# = 0

Line 1017: FROM SYS.ARGUMENT$ A, USER_OBJECTS B

1013: CP_USER_ID CREATED_BY,
1014: SYSDATE CREATION_DATE,
1015: CP_USER_ID LAST_UPDATED_BY,
1016: SYSDATE LAST_UPDATE_DATE
1017: FROM SYS.ARGUMENT$ A, USER_OBJECTS B
1018: WHERE A.OBJ# = B.OBJECT_ID
1019: AND B.OBJECT_NAME = CP_API_PACKAGE_NAME
1020: AND A.PROCEDURE$ = CP_API_PROCEDURE_NAME
1021: AND A.LEVEL# = 0

Line 1074: USER_OBJECTS B

1070: BEGIN
1071: SELECT MIN(A.OVERLOAD#)
1072: INTO VN_OVERLOAD
1073: FROM SYS.ARGUMENT$ A,
1074: USER_OBJECTS B
1075: WHERE A.OBJ# = B.OBJECT_ID
1076: AND B.OBJECT_NAME = P_API_PACKAGE_NAME
1077: AND A.PROCEDURE$ = P_API_PROCEDURE_NAME
1078: AND A.LEVEL# = 0;