APPS.PJI_PMV_UTLZ dependencies on PJI_REP_U3

Line 159: PROCEDURE Get_SQL_PJI_REP_U3(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

155: '<>');
156: END Get_SQL_PJI_REP_U2;
157:
158:
159: PROCEDURE Get_SQL_PJI_REP_U3(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
160: , x_PMV_Sql OUT NOCOPY VARCHAR2
161: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
162: IS
163: BEGIN

Line 201: P_REGION_CODE => 'PJI_REP_U3',

197: FACT.PJI_REP_TOTAL_13 "PJI_REP_TOTAL_13",
198: FACT.PJI_REP_TOTAL_14 "PJI_REP_TOTAL_14" '
199: ,P_SQL_STATEMENT => x_PMV_Sql
200: ,P_PMV_OUTPUT => x_PMV_Output,
201: P_REGION_CODE => 'PJI_REP_U3',
202: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U3',
203: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
204: '<>, ' ||
205: '<>, ' ||

Line 211: END Get_SQL_PJI_REP_U3;

207: '<>,'||
208: '<>, ' ||
209: '<>, ' ||
210: '<>');
211: END Get_SQL_PJI_REP_U3;
212:
213:
214: PROCEDURE Get_SQL_PJI_REP_U4(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
215: , x_PMV_Sql OUT NOCOPY VARCHAR2

Line 2138: ) RETURN PJI_REP_U3_TBL

2134: p_view_by IN VARCHAR2,
2135: p_utilization_category IN VARCHAR2 DEFAULT NULL,
2136: p_work_type IN VARCHAR2 DEFAULT NULL,
2137: p_job_level IN VARCHAR2 DEFAULT NULL
2138: ) RETURN PJI_REP_U3_TBL
2139: IS
2140: PRAGMA AUTONOMOUS_TRANSACTION;
2141: l_u3_tbl PJI_REP_U3_TBL:=PJI_REP_U3_TBL();
2142: l_util_category_flag VARCHAR2(1);

Line 2141: l_u3_tbl PJI_REP_U3_TBL:=PJI_REP_U3_TBL();

2137: p_job_level IN VARCHAR2 DEFAULT NULL
2138: ) RETURN PJI_REP_U3_TBL
2139: IS
2140: PRAGMA AUTONOMOUS_TRANSACTION;
2141: l_u3_tbl PJI_REP_U3_TBL:=PJI_REP_U3_TBL();
2142: l_util_category_flag VARCHAR2(1);
2143: l_job_flag VARCHAR2(1);
2144: l_denominator VARCHAR2(25);
2145: l_labor_unit VARCHAR2(40);

Line 2200: SELECT PJI_REP_U3(org_id,

2196: , P_VIEW_BY => p_view_by
2197: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
2198:
2199:
2200: SELECT PJI_REP_U3(org_id,
2201: organization_id,
2202: time_id,
2203: time_key,
2204: util_category_id,

Line 2373: SELECT PJI_REP_U3(org_id,

2369: , P_VIEW_BY => p_view_by
2370: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
2371:
2372:
2373: SELECT PJI_REP_U3(org_id,
2374: organization_id,
2375: time_id,
2376: time_key,
2377: util_category_id,

Line 2716: SELECT PJI_REP_U3(org_id,

2712: , P_VIEW_BY => p_view_by
2713: , P_TOP_ORGANIZATION_NAME => l_Top_Organization_Name );
2714:
2715:
2716: SELECT PJI_REP_U3(org_id,
2717: organization_id,
2718: time_id,
2719: time_key,
2720: util_category_id,

Line 2921: SELECT PJI_REP_U3(org_id,

2917:
2918: PJI_PMV_ENGINE.Convert_Organization(p_Organization, p_view_by);
2919:
2920:
2921: SELECT PJI_REP_U3(org_id,
2922: organization_id,
2923: time_id,
2924: time_key,
2925: util_category_id,