DBA Data[Home] [Help]

APPS.ENG_ENGRCNDR_XMLP_PKG dependencies on INV_ORGHIERARCHY_PVT

Line 62: L_ORG_CODE_LIST INV_ORGHIERARCHY_PVT.ORGID_TBL_TYPE;

58: MODE="SELECT" DISPLAY="ALL" TABLEALIAS="msi1"')*/NULL;
59: DECLARE
60: L_ORG_ID NUMBER;
61: L_INDEX NUMBER;
62: L_ORG_CODE_LIST INV_ORGHIERARCHY_PVT.ORGID_TBL_TYPE;
63: L_ORG_NAME VARCHAR2(60);
64: L_RESP_ID NUMBER;
65: L_RESP_APPL_ID NUMBER;
66: BEGIN

Line 113: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(P_ORG_HIERARCHY

109: VALUES (P_SEQUENCE_ID
110: ,P_ORG_ID
111: ,1);
112: ELSE
113: INV_ORGHIERARCHY_PVT.ORG_HIERARCHY_LIST(P_ORG_HIERARCHY
114: ,P_ORG_ID
115: ,L_ORG_CODE_LIST);
116: IF (L_ORG_CODE_LIST.COUNT > 0) THEN
117: FOR l_index IN 1 .. L_ORG_CODE_LIST.COUNT LOOP