APPS.PJI_PMV_UTLZ dependencies on PJI_REP_U4

Line 214: PROCEDURE Get_SQL_PJI_REP_U4(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

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
216: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
217: IS
218: l_PMV_Rec BIS_QUERY_ATTRIBUTES;

Line 259: P_REGION_CODE => 'PJI_REP_U4',

255: FACT.PJI_REP_TOTAL_16 "PJI_REP_TOTAL_14",
256: FACT.PJI_REP_TOTAL_17 "PJI_REP_TOTAL_15" '
257: ,P_SQL_STATEMENT => x_PMV_Sql
258: ,P_PMV_OUTPUT => x_PMV_Output,
259: P_REGION_CODE => 'PJI_REP_U4',
260: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_U4',
261: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
262: '<>, ' ||
263: '<>, ' ||

Line 279: END Get_SQL_PJI_REP_U4;

275:
276: x_PMV_Output.EXTEND();
277: x_PMV_Output(x_PMV_Output.COUNT):=l_PMV_Rec;
278:
279: END Get_SQL_PJI_REP_U4;
280:
281:
282: PROCEDURE Get_SQL_PJI_REP_U5(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
283: , x_PMV_Sql OUT NOCOPY VARCHAR2

Line 3507: ) RETURN PJI_REP_U4_TBL

3503: p_utilization_category IN VARCHAR2 DEFAULT NULL,
3504: p_work_type IN VARCHAR2 DEFAULT NULL,
3505: p_job_level IN VARCHAR2 DEFAULT NULL,
3506: p_flag IN VARCHAR2
3507: ) RETURN PJI_REP_U4_TBL
3508: IS
3509: PRAGMA AUTONOMOUS_TRANSACTION;
3510: l_u4_tbl PJI_REP_U4_TBL:=PJI_REP_U4_TBL();
3511: l_util_category_flag VARCHAR2(1);

Line 3510: l_u4_tbl PJI_REP_U4_TBL:=PJI_REP_U4_TBL();

3506: p_flag IN VARCHAR2
3507: ) RETURN PJI_REP_U4_TBL
3508: IS
3509: PRAGMA AUTONOMOUS_TRANSACTION;
3510: l_u4_tbl PJI_REP_U4_TBL:=PJI_REP_U4_TBL();
3511: l_util_category_flag VARCHAR2(1);
3512: l_job_flag VARCHAR2(1);
3513: l_denominator VARCHAR2(25);
3514: l_labor_unit VARCHAR2(40);

Line 3590: SELECT PJI_REP_U4(org_id,

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,
3591: organization_id,
3592: time_id,
3593: time_key,
3594: util_category_id,

Line 3885: SELECT PJI_REP_U4(org_id,

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,
3886: organization_id,
3887: time_id,
3888: time_key,
3889: util_category_id,

Line 4410: SELECT PJI_REP_U4(org_id,

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,
4411: organization_id,
4412: time_id,
4413: time_key,
4414: util_category_id,

Line 4755: SELECT PJI_REP_U4(org_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,
4758: time_key,
4759: util_category_id,

Line 5375: --Calculated columns for PJI_REP_U4

5371: l_prior_scheduled_denominator := l_prior_scheduled_denominator + nvl(l_u4_tbl(i).prior_scheduled_denominator,0);
5372:
5373: --Calculated column processing is done below
5374: --L-Top-Org is not done here
5375: --Calculated columns for PJI_REP_U4
5376: IF nvl(l_u4_tbl(i).scheduled_denominator,0) <> 0 THEN
5377: l_u4_tbl(i).sch_util_percent := 100 * (l_u4_tbl(i).scheduled_util_hours / l_u4_tbl(i).scheduled_denominator);
5378: l_u4_tbl(i).bill_util_percent := 100 * (l_u4_tbl(i).conf_billable_hours / l_u4_tbl(i).scheduled_denominator);
5379: l_u4_tbl(i).nonbill_util_percent := 100 * (l_u4_tbl(i).conf_nonbillable_hours / l_u4_tbl(i).scheduled_denominator);