APPS.PJI_PMV_UTLZ dependencies on PJI_REP_U7

Line 6344: PROCEDURE Get_SQL_PJI_REP_U7(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

6340: *
6341: * The functions for report U7: Project Scheduled Utilization Detail
6342: *
6343: *****************************************************************************/
6344: PROCEDURE Get_SQL_PJI_REP_U7(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
6345: , x_PMV_Sql OUT NOCOPY VARCHAR2
6346: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
6347: IS
6348: BEGIN

Line 6384: P_REGION_CODE => 'PJI_REP_U7',

6380: FACT.PJI_REP_TOTAL_11 "PJI_REP_TOTAL_11",
6381: FACT.PJI_REP_TOTAL_12 "PJI_REP_TOTAL_12" '
6382: ,P_SQL_STATEMENT => x_PMV_Sql
6383: ,P_PMV_OUTPUT => x_PMV_Output,
6384: P_REGION_CODE => 'PJI_REP_U7',
6385: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U7',
6386: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
6387: '<>, ' ||
6388: '<>, ' ||

Line 6385: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U7',

6381: FACT.PJI_REP_TOTAL_12 "PJI_REP_TOTAL_12" '
6382: ,P_SQL_STATEMENT => x_PMV_Sql
6383: ,P_PMV_OUTPUT => x_PMV_Output,
6384: P_REGION_CODE => 'PJI_REP_U7',
6385: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U7',
6386: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
6387: '<>, ' ||
6388: '<>, ' ||
6389: '<>, ' ||

Line 6394: END Get_SQL_PJI_REP_U7;

6390: '<>, ' ||
6391: '<>, ' ||
6392: '<>, ' ||
6393: '<>');
6394: END Get_SQL_PJI_REP_U7;
6395:
6396:
6397: FUNCTION PLSQLDriver_PJI_REP_U7 (
6398: p_operating_unit IN VARCHAR2 DEFAULT NULL

Line 6397: FUNCTION PLSQLDriver_PJI_REP_U7 (

6393: '<>');
6394: END Get_SQL_PJI_REP_U7;
6395:
6396:
6397: FUNCTION PLSQLDriver_PJI_REP_U7 (
6398: p_operating_unit IN VARCHAR2 DEFAULT NULL
6399: , p_organization IN VARCHAR2
6400: , p_as_of_date IN NUMBER
6401: , p_period_type IN VARCHAR2

Line 6406: )RETURN PJI_REP_U7_TBL

6402: , p_util_categories IN VARCHAR2 DEFAULT NULL
6403: , p_work_type IN VARCHAR2 DEFAULT NULL
6404: , p_job_level IN VARCHAR2 DEFAULT NULL
6405: , p_view_by IN VARCHAR2
6406: )RETURN PJI_REP_U7_TBL
6407: IS
6408: PRAGMA AUTONOMOUS_TRANSACTION;
6409: l_u7_tbl PJI_REP_U7_TBL:=PJI_REP_U7_TBL();
6410: l_job_level_param VARCHAR2(1);

Line 6409: l_u7_tbl PJI_REP_U7_TBL:=PJI_REP_U7_TBL();

6405: , p_view_by IN VARCHAR2
6406: )RETURN PJI_REP_U7_TBL
6407: IS
6408: PRAGMA AUTONOMOUS_TRANSACTION;
6409: l_u7_tbl PJI_REP_U7_TBL:=PJI_REP_U7_TBL();
6410: l_job_level_param VARCHAR2(1);
6411: l_util_categories_param VARCHAR2(1);
6412: l_util_percent_denom_prof VARCHAR(25);
6413: l_dft_util_percent_denom_prof VARCHAR(25) := 'CAPACITY';

Line 6465: -- insert into pji_pmv_generated_sql values('PLSQLDriver_PJI_REP_U7 1');

6461: EXCEPTION WHEN OTHERS THEN
6462: l_labor_unit := null;
6463: END;
6464:
6465: -- insert into pji_pmv_generated_sql values('PLSQLDriver_PJI_REP_U7 1');
6466: -- commit;
6467:
6468: /*
6469: * determine the fact tables you choose to run the database query on.

Line 6475: SELECT PJI_REP_U7( resource_name

6471: * If util_categories=null and job_level=null
6472: */
6473:
6474: IF l_util_categories_param = 'N' AND l_job_level_param = 'N' THEN
6475: SELECT PJI_REP_U7( resource_name
6476: , resource_id
6477: , SUM(scheduled_hours)
6478: , SUM(capacity_hours)
6479: , SUM(confirmed_billable_hours)

Line 6566: SELECT PJI_REP_U7( resource_name

6562: /*
6563: * If util_categories=null and job_level<>null
6564: */
6565: ELSIF l_util_categories_param = 'N' AND l_job_level_param = 'Y' THEN
6566: SELECT PJI_REP_U7( resource_name
6567: , resource_id
6568: , SUM(scheduled_hours)
6569: , SUM(capacity_hours)
6570: , SUM(confirmed_billable_hours)

Line 6661: SELECT PJI_REP_U7( resource_name

6657: /*
6658: * If util_categories<>null and job_level=null
6659: */
6660: ELSIF l_util_categories_param = 'Y' AND l_job_level_param = 'N' THEN
6661: SELECT PJI_REP_U7( resource_name
6662: , resource_id
6663: , SUM(scheduled_hours)
6664: , SUM(capacity_hours-sch_reduce_capacity_hours)
6665: , SUM(confirmed_billable_hours)

Line 6798: SELECT PJI_REP_U7( resource_name

6794: /*
6795: * If util_categories<>null and job_level<>null
6796: */
6797: ELSIF l_util_categories_param = 'Y' AND l_job_level_param = 'Y' THEN
6798: SELECT PJI_REP_U7( resource_name
6799: , resource_id
6800: , SUM(scheduled_hours)
6801: , SUM(capacity_hours-sch_reduce_capacity_hours)
6802: , SUM(confirmed_billable_hours)

Line 7006: END PLSQLDriver_PJI_REP_U7;

7002: COMMIT;
7003: RETURN l_u7_tbl;
7004:
7005:
7006: END PLSQLDriver_PJI_REP_U7;
7007:
7008:
7009: /*****************************************************************************
7010: *