55: '<
56: END Get_SQL_PJI_REP_UAP1;
57:
58:
59: PROCEDURE Get_SQL_PJI_REP_U1(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
60: , x_PMV_Sql OUT NOCOPY VARCHAR2
61: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
62: IS
63: BEGIN
98: FACT.PJI_REP_TOTAL_13 "PJI_REP_TOTAL_7",
99: FACT.PJI_REP_TOTAL_11 "PJI_REP_TOTAL_8" '
100: ,P_SQL_STATEMENT => x_PMV_Sql
101: ,P_PMV_OUTPUT => x_PMV_Output,
102: P_REGION_CODE => 'PJI_REP_U1',
103: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U1',
104: P_PLSQL_DRIVER_PARAMS => '<
105: '<
106: '<
109: '<
110: '<
111: '<
112: '<
113: END Get_SQL_PJI_REP_U1;
114:
115:
116: PROCEDURE Get_SQL_PJI_REP_U2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
117: , x_PMV_Sql OUT NOCOPY VARCHAR2
340: p_view_by IN VARCHAR2,
341: p_utilization_category IN VARCHAR2 DEFAULT NULL,
342: p_work_type IN VARCHAR2 DEFAULT NULL,
343: p_job_level IN VARCHAR2 DEFAULT NULL
344: ) RETURN PJI_REP_U1_TBL
345: IS
346: PRAGMA AUTONOMOUS_TRANSACTION;
347: l_u1_tbl PJI_REP_U1_TBL:=PJI_REP_U1_TBL();
348: l_util_category_flag VARCHAR2(1);
343: p_job_level IN VARCHAR2 DEFAULT NULL
344: ) RETURN PJI_REP_U1_TBL
345: IS
346: PRAGMA AUTONOMOUS_TRANSACTION;
347: l_u1_tbl PJI_REP_U1_TBL:=PJI_REP_U1_TBL();
348: l_util_category_flag VARCHAR2(1);
349: l_job_flag VARCHAR2(1);
350: l_denominator VARCHAR2(25);
351: l_labor_unit VARCHAR2(40);
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,
419: organization_id,
420: time_id,
421: time_key,
422: util_category_id,
633: , P_VIEW_BY => p_view_by
634: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
635:
636:
637: SELECT PJI_REP_U1(org_id,
638: organization_id,
639: time_id,
640: time_key,
641: util_category_id,
992: , P_VIEW_BY => p_view_by
993: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
994:
995:
996: SELECT PJI_REP_U1(org_id,
997: organization_id,
998: time_id,
999: time_key,
1000: util_category_id,
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,
1224: time_key,
1225: util_category_id,