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_UTLZ dependencies on PJI_PMV_ENGINE

Line 10: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

6: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7: IS
8: BEGIN
9:
10: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
11: ,P_SELECT_LIST =>
12: ' FACT.BILL_HOURS_PERCENT "PJI_REP_MSR_3",
13: FACT.CHANGE_PERCENT_2 "PJI_REP_MSR_20",
14: FACT.ACT_UTIL_PERCENT "PJI_REP_MSR_2",

Line 65: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

61: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
62: IS
63: BEGIN
64:
65: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
66: ,P_SELECT_LIST =>
67: ' FACT.ACT_UTIL_PERCENT "PJI_REP_MSR_1",
68: FACT.CHANGE_PERCENT_1 "PJI_REP_MSR_19",
69: FACT.SCH_UTIL_PERCENT "PJI_REP_MSR_2",

Line 122: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

118: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
119: IS
120: BEGIN
121:
122: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
123: ,P_SELECT_LIST =>
124: ' FACT.ACTUAL_CAPACITY_HOURS "PJI_REP_MSR_1",
125: FACT.MISSING_HOURS "PJI_REP_MSR_2",
126: FACT.ACTUAL_UTILIZATION_HOURS "PJI_REP_MSR_3",

Line 165: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

161: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
162: IS
163: BEGIN
164:
165: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
166: ,P_SELECT_LIST =>
167: ' FACT.ACTUAL_HOURS "PJI_REP_MSR_11",
168: FACT.CAPACITY_HOURS "PJI_REP_MSR_16",
169: FACT.MISSING_HOURS "PJI_REP_MSR_15",

Line 221: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

217: IS
218: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
219: BEGIN
220:
221: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
222: ,P_SELECT_LIST =>
223: ' FACT.SCHEDULED_HOURS "PJI_REP_MSR_17",
224: FACT.SCHEDULED_CAPACITY_HOURS "PJI_REP_MSR_18",
225: FACT.SCHEDULED_UTIL_HOURS "PJI_REP_MSR_1",

Line 289: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

285: IS
286: l_PMV_Rec BIS_QUERY_ATTRIBUTES;
287: BEGIN
288:
289: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
290: ,P_SELECT_LIST =>
291: ' FACT.EXPECTED_HOURS "PJI_REP_MSR_17",
292: FACT.EXPECTED_CAPACITY_HOURS "PJI_REP_MSR_18",
293: FACT.EXP_ACT_UTIL_PERCENT "PJI_REP_MSR_1",

Line 377: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);

373: l_Top_Org_Index NUMBER;
374: l_Top_Organization_Name VARCHAR2(240);
375:
376: BEGIN
377: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
378: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y', 'DBI', p_comparator_type, 'N');
379: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
380: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
381:

Line 378: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y', 'DBI', p_comparator_type, 'N');

374: l_Top_Organization_Name VARCHAR2(240);
375:
376: BEGIN
377: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
378: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y', 'DBI', p_comparator_type, 'N');
379: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
380: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
381:
382: /*

Line 379: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);

375:
376: BEGIN
377: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
378: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y', 'DBI', p_comparator_type, 'N');
379: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
380: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
381:
382: /*
383: * Get Utilization percentage denominator profile value

Line 380: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);

376: BEGIN
377: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
378: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y', 'DBI', p_comparator_type, 'N');
379: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
380: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
381:
382: /*
383: * Get Utilization percentage denominator profile value
384: */

Line 414: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

410: AND default_flag = 'Y';
411:
412: IF l_util_category_flag = 'N' AND l_job_flag = 'N' THEN
413:
414: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
415: , P_VIEW_BY => p_view_by
416: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
417:
418: SELECT PJI_REP_U1(org_id,

Line 632: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

628: job_level_id;
629:
630: ELSIF l_job_flag = 'N' THEN
631:
632: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
633: , P_VIEW_BY => p_view_by
634: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
635:
636:

Line 991: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

987:
988:
989: ELSIF l_util_category_flag = 'N' THEN
990:
991: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
992: , P_VIEW_BY => p_view_by
993: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
994:
995:

Line 1219: PJI_PMV_ENGINE.Convert_Organization( p_Organization, p_view_by);

1215: job_level_id;
1216:
1217: ELSE
1218:
1219: PJI_PMV_ENGINE.Convert_Organization( p_Organization, p_view_by);
1220:
1221: SELECT PJI_REP_U1(org_id,
1222: organization_id,
1223: time_id,

Line 1934: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);

1930: l_labor_unit VARCHAR2(40);
1931: l_Top_Org_Index NUMBER;
1932: l_Top_Organization_Name VARCHAR2(240);
1933: BEGIN
1934: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
1935: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
1936: , P_VIEW_BY => p_view_by
1937: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
1938: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');

Line 1935: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

1931: l_Top_Org_Index NUMBER;
1932: l_Top_Organization_Name VARCHAR2(240);
1933: BEGIN
1934: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
1935: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
1936: , P_VIEW_BY => p_view_by
1937: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
1938: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
1939:

Line 1938: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');

1934: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
1935: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
1936: , P_VIEW_BY => p_view_by
1937: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
1938: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
1939:
1940: /*
1941: * Get Utilization percentage denominator profile value
1942: */

Line 2164: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);

2160: l_prior_actual_denominator NUMBER := 0;
2161: l_Top_Org_Index NUMBER;
2162: l_Top_Organization_Name VARCHAR2(240);
2163: BEGIN
2164: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
2165: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
2166: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
2167: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
2168:

Line 2165: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');

2161: l_Top_Org_Index NUMBER;
2162: l_Top_Organization_Name VARCHAR2(240);
2163: BEGIN
2164: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
2165: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
2166: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
2167: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
2168:
2169: /*

Line 2166: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);

2162: l_Top_Organization_Name VARCHAR2(240);
2163: BEGIN
2164: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
2165: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
2166: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
2167: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
2168:
2169: /*
2170: * Get Utilization percentage denominator profile value

Line 2167: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);

2163: BEGIN
2164: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
2165: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
2166: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
2167: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
2168:
2169: /*
2170: * Get Utilization percentage denominator profile value
2171: */

Line 2195: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

2191: END;
2192:
2193: IF l_util_category_flag = 'N' AND l_job_flag = 'N' THEN
2194:
2195: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
2196: , P_VIEW_BY => p_view_by
2197: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
2198:
2199:

Line 2368: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

2364: job_level_id;
2365:
2366: ELSIF l_job_flag = 'N' THEN
2367:
2368: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
2369: , P_VIEW_BY => p_view_by
2370: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
2371:
2372:

Line 2711: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

2707:
2708:
2709: ELSIF l_util_category_flag = 'N' THEN
2710:
2711: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
2712: , P_VIEW_BY => p_view_by
2713: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
2714:
2715:

Line 2918: PJI_PMV_ENGINE.Convert_Organization(p_Organization, p_view_by);

2914: job_level_id;
2915:
2916: ELSE
2917:
2918: PJI_PMV_ENGINE.Convert_Organization(p_Organization, p_view_by);
2919:
2920:
2921: SELECT PJI_REP_U3(org_id,
2922: organization_id,

Line 3551: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);

3547: l_prior_scheduled_denominator NUMBER := 0;
3548: l_Top_Org_Index NUMBER;
3549: l_Top_Organization_Name VARCHAR2(240);
3550: BEGIN
3551: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
3552: IF (p_flag = 'FALSE') THEN
3553: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
3554: ELSE PJI_PMV_ENGINE.Convert_Expected_Time (p_as_of_date, p_period_type, 'Y');
3555: END IF;

Line 3553: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');

3549: l_Top_Organization_Name VARCHAR2(240);
3550: BEGIN
3551: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
3552: IF (p_flag = 'FALSE') THEN
3553: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
3554: ELSE PJI_PMV_ENGINE.Convert_Expected_Time (p_as_of_date, p_period_type, 'Y');
3555: END IF;
3556:
3557: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);

Line 3554: ELSE PJI_PMV_ENGINE.Convert_Expected_Time (p_as_of_date, p_period_type, 'Y');

3550: BEGIN
3551: PJI_PMV_ENGINE.Convert_Operating_Unit (p_operating_unit, p_view_by);
3552: IF (p_flag = 'FALSE') THEN
3553: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
3554: ELSE PJI_PMV_ENGINE.Convert_Expected_Time (p_as_of_date, p_period_type, 'Y');
3555: END IF;
3556:
3557: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
3558: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);

Line 3557: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);

3553: PJI_PMV_ENGINE.Convert_Time (p_as_of_date, p_period_type, p_view_by, 'Y');
3554: ELSE PJI_PMV_ENGINE.Convert_Expected_Time (p_as_of_date, p_period_type, 'Y');
3555: END IF;
3556:
3557: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
3558: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
3559:
3560: /*
3561: * Get Utilization percentage denominator profile value

Line 3558: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);

3554: ELSE PJI_PMV_ENGINE.Convert_Expected_Time (p_as_of_date, p_period_type, 'Y');
3555: END IF;
3556:
3557: l_util_category_flag := PJI_PMV_ENGINE.Convert_Util_Category(p_work_type, p_utilization_category, p_view_by);
3558: l_job_flag := PJI_PMV_ENGINE.Convert_Job_Level(null, p_job_level, p_view_by);
3559:
3560: /*
3561: * Get Utilization percentage denominator profile value
3562: */

Line 3586: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

3582: END;
3583:
3584: IF l_util_category_flag = 'N' AND l_job_flag = 'N' THEN
3585:
3586: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
3587: , P_VIEW_BY => p_view_by
3588: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
3589:
3590: SELECT PJI_REP_U4(org_id,

Line 3881: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

3877: job_level_id;
3878:
3879: ELSIF l_job_flag = 'N' THEN
3880:
3881: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
3882: , P_VIEW_BY => p_view_by
3883: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
3884:
3885: SELECT PJI_REP_U4(org_id,

Line 4406: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization

4402: job_level_id;
4403:
4404: ELSIF l_util_category_flag = 'N' THEN
4405:
4406: PJI_PMV_ENGINE.Convert_Organization(P_TOP_ORGANIZATION_ID => p_Organization
4407: , P_VIEW_BY => p_view_by
4408: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
4409:
4410: SELECT PJI_REP_U4(org_id,

Line 4753: PJI_PMV_ENGINE.Convert_Organization(p_Organization, p_view_by);

4749: work_type_id,
4750: job_level_id;
4751: ELSE
4752:
4753: PJI_PMV_ENGINE.Convert_Organization(p_Organization, p_view_by);
4754:
4755: SELECT PJI_REP_U4(org_id,
4756: organization_id,
4757: time_id,

Line 5720: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

5716: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
5717: IS
5718: BEGIN
5719:
5720: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
5721: ,P_SELECT_LIST =>
5722: ' FACT.RESOURCE_NAME "VIEWBY",
5723: FACT.ACTUAL_HOURS "PJI_REP_MSR_2",
5724: FACT.CAPACITY_HOURS "PJI_REP_MSR_3",

Line 5796: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);

5792: /*
5793: * Place a call to all the parse API's which parse the parameters
5794: * passed by PMV and populate all the temporary tables.
5795: */
5796: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
5797: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
5798: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
5799:
5800: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);

Line 5797: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);

5793: * Place a call to all the parse API's which parse the parameters
5794: * passed by PMV and populate all the temporary tables.
5795: */
5796: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
5797: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
5798: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
5799:
5800: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
5801: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);

Line 5798: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);

5794: * passed by PMV and populate all the temporary tables.
5795: */
5796: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
5797: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
5798: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
5799:
5800: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
5801: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
5802:

Line 5800: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);

5796: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
5797: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
5798: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
5799:
5800: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
5801: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
5802:
5803: /*
5804: * Get Utilization percentage denominator profile value

Line 5801: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);

5797: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
5798: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
5799:
5800: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
5801: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
5802:
5803: /*
5804: * Get Utilization percentage denominator profile value
5805: */

Line 6350: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

6346: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
6347: IS
6348: BEGIN
6349:
6350: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
6351: ,P_SELECT_LIST =>
6352: ' FACT.RESOURCE_NAME "VIEWBY",
6353: FACT.SCHEDULED_HOURS "PJI_REP_MSR_2",
6354: FACT.CAPACITY_HOURS "PJI_REP_MSR_3",

Line 6432: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);

6428: /*
6429: * Place a call to all the parse API's which parse the parameters
6430: * passed by PMV and populate all the temporary tables.
6431: */
6432: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
6433: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
6434: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
6435:
6436: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);

Line 6433: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);

6429: * Place a call to all the parse API's which parse the parameters
6430: * passed by PMV and populate all the temporary tables.
6431: */
6432: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
6433: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
6434: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
6435:
6436: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
6437: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);

Line 6434: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);

6430: * passed by PMV and populate all the temporary tables.
6431: */
6432: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
6433: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
6434: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
6435:
6436: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
6437: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
6438:

Line 6436: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);

6432: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
6433: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
6434: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
6435:
6436: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
6437: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
6438:
6439:
6440: /*

Line 6437: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);

6433: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
6434: PJI_PMV_ENGINE.Convert_Time(p_as_of_date, p_period_type, p_view_by);
6435:
6436: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
6437: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
6438:
6439:
6440: /*
6441: * Get Utilization percentage denominator profile value

Line 7021: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl

7017: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7018: IS
7019: BEGIN
7020:
7021: PJI_PMV_ENGINE.Generate_SQL(P_PAGE_PARAMETER_TBL => p_page_parameter_tbl
7022: ,P_SELECT_LIST =>
7023: ' FACT.RESOURCE_NAME "VIEWBY",
7024: FACT.EXPECTED_HOURS "PJI_REP_MSR_2",
7025: FACT.CAPACITY_HOURS "PJI_REP_MSR_3",

Line 7122: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);

7118: /*
7119: * Place a call to all the parse API's which parse the parameters
7120: * passed by PMV and populate all the temporary tables.
7121: */
7122: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
7123: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
7124: PJI_PMV_ENGINE.Convert_Expected_Time(p_as_of_date, p_period_type, 'Y');
7125:
7126: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);

Line 7123: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);

7119: * Place a call to all the parse API's which parse the parameters
7120: * passed by PMV and populate all the temporary tables.
7121: */
7122: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
7123: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
7124: PJI_PMV_ENGINE.Convert_Expected_Time(p_as_of_date, p_period_type, 'Y');
7125:
7126: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
7127: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);

Line 7124: PJI_PMV_ENGINE.Convert_Expected_Time(p_as_of_date, p_period_type, 'Y');

7120: * passed by PMV and populate all the temporary tables.
7121: */
7122: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
7123: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
7124: PJI_PMV_ENGINE.Convert_Expected_Time(p_as_of_date, p_period_type, 'Y');
7125:
7126: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
7127: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
7128:

Line 7126: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);

7122: PJI_PMV_ENGINE.Convert_Operating_Unit(p_operating_unit, p_view_by);
7123: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
7124: PJI_PMV_ENGINE.Convert_Expected_Time(p_as_of_date, p_period_type, 'Y');
7125:
7126: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
7127: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
7128:
7129: /*
7130: * Get Utilization percentage denominator profile value

Line 7127: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);

7123: PJI_PMV_ENGINE.Convert_Organization(p_organization, p_view_by);
7124: PJI_PMV_ENGINE.Convert_Expected_Time(p_as_of_date, p_period_type, 'Y');
7125:
7126: l_util_categories_param := PJI_PMV_ENGINE.convert_util_category(p_work_type, p_util_categories, p_view_by);
7127: l_job_level_param := PJI_PMV_ENGINE.convert_job_level(null, p_job_level, p_view_by);
7128:
7129: /*
7130: * Get Utilization percentage denominator profile value
7131: */