APPS.PJI_PMV_UTLZ dependencies on PJI_REP_U8

Line 7015: PROCEDURE Get_SQL_PJI_REP_U8(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

7011: * The functions for report U8: Project Expected Utilization Detail
7012: *
7013: *****************************************************************************/
7014:
7015: PROCEDURE Get_SQL_PJI_REP_U8(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
7016: , x_PMV_Sql OUT NOCOPY VARCHAR2
7017: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7018: IS
7019: BEGIN

Line 7062: P_REGION_CODE => 'PJI_REP_U8',

7058: FACT.PJI_REP_TOTAL_11 "PJI_REP_TOTAL_11",
7059: FACT.PJI_REP_TOTAL_12 "PJI_REP_TOTAL_12" '
7060: ,P_SQL_STATEMENT => x_PMV_Sql
7061: ,P_PMV_OUTPUT => x_PMV_Output,
7062: P_REGION_CODE => 'PJI_REP_U8',
7063: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U8',
7064: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
7065: '<>, ' ||
7066: '<>, ' ||

Line 7063: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U8',

7059: FACT.PJI_REP_TOTAL_12 "PJI_REP_TOTAL_12" '
7060: ,P_SQL_STATEMENT => x_PMV_Sql
7061: ,P_PMV_OUTPUT => x_PMV_Output,
7062: P_REGION_CODE => 'PJI_REP_U8',
7063: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U8',
7064: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
7065: '<>, ' ||
7066: '<>, ' ||
7067: '<>, ' ||

Line 7072: END Get_SQL_PJI_REP_U8;

7068: '<>, ' ||
7069: '<>, ' ||
7070: '<>, ' ||
7071: '<>');
7072: END Get_SQL_PJI_REP_U8;
7073:
7074:
7075: FUNCTION PLSQLDriver_PJI_REP_U8 (
7076: p_operating_unit IN VARCHAR2 DEFAULT NULL

Line 7075: FUNCTION PLSQLDriver_PJI_REP_U8 (

7071: '<>');
7072: END Get_SQL_PJI_REP_U8;
7073:
7074:
7075: FUNCTION PLSQLDriver_PJI_REP_U8 (
7076: p_operating_unit IN VARCHAR2 DEFAULT NULL
7077: , p_organization IN VARCHAR2
7078: , p_as_of_date IN NUMBER
7079: , p_period_type IN VARCHAR2

Line 7084: )RETURN PJI_REP_U8_TBL

7080: , p_util_categories IN VARCHAR2 DEFAULT NULL
7081: , p_work_type IN VARCHAR2 DEFAULT NULL
7082: , p_job_level IN VARCHAR2 DEFAULT NULL
7083: , p_view_by IN VARCHAR2
7084: )RETURN PJI_REP_U8_TBL
7085: IS
7086: PRAGMA AUTONOMOUS_TRANSACTION;
7087: l_u8_tbl PJI_REP_U8_TBL:=PJI_REP_U8_TBL();
7088: l_job_level_param VARCHAR2(1);

Line 7087: l_u8_tbl PJI_REP_U8_TBL:=PJI_REP_U8_TBL();

7083: , p_view_by IN VARCHAR2
7084: )RETURN PJI_REP_U8_TBL
7085: IS
7086: PRAGMA AUTONOMOUS_TRANSACTION;
7087: l_u8_tbl PJI_REP_U8_TBL:=PJI_REP_U8_TBL();
7088: l_job_level_param VARCHAR2(1);
7089: l_util_categories_param VARCHAR2(1);
7090: l_util_percent_denom_prof VARCHAR(25);
7091: l_dft_util_percent_denom_prof VARCHAR(25) := 'CAPACITY';

Line 7161: SELECT PJI_REP_U8( resource_name

7157: *
7158: * If util_categories=null and job_level=null
7159: */
7160: IF l_util_categories_param = 'N' AND l_job_level_param = 'N' THEN
7161: SELECT PJI_REP_U8( resource_name
7162: ,resource_id
7163: ,SUM(expected_hours)
7164: ,SUM(capacity_hours)
7165: ,SUM(missing_hours)

Line 7327: SELECT PJI_REP_U8( resource_name

7323: /*
7324: * If util_categories=null and job_level<>null
7325: */
7326: ELSIF l_util_categories_param = 'N' AND l_job_level_param = 'Y' THEN
7327: SELECT PJI_REP_U8( resource_name
7328: ,resource_id
7329: ,SUM(expected_hours)
7330: ,SUM(capacity_hours)
7331: ,SUM(missing_hours)

Line 7497: SELECT PJI_REP_U8( resource_name

7493: /*
7494: * If util_categories<>null and job_level=null
7495: */
7496: ELSIF l_util_categories_param = 'Y' AND l_job_level_param = 'N' THEN
7497: SELECT PJI_REP_U8( resource_name
7498: ,resource_id
7499: ,SUM(expected_hours)
7500: ,SUM(capacity_hours-reduce_capacity_hours)
7501: ,SUM(missing_hours)

Line 7769: SELECT PJI_REP_U8( resource_name

7765: /*
7766: * If util_categories<>null and job_level<>null
7767: */
7768: ELSIF l_util_categories_param = 'Y' AND l_job_level_param = 'Y' THEN
7769: SELECT PJI_REP_U8( resource_name
7770: ,resource_id
7771: ,SUM(expected_hours)
7772: ,SUM(capacity_hours-reduce_capacity_hours)
7773: ,SUM(missing_hours)

Line 8152: END PLSQLDriver_PJI_REP_U8;

8148: COMMIT;
8149: RETURN l_u8_tbl;
8150:
8151:
8152: END PLSQLDriver_PJI_REP_U8;
8153:
8154:
8155: END PJI_PMV_UTLZ;