APPS.PJI_PMV_UTLZ dependencies on PJI_REP_U6

Line 5714: PROCEDURE Get_SQL_PJI_REP_U6(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL

5710: * The functions for report U6: Project Actual Utilization Detail
5711: *
5712: *****************************************************************************/
5713:
5714: PROCEDURE Get_SQL_PJI_REP_U6(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
5715: , x_PMV_Sql OUT NOCOPY VARCHAR2
5716: , x_PMV_Output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
5717: IS
5718: BEGIN

Line 5749: P_REGION_CODE => 'PJI_REP_U6',

5745: FACT.PJI_REP_TOTAL_9 "PJI_REP_TOTAL_9",
5746: FACT.PJI_REP_TOTAL_10 "PJI_REP_TOTAL_10" '
5747: ,P_SQL_STATEMENT => x_PMV_Sql
5748: ,P_PMV_OUTPUT => x_PMV_Output,
5749: P_REGION_CODE => 'PJI_REP_U6',
5750: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U6',
5751: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
5752: '<>, ' ||
5753: '<>, ' ||

Line 5750: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U6',

5746: FACT.PJI_REP_TOTAL_10 "PJI_REP_TOTAL_10" '
5747: ,P_SQL_STATEMENT => x_PMV_Sql
5748: ,P_PMV_OUTPUT => x_PMV_Output,
5749: P_REGION_CODE => 'PJI_REP_U6',
5750: P_PLSQL_DRIVER => 'PJI_PMV_UTLZ.PLSQLDriver_PJI_REP_U6',
5751: P_PLSQL_DRIVER_PARAMS => '<>, ' ||
5752: '<>, ' ||
5753: '<>, ' ||
5754: '<>, ' ||

Line 5759: END Get_SQL_PJI_REP_U6;

5755: '<>, ' ||
5756: '<>, ' ||
5757: '<>, ' ||
5758: '<>');
5759: END Get_SQL_PJI_REP_U6;
5760:
5761:
5762: FUNCTION PLSQLDriver_PJI_REP_U6 (
5763: p_operating_unit IN VARCHAR2 DEFAULT NULL

Line 5762: FUNCTION PLSQLDriver_PJI_REP_U6 (

5758: '<>');
5759: END Get_SQL_PJI_REP_U6;
5760:
5761:
5762: FUNCTION PLSQLDriver_PJI_REP_U6 (
5763: p_operating_unit IN VARCHAR2 DEFAULT NULL
5764: , p_organization IN VARCHAR2
5765: , p_as_of_date IN NUMBER
5766: , p_period_type IN VARCHAR2

Line 5771: )RETURN PJI_REP_U6_TBL

5767: , p_util_categories IN VARCHAR2 DEFAULT NULL
5768: , p_work_type IN VARCHAR2 DEFAULT NULL
5769: , p_job_level IN VARCHAR2 DEFAULT NULL
5770: , p_view_by IN VARCHAR2
5771: )RETURN PJI_REP_U6_TBL
5772: IS
5773: PRAGMA AUTONOMOUS_TRANSACTION;
5774: l_u6_tbl PJI_REP_U6_TBL:=PJI_REP_U6_TBL();
5775: l_job_level_param VARCHAR2(1);

Line 5774: l_u6_tbl PJI_REP_U6_TBL:=PJI_REP_U6_TBL();

5770: , p_view_by IN VARCHAR2
5771: )RETURN PJI_REP_U6_TBL
5772: IS
5773: PRAGMA AUTONOMOUS_TRANSACTION;
5774: l_u6_tbl PJI_REP_U6_TBL:=PJI_REP_U6_TBL();
5775: l_job_level_param VARCHAR2(1);
5776: l_util_categories_param VARCHAR2(1);
5777: l_util_percent_denom_prof VARCHAR(25);
5778: l_dft_util_percent_denom_prof VARCHAR(25) := 'CAPACITY';

Line 5836: SELECT PJI_REP_U6( resource_name

5832: */
5833:
5834: IF l_util_categories_param = 'N' AND l_job_level_param = 'N' THEN
5835:
5836: SELECT PJI_REP_U6( resource_name
5837: , resource_id
5838: , SUM(actual_hours)
5839: , SUM(capacity_hours)
5840: , SUM(missing_hours)

Line 5921: SELECT PJI_REP_U6( resource_name

5917: * If util_categories=null and job_level<>null
5918: */
5919: ELSIF l_util_categories_param = 'N' AND l_job_level_param = 'Y' THEN
5920:
5921: SELECT PJI_REP_U6( resource_name
5922: , resource_id
5923: , SUM(actual_hours)
5924: , SUM(capacity_hours)
5925: , SUM(missing_hours)

Line 6009: SELECT PJI_REP_U6 ( resource_name

6005: * If util_categories<>null and job_level=null
6006: */
6007: ELSIF l_util_categories_param = 'Y' AND l_job_level_param = 'N' THEN
6008:
6009: SELECT PJI_REP_U6 ( resource_name
6010: , resource_id
6011: , SUM(actual_hours)
6012: , SUM(capacity_hours-act_reduce_capacity_hours)
6013: , SUM(missing_hours)

Line 6138: SELECT PJI_REP_U6 ( resource_name

6134: * If util_categories<>null and job_level<>null
6135: */
6136: ELSIF l_util_categories_param = 'Y' AND l_job_level_param = 'Y' THEN
6137:
6138: SELECT PJI_REP_U6 ( resource_name
6139: , resource_id
6140: , SUM(actual_hours)
6141: , SUM(capacity_hours-act_reduce_capacity_hours)
6142: , SUM(missing_hours)

Line 6335: END PLSQLDriver_PJI_REP_U6;

6331: */
6332: COMMIT;
6333: RETURN l_u6_tbl;
6334:
6335: END PLSQLDriver_PJI_REP_U6;
6336:
6337:
6338:
6339: /*****************************************************************************