DBA Data[Home] [Help]

APPS.PJI_PMV_AVL dependencies on PJI_PMV_UTIL

Line 652: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W0',ID,p_operating_unit,l_threshold)

648:
649: SELECT PJI_REP_RA2(
650: ORGANIZATION_ID
651: ,SUM(CURR_AVL)
652: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W0',ID,p_operating_unit,l_threshold)
653: ,SUM(TOTAL_RESOURCES)
654: ,SUM(WEEK_1)
655: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W1',ID,p_operating_unit,l_threshold)
656: ,SUM(WEEK_2)

Line 655: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W1',ID,p_operating_unit,l_threshold)

651: ,SUM(CURR_AVL)
652: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W0',ID,p_operating_unit,l_threshold)
653: ,SUM(TOTAL_RESOURCES)
654: ,SUM(WEEK_1)
655: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W1',ID,p_operating_unit,l_threshold)
656: ,SUM(WEEK_2)
657: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W2',ID,p_operating_unit,l_threshold)
658: ,SUM(WEEK_3)
659: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W3',ID,p_operating_unit,l_threshold)

Line 657: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W2',ID,p_operating_unit,l_threshold)

653: ,SUM(TOTAL_RESOURCES)
654: ,SUM(WEEK_1)
655: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W1',ID,p_operating_unit,l_threshold)
656: ,SUM(WEEK_2)
657: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W2',ID,p_operating_unit,l_threshold)
658: ,SUM(WEEK_3)
659: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W3',ID,p_operating_unit,l_threshold)
660: ,SUM(WEEK_4)
661: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W4',ID,p_operating_unit,l_threshold)

Line 659: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W3',ID,p_operating_unit,l_threshold)

655: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W1',ID,p_operating_unit,l_threshold)
656: ,SUM(WEEK_2)
657: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W2',ID,p_operating_unit,l_threshold)
658: ,SUM(WEEK_3)
659: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W3',ID,p_operating_unit,l_threshold)
660: ,SUM(WEEK_4)
661: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W4',ID,p_operating_unit,l_threshold)
662: ,NULL
663: ,NULL

Line 661: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W4',ID,p_operating_unit,l_threshold)

657: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W2',ID,p_operating_unit,l_threshold)
658: ,SUM(WEEK_3)
659: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W3',ID,p_operating_unit,l_threshold)
660: ,SUM(WEEK_4)
661: ,PJI_PMV_UTIL.ra2_ra5_url(p_as_of_date,'W4',ID,p_operating_unit,l_threshold)
662: ,NULL
663: ,NULL
664: ,NULL
665: ,NULL

Line 1317: ,PJI_PMV_UTIL.ra4_ra5_url(TIME_ID, p_organization, p_operating_unit, l_threshold, p_period_type)

1313: , 3, AVL_BKT3
1314: , 4, AVL_BKT4
1315: , 5, AVL_BKT5
1316: , 0))
1317: ,PJI_PMV_UTIL.ra4_ra5_url(TIME_ID, p_organization, p_operating_unit, l_threshold, p_period_type)
1318: ,NULL
1319: ,NULL)
1320: BULK COLLECT INTO L_RA4_TBL
1321: FROM ( /* Bug 3515594 */

Line 1660: -- PJI_PMV_UTIL.GET_AVAILABLE_FROM

1656: END;
1657: -- NOTE TO VIJAY M.
1658: -- PLACE CALLS TO FOLLOWING API'S TO POPULATE THE COLUMNS
1659: -- (AVAILABLE_SINCE, CURR_LAST_PROJ, NEXT_PROJ, NEXT_ASGMT_DATE):
1660: -- PJI_PMV_UTIL.GET_AVAILABLE_FROM
1661: -- PJI_PMV_UTIL.GET_PROJECTS
1662: -- PJI_PMV_UTIL.GET_NEXT_ASGMT_DATE
1663: -- SINCE THE LOGIC FOR THE ABOVE API'S ARE BOUND TO CHANGE, THE
1664: -- CALLS TO ABOVE APIS ARE NOT BELOW.

Line 1661: -- PJI_PMV_UTIL.GET_PROJECTS

1657: -- NOTE TO VIJAY M.
1658: -- PLACE CALLS TO FOLLOWING API'S TO POPULATE THE COLUMNS
1659: -- (AVAILABLE_SINCE, CURR_LAST_PROJ, NEXT_PROJ, NEXT_ASGMT_DATE):
1660: -- PJI_PMV_UTIL.GET_AVAILABLE_FROM
1661: -- PJI_PMV_UTIL.GET_PROJECTS
1662: -- PJI_PMV_UTIL.GET_NEXT_ASGMT_DATE
1663: -- SINCE THE LOGIC FOR THE ABOVE API'S ARE BOUND TO CHANGE, THE
1664: -- CALLS TO ABOVE APIS ARE NOT BELOW.
1665: IF NVL((L_AVL_RES_DET_TBL(I).CAPACITY_A-L_AVL_RES_DET_TBL(I).REDUCE_CAP_A),0) <> 0 THEN

Line 1662: -- PJI_PMV_UTIL.GET_NEXT_ASGMT_DATE

1658: -- PLACE CALLS TO FOLLOWING API'S TO POPULATE THE COLUMNS
1659: -- (AVAILABLE_SINCE, CURR_LAST_PROJ, NEXT_PROJ, NEXT_ASGMT_DATE):
1660: -- PJI_PMV_UTIL.GET_AVAILABLE_FROM
1661: -- PJI_PMV_UTIL.GET_PROJECTS
1662: -- PJI_PMV_UTIL.GET_NEXT_ASGMT_DATE
1663: -- SINCE THE LOGIC FOR THE ABOVE API'S ARE BOUND TO CHANGE, THE
1664: -- CALLS TO ABOVE APIS ARE NOT BELOW.
1665: IF NVL((L_AVL_RES_DET_TBL(I).CAPACITY_A-L_AVL_RES_DET_TBL(I).REDUCE_CAP_A),0) <> 0 THEN
1666: L_AVL_RES_DET_TBL(I).ACT_UTIL_PER := (L_AVL_RES_DET_TBL(I).TOT_WTD_A/

Line 1680: L_AVL_RES_DET_TBL(I).JOB_LEVEL := PJI_PMV_UTIL.GET_JOB_LEVEL( L_AVL_RES_DET_TBL(I).PERSON_ID, TO_DATE(P_AS_OF_DATE,'J'));

1676: L_AVL_RES_DET_TBL(I).ACT_UTIL_PER := NULL;
1677: END IF;
1678:
1679: IF L_AVL_RES_DET_TBL(I).PERSON_ID IS NOT NULL THEN
1680: L_AVL_RES_DET_TBL(I).JOB_LEVEL := PJI_PMV_UTIL.GET_JOB_LEVEL( L_AVL_RES_DET_TBL(I).PERSON_ID, TO_DATE(P_AS_OF_DATE,'J'));
1681: ELSE
1682: L_AVL_RES_DET_TBL(I).JOB_LEVEL := NULL;
1683: END IF;
1684: END LOOP;