APPS.PJI_PMV_AVL dependencies on PJI_REP_RA3

Line 863: PROCEDURE GET_SQL_PJI_REP_RA3 (P_PAGE_PARAMETER_TBL IN BIS_PMV_PAGE_PARAMETER_TBL

859:
860: /******************************************************
861: * RA3: AVAILABLE RESOURCE DURATION REPORT FUNCTIONS
862: ******************************************************/
863: PROCEDURE GET_SQL_PJI_REP_RA3 (P_PAGE_PARAMETER_TBL IN BIS_PMV_PAGE_PARAMETER_TBL
864: , X_PMV_SQL OUT NOCOPY VARCHAR2
865: , X_PMV_OUTPUT OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
866: IS
867: BEGIN

Line 892: P_REGION_CODE => 'PJI_REP_RA3',

888: FACT.PJI_REP_TOTAL_8 "PJI_REP_TOTAL_8",
889: FACT.PJI_REP_TOTAL_9 "PJI_REP_TOTAL_9"'
890: ,P_SQL_STATEMENT => X_PMV_SQL
891: ,P_PMV_OUTPUT => X_PMV_OUTPUT,
892: P_REGION_CODE => 'PJI_REP_RA3',
893: P_PLSQL_DRIVER => 'PJI_PMV_AVL.PLSQLDRIVER_RA3',
894: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
895: '<>, ' ||
896: '<>, ' ||

Line 901: END GET_SQL_PJI_REP_RA3;

897: '<>, ' ||
898: '<>, ' ||
899: '<>, ' ||
900: '<>');
901: END GET_SQL_PJI_REP_RA3;
902:
903: FUNCTION PLSQLDRIVER_RA3 (
904: P_OPERATING_UNIT IN VARCHAR2 DEFAULT NULL,
905: P_ORGANIZATION IN VARCHAR2,

Line 911: ) RETURN PJI_REP_RA3_TBL

907: P_AVL_TYPE IN VARCHAR2,
908: P_AS_OF_DATE IN NUMBER,
909: P_PERIOD_TYPE IN VARCHAR2,
910: P_VIEW_BY IN VARCHAR2
911: ) RETURN PJI_REP_RA3_TBL
912: IS
913: PRAGMA AUTONOMOUS_TRANSACTION;
914: L_AVL_RES_DUR_TBL PJI_REP_RA3_TBL := PJI_REP_RA3_TBL();
915: L_THRESHOLD NUMBER := P_THRESHOLD;

Line 914: L_AVL_RES_DUR_TBL PJI_REP_RA3_TBL := PJI_REP_RA3_TBL();

910: P_VIEW_BY IN VARCHAR2
911: ) RETURN PJI_REP_RA3_TBL
912: IS
913: PRAGMA AUTONOMOUS_TRANSACTION;
914: L_AVL_RES_DUR_TBL PJI_REP_RA3_TBL := PJI_REP_RA3_TBL();
915: L_THRESHOLD NUMBER := P_THRESHOLD;
916: L_AS_OF_DATE NUMBER := P_AS_OF_DATE;
917: L_AVL_TYPE VARCHAR2(60) := P_AVL_TYPE;
918:

Line 976: SELECT PJI_REP_RA3 ( ORGANIZATION_ID

972: END;
973: END IF;
974:
975:
976: SELECT PJI_REP_RA3 ( ORGANIZATION_ID
977: , EXP_ORGANIZATION_ID
978: ,SUM(AVAILABILITY)
979: ,SUM(CUR_AVL_1)
980: + SUM(CUR_AVL_2)