eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PMV_AVL dependencies on PJI_REP_RA5

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 1410: PROCEDURE GET_SQL_PJI_REP_RA5 (P_PAGE_PARAMETER_TBL IN BIS_PMV_PAGE_PARAMETER_TBL

1406: /****************************************************
1407: * RA5: AVAILABLE RESOURCE DETAILS REPORT FUNCTIONS
1408: ****************************************************/
1409:
1410: PROCEDURE GET_SQL_PJI_REP_RA5 (P_PAGE_PARAMETER_TBL IN BIS_PMV_PAGE_PARAMETER_TBL
1411: , X_PMV_SQL OUT NOCOPY VARCHAR2
1412: , X_PMV_OUTPUT OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1413: IS
1414: BEGIN

Line 1438: P_REGION_CODE => 'PJI_REP_RA5',

1434: FACT.TOT_WTD_A "PJI_REP_MSR_29",
1435: FACT.CONF_WTD_S "PJI_REP_MSR_30"'
1436: ,P_SQL_STATEMENT => X_PMV_SQL
1437: ,P_PMV_OUTPUT => X_PMV_OUTPUT,
1438: P_REGION_CODE => 'PJI_REP_RA5',
1439: P_PLSQL_DRIVER => 'PJI_PMV_AVL.PLSQLDRIVER_RA5',
1440: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
1441: '<>, ' ||
1442: '<>, ' ||

Line 1447: END GET_SQL_PJI_REP_RA5;

1443: '<>, ' ||
1444: '<>, ' ||
1445: '<>, '||
1446: '<>');
1447: END GET_SQL_PJI_REP_RA5;
1448:
1449: FUNCTION PLSQLDRIVER_RA5 (
1450: P_OPERATING_UNIT IN VARCHAR2 DEFAULT NULL,
1451: P_ORGANIZATION IN VARCHAR2,

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 1511: SELECT PJI_REP_RA5(

1507: END;
1508: END IF;
1509:
1510:
1511: SELECT PJI_REP_RA5(
1512: PERSON_NAME
1513: ,PERSON_ID
1514: ,NULL
1515: ,SUM(CAPACITY)

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';