APPS.PJI_PMV_AVL dependencies on PJI_REP_RA2_TBL

Line 541: ) RETURN PJI_REP_RA2_TBL

537: P_ORGANIZATION IN VARCHAR2,
538: P_THRESHOLD IN NUMBER,
539: P_AS_OF_DATE IN NUMBER,
540: P_VIEW_BY IN VARCHAR2
541: ) RETURN PJI_REP_RA2_TBL
542: IS
543: PRAGMA AUTONOMOUS_TRANSACTION;
544: L_CUR_AVL_RES_TBL PJI_REP_RA2_TBL := PJI_REP_RA2_TBL();
545: TYPE T_WEEK_IDS IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 544: L_CUR_AVL_RES_TBL PJI_REP_RA2_TBL := PJI_REP_RA2_TBL();

540: P_VIEW_BY IN VARCHAR2
541: ) RETURN PJI_REP_RA2_TBL
542: IS
543: PRAGMA AUTONOMOUS_TRANSACTION;
544: L_CUR_AVL_RES_TBL PJI_REP_RA2_TBL := PJI_REP_RA2_TBL();
545: TYPE T_WEEK_IDS IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
546: TYPE T_WEEK_END_DATE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
547: L_THRESHOLD NUMBER := P_THRESHOLD;
548: L_AS_OF_DATE NUMBER := P_AS_OF_DATE;