APPS.PJI_PMV_AVL dependencies on PJI_REP_RA5_TBL

Line 9: PROCEDURE GET_AVAILABLE_SINCE_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER, P_THRESHOLD NUMBER);

5: G_LABOUR_UNITS VARCHAR2(40);
6: G_AVL_THRESHOLD_VAL NUMBER;
7:
8: -- FORWARD DECLARATION.
9: PROCEDURE GET_AVAILABLE_SINCE_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER, P_THRESHOLD NUMBER);
10: PROCEDURE GET_CURRENT_LAST_PROJECT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER);
11: PROCEDURE GET_NEXT_ASSIGNMENT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER);
12:
13:

Line 10: PROCEDURE GET_CURRENT_LAST_PROJECT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER);

6: G_AVL_THRESHOLD_VAL NUMBER;
7:
8: -- FORWARD DECLARATION.
9: PROCEDURE GET_AVAILABLE_SINCE_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER, P_THRESHOLD NUMBER);
10: PROCEDURE GET_CURRENT_LAST_PROJECT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER);
11: PROCEDURE GET_NEXT_ASSIGNMENT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER);
12:
13:
14:

Line 11: PROCEDURE GET_NEXT_ASSIGNMENT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER);

7:
8: -- FORWARD DECLARATION.
9: PROCEDURE GET_AVAILABLE_SINCE_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER, P_THRESHOLD NUMBER);
10: PROCEDURE GET_CURRENT_LAST_PROJECT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER);
11: PROCEDURE GET_NEXT_ASSIGNMENT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER);
12:
13:
14:
15: /****************************************************

Line 1457: ) RETURN PJI_REP_RA5_TBL

1453: P_AVL_DAYS IN NUMBER,
1454: P_AS_OF_DATE IN NUMBER,
1455: P_PERIOD_TYPE IN VARCHAR2,
1456: P_VIEW_BY IN VARCHAR2
1457: ) RETURN PJI_REP_RA5_TBL
1458: IS
1459: PRAGMA AUTONOMOUS_TRANSACTION;
1460: L_AVL_RES_DET_TBL PJI_REP_RA5_TBL := PJI_REP_RA5_TBL();
1461: L_AS_OF_DATE NUMBER := P_AS_OF_DATE;

Line 1460: L_AVL_RES_DET_TBL PJI_REP_RA5_TBL := PJI_REP_RA5_TBL();

1456: P_VIEW_BY IN VARCHAR2
1457: ) RETURN PJI_REP_RA5_TBL
1458: IS
1459: PRAGMA AUTONOMOUS_TRANSACTION;
1460: L_AVL_RES_DET_TBL PJI_REP_RA5_TBL := PJI_REP_RA5_TBL();
1461: L_AS_OF_DATE NUMBER := P_AS_OF_DATE;
1462: L_MIN_DAYS NUMBER;
1463: L_MAX_DAYS NUMBER;
1464: G_LABOUR_UNITS VARCHAR2(40);

Line 1725: PROCEDURE GET_AVAILABLE_SINCE_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER, P_THRESHOLD NUMBER)

1721: END LOOP;
1722: X_PROJECTS_NAME := SUBSTR(l_Project_List, 1, 240);
1723: END GET_PROJECT_INFO;
1724:
1725: PROCEDURE GET_AVAILABLE_SINCE_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER, P_THRESHOLD NUMBER)
1726: AS
1727: l_As_Of_Date DATE:=TO_DATE(p_As_Of_Date, 'j');
1728: l_Week_Calendar_Type VARCHAR2(1):='E';
1729: l_Day_Calendar_Type VARCHAR2(1):='C';

Line 2198: PROCEDURE GET_CURRENT_LAST_PROJECT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER)

2194: END IF;
2195: END LOOP;
2196: END GET_AVAILABLE_SINCE_INFO;
2197:
2198: PROCEDURE GET_CURRENT_LAST_PROJECT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER)
2199: AS
2200: l_As_Of_Date DATE:=TO_DATE(p_As_Of_Date, 'j');
2201: l_Week_Calendar_Type VARCHAR2(1):='E';
2202: l_Day_Calendar_Type VARCHAR2(1):='C';

Line 2316: PROCEDURE GET_NEXT_ASSIGNMENT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER)

2312: END IF;
2313: END LOOP;
2314: END GET_CURRENT_LAST_PROJECT_INFO;
2315:
2316: PROCEDURE GET_NEXT_ASSIGNMENT_INFO(P_AVL_RES_DET_TBL IN OUT NOCOPY PJI_REP_RA5_TBL, P_AS_OF_DATE NUMBER)
2317: AS
2318: l_As_Of_Date DATE:=TO_DATE(p_As_Of_Date, 'j');
2319: l_Week_Calendar_Type VARCHAR2(1):='E';
2320: l_Day_Calendar_Type VARCHAR2(1):='C';