eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_REP_UTIL dependencies on PJI_XBS_DENORM

Line 252: PJI_XBS_DENORM prg,

248: (
249: select /*+ ordered */ -- bug 13109678 : removed index hint
250: distinct(prg.SUP_ID) SUP_ID
251: from
252: PJI_XBS_DENORM prg,
253: PA_PROJECTS_ALL prj
254: where
255: prg.STRUCT_VERSION_ID is null and
256: prg.SUB_ID = p_wbs_version_id_tbl(l_i) and

Line 547: FROM pji_xbs_denorm denorm, pa_proj_elements emt,pa_proj_element_versions ver

543: SELECT denorm.sup_project_id,'N',denorm.sup_project_id,denorm.sup_emt_id,
544: denorm.sub_emt_id,'N',emt.name,DECODE(denorm.sub_level-sup_level,0,'N','Y'),DECODE(denorm.sub_leaf_flag,'Y','N','Y'),
545: SYSDATE, SYSDATE, 1, 1,
546: 0 ,p_element_version_id, ver.display_sequence,p_element_version_id, denorm.relationship_type
547: FROM pji_xbs_denorm denorm, pa_proj_elements emt,pa_proj_element_versions ver
548: WHERE 1=1
549: AND denorm.sup_project_id = p_project_id
550: AND denorm.struct_version_id = p_element_version_id
551: AND denorm.sub_level - denorm.sup_level<=1

Line 583: FROM pji_xbs_denorm denorm

579: , p_element_version_id
580: , ver.display_sequence
581: , p_element_version_id
582: , denorm.relationship_type
583: FROM pji_xbs_denorm denorm
584: , pa_proj_elements emt
585: ,pa_proj_element_versions ver
586: WHERE 1=1
587: AND denorm.sup_project_id = p_project_id

Line 605: FROM pji_xbs_denorm

601:
602:
603: SELECT COUNT(*)
604: INTO l_count
605: FROM pji_xbs_denorm
606: WHERE sup_project_id = p_project_id
607: AND sup_id = p_element_version_id
608: AND struct_type = 'PRG'
609: AND sub_level>sup_level

Line 677: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver, pa_proj_elements emt

673: ,p_element_version_id
674: , 0
675: , denorm.sup_id
676: , 'WF'
677: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver, pa_proj_elements emt
678: WHERE 1=1
679: AND denorm.sup_project_id = p_project_id
680: AND denorm.sup_id = p_element_version_id
681: AND denorm.struct_version_id IS NULL

Line 714: FROM pa_proj_elements emt, pji_xbs_denorm denorm,

710: ,p_element_version_id
711: , ver.display_sequence
712: ,denorm.struct_version_id
713: , denorm.relationship_type
714: FROM pa_proj_elements emt, pji_xbs_denorm denorm,
715: (SELECT sub_id wbs_version_id, sub_leaf_flag
716: FROM pji_xbs_denorm
717: WHERE 1=1
718: AND sup_project_id = p_project_id

Line 716: FROM pji_xbs_denorm

712: ,denorm.struct_version_id
713: , denorm.relationship_type
714: FROM pa_proj_elements emt, pji_xbs_denorm denorm,
715: (SELECT sub_id wbs_version_id, sub_leaf_flag
716: FROM pji_xbs_denorm
717: WHERE 1=1
718: AND sup_project_id = p_project_id
719: AND sup_id = p_element_version_id
720: AND struct_version_id IS NULL

Line 763: FROM pji_xbs_denorm denorm

759: , p_element_version_id
760: , ver.display_sequence
761: , denorm.struct_version_id
762: , denorm.relationship_type
763: FROM pji_xbs_denorm denorm
764: , pa_proj_elements emt
765: , (SELECT sub_id wbs_version_id, sub_leaf_flag
766: FROM pji_xbs_denorm
767: WHERE 1=1

Line 766: FROM pji_xbs_denorm

762: , denorm.relationship_type
763: FROM pji_xbs_denorm denorm
764: , pa_proj_elements emt
765: , (SELECT sub_id wbs_version_id, sub_leaf_flag
766: FROM pji_xbs_denorm
767: WHERE 1=1
768: AND sup_project_id = p_project_id
769: AND sup_id = p_element_version_id
770: AND struct_version_id IS NULL

Line 810: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver,pa_proj_elements emt

806: ,p_element_version_id
807: , -1
808: , sub_id
809: , denorm.relationship_type
810: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver,pa_proj_elements emt
811: , (SELECT sub_id wbs_version_id, sub_leaf_flag
812: FROM pji_xbs_denorm
813: WHERE 1=1
814: AND sup_project_id = p_project_id

Line 812: FROM pji_xbs_denorm

808: , sub_id
809: , denorm.relationship_type
810: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver,pa_proj_elements emt
811: , (SELECT sub_id wbs_version_id, sub_leaf_flag
812: FROM pji_xbs_denorm
813: WHERE 1=1
814: AND sup_project_id = p_project_id
815: AND sup_id = p_element_version_id
816: AND struct_version_id IS NULL

Line 840: FROM pji_xbs_denorm,

836: AND sup_project_id = p_project_id
837: AND prg_flag = 'Y'
838: AND child_element_id IN
839: (SELECT sub_rollup_id
840: FROM pji_xbs_denorm,
841: (SELECT sub_id wbs_version_id, sub_leaf_flag
842: FROM pji_xbs_denorm
843: WHERE 1=1
844: AND sup_project_id = p_project_id

Line 842: FROM pji_xbs_denorm

838: AND child_element_id IN
839: (SELECT sub_rollup_id
840: FROM pji_xbs_denorm,
841: (SELECT sub_id wbs_version_id, sub_leaf_flag
842: FROM pji_xbs_denorm
843: WHERE 1=1
844: AND sup_project_id = p_project_id
845: AND sup_id = p_element_version_id
846: AND struct_version_id IS NULL

Line 944: pji_xbs_denorm denorm

940: MAX(DECODE(header_p.plan_version_id,p_plan1_version_id,header.plan_version_id,NULL)),
941: MAX(DECODE(header_p.plan_version_id,p_plan2_version_id,header.plan_version_id,NULL)),
942: MAX(DECODE(header_p.plan_version_id,p_current_version_id,header.wbs_version_id,NULL))
943: FROM
944: pji_xbs_denorm denorm
945: , pa_proj_elements elem
946: , pji_pjp_wbs_header header
947: , pji_pjp_wbs_header header_p
948: WHERE 1=1

Line 3907: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

3903: for program in workplan context.
3904: */
3905: PROCEDURE CHECK_WP_PARAM_CONSISTENCY
3906: ( p_project_id IN pa_projects_all.project_id%TYPE
3907: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
3908: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
3909: ,p_published_flag IN VARCHAR2
3910: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
3911: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE

Line 4050: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

4046: the same project and project functional currency.
4047: */
4048: PROCEDURE CHECK_WP_CURRENCY_CONSISTENCY
4049: ( p_project_id IN pa_projects_all.project_id%TYPE
4050: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4051: ,x_pc_flag OUT NOCOPY VARCHAR2
4052: ,x_pfc_flag OUT NOCOPY VARCHAR2
4053: ,x_return_status OUT NOCOPY VARCHAR2
4054: ,x_msg_count OUT NOCOPY NUMBER

Line 4065: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,

4061: FROM pa_projects_all
4062: WHERE project_id = c_project_id;
4063:
4064: CURSOR check_project_currency(c_project_id pa_projects_all.project_id%TYPE,
4065: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4066: c_currency_code pa_projects_all.project_currency_code%TYPE)
4067: IS
4068: SELECT 1
4069: FROM pji_xbs_denorm denorm,

Line 4069: FROM pji_xbs_denorm denorm,

4065: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4066: c_currency_code pa_projects_all.project_currency_code%TYPE)
4067: IS
4068: SELECT 1
4069: FROM pji_xbs_denorm denorm,
4070: pa_proj_elements ele,
4071: pa_projects_all proj
4072: WHERE denorm.sup_project_id = c_project_id
4073: AND denorm.sup_id = c_wbs_version_id

Line 4081: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,

4077: AND ele.project_id = proj.project_id
4078: AND proj.project_currency_code <> c_currency_code;
4079:
4080: CURSOR check_projfunc_currency(c_project_id pa_projects_all.project_id%TYPE,
4081: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4082: c_currency_code pa_projects_all.project_currency_code%TYPE)
4083: IS
4084: SELECT 1
4085: FROM pji_xbs_denorm denorm,

Line 4085: FROM pji_xbs_denorm denorm,

4081: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4082: c_currency_code pa_projects_all.project_currency_code%TYPE)
4083: IS
4084: SELECT 1
4085: FROM pji_xbs_denorm denorm,
4086: pa_proj_elements ele,
4087: pa_projects_all proj
4088: WHERE denorm.sup_project_id = c_project_id
4089: AND denorm.sup_id = c_wbs_version_id

Line 4180: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

4176: program hierarchy have the same margin mask.
4177: */
4178: PROCEDURE CHECK_WP_MARGIN_CONSISTENCY
4179: ( p_project_id IN pa_projects_all.project_id%TYPE
4180: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4181: ,p_margin_code IN pa_proj_fp_options.margin_derived_from_code%TYPE
4182: ,x_margin_flag OUT NOCOPY VARCHAR2
4183: ,x_return_status OUT NOCOPY VARCHAR2
4184: ,x_msg_count OUT NOCOPY NUMBER

Line 4189: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,

4185: ,x_msg_data OUT NOCOPY VARCHAR2)
4186: AS
4187:
4188: CURSOR check_margin_mask(c_project_id pa_projects_all.project_id%TYPE,
4189: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4190: c_margin_code pa_proj_fp_options.margin_derived_from_code%TYPE)
4191: IS
4192: SELECT 1
4193: FROM pji_xbs_denorm denorm,

Line 4193: FROM pji_xbs_denorm denorm,

4189: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4190: c_margin_code pa_proj_fp_options.margin_derived_from_code%TYPE)
4191: IS
4192: SELECT 1
4193: FROM pji_xbs_denorm denorm,
4194: pji_pjp_wbs_header header,
4195: pa_proj_fp_options opt
4196: WHERE denorm.sup_project_id = c_project_id
4197: AND denorm.sup_id = c_wbs_version_id

Line 4277: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

4273: */
4274:
4275: PROCEDURE CHECK_WP_STATUS_CONSISTENCY
4276: ( p_project_id IN pa_projects_all.project_id%TYPE
4277: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4278: ,p_published_flag IN VARCHAR2
4279: ,x_workpub_flag OUT NOCOPY VARCHAR2
4280: ,x_return_status OUT NOCOPY VARCHAR2
4281: ,x_msg_count OUT NOCOPY NUMBER

Line 4286: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,

4282: ,x_msg_data OUT NOCOPY VARCHAR2)
4283: AS
4284:
4285: CURSOR check_published_flag(c_project_id pa_projects_all.project_id%TYPE,
4286: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4287: c_published_flag VARCHAR2)
4288: IS
4289: SELECT 1
4290: FROM pji_xbs_denorm denorm,

Line 4290: FROM pji_xbs_denorm denorm,

4286: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4287: c_published_flag VARCHAR2)
4288: IS
4289: SELECT 1
4290: FROM pji_xbs_denorm denorm,
4291: pa_proj_elements ele
4292: WHERE denorm.sup_project_id = c_project_id
4293: AND denorm.sup_id = c_wbs_version_id
4294: AND denorm.struct_type = 'PRG'

Line 4370: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

4366: same time phasing.
4367: */
4368: PROCEDURE CHECK_WP_TIME_CONSISTENCY
4369: ( p_project_id IN pa_projects_all.project_id%TYPE
4370: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4371: ,p_calendar_type IN pji_fp_xbs_accum_f.calendar_type%TYPE
4372: ,p_calendar_id IN pa_projects_all.calendar_id%TYPE
4373: ,x_time_phase_flag OUT NOCOPY VARCHAR2
4374: ,x_return_status OUT NOCOPY VARCHAR2

Line 4381: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE)

4377: AS
4378:
4379:
4380: CURSOR get_pgm_ver_details(c_project_id pa_projects_all.project_id%TYPE,
4381: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE)
4382: IS
4383: SELECT header.project_id, header.plan_version_id
4384: FROM pji_xbs_denorm denorm,
4385: pji_pjp_wbs_header header

Line 4384: FROM pji_xbs_denorm denorm,

4380: CURSOR get_pgm_ver_details(c_project_id pa_projects_all.project_id%TYPE,
4381: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE)
4382: IS
4383: SELECT header.project_id, header.plan_version_id
4384: FROM pji_xbs_denorm denorm,
4385: pji_pjp_wbs_header header
4386: WHERE denorm.sup_project_id = c_project_id
4387: AND denorm.sup_id = c_wbs_version_id
4388: AND denorm.struct_type = 'PRG'

Line 4477: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

4473: the same RBS.
4474: */
4475: PROCEDURE CHECK_WP_RBS_CONSISTENCY
4476: ( p_project_id IN pa_projects_all.project_id%TYPE
4477: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
4478: ,p_rbs_version_id IN pa_proj_fp_options.rbs_version_id%TYPE
4479: ,x_rbs_flag OUT NOCOPY VARCHAR2
4480: ,x_return_status OUT NOCOPY VARCHAR2
4481: ,x_msg_count OUT NOCOPY NUMBER

Line 4486: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,

4482: ,x_msg_data OUT NOCOPY VARCHAR2)
4483: AS
4484:
4485: CURSOR check_rbs_flag(c_project_id pa_projects_all.project_id%TYPE,
4486: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4487: c_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE)
4488: IS
4489: SELECT 1
4490: FROM pji_xbs_denorm denorm,

Line 4490: FROM pji_xbs_denorm denorm,

4486: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE,
4487: c_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE)
4488: IS
4489: SELECT 1
4490: FROM pji_xbs_denorm denorm,
4491: pji_pjp_wbs_header header,
4492: pa_proj_fp_options opt
4493: WHERE denorm.sup_project_id = c_project_id
4494: AND denorm.sup_id = c_wbs_version_id

Line 5152: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

5148: * will return 'T' else 'F'. This logic is true for PA calendar also.
5149: */
5150: PROCEDURE Check_Perf_Cal_Consistency(
5151: p_project_id IN pa_projects_all.project_id%TYPE
5152: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
5153: ,x_gl_flag OUT NOCOPY VARCHAR2
5154: ,x_pa_flag OUT NOCOPY VARCHAR2
5155: ,x_return_status OUT NOCOPY VARCHAR2
5156: ,x_msg_count OUT NOCOPY NUMBER

Line 5191: pji_xbs_denorm denorm

5187: COUNT(DISTINCT info.pa_calendar_id)
5188: INTO l_num_of_gl_cal,
5189: l_num_of_pa_cal
5190: FROM
5191: pji_xbs_denorm denorm
5192: , pa_proj_elements elem
5193: , pa_projects_all proj
5194: , pji_org_extr_info info
5195: WHERE 1=1

Line 5248: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE

5244: * will return 'T' else 'F'.
5245: */
5246: PROCEDURE Check_Perf_Curr_Consistency(
5247: p_project_id IN pa_projects_all.project_id%TYPE
5248: ,p_wbs_version_id IN pji_xbs_denorm.sup_project_id%TYPE
5249: ,x_pfc_flag OUT NOCOPY VARCHAR2
5250: ,x_return_status OUT NOCOPY VARCHAR2
5251: ,x_msg_count OUT NOCOPY NUMBER
5252: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 5282: pji_xbs_denorm denorm

5278: --Obtain the PFC count
5279: SELECT COUNT(DISTINCT proj.projfunc_currency_code)
5280: INTO l_num_of_projfunc_curr
5281: FROM
5282: pji_xbs_denorm denorm
5283: , pa_proj_elements elem
5284: , pa_projects_all proj
5285: WHERE 1=1
5286: AND denorm.sup_project_id = p_project_id -- project_id

Line 5593: FROM pji_xbs_Denorm pji

5589:
5590: BEGIN
5591: SELECT DISTINCT head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id BULK COLLECT
5592: INTO l_plan_version_id_tbl, l_project_id_tbl,l_wbs_version_id_tbl
5593: FROM pji_xbs_Denorm pji
5594: ,pji_pjp_wbs_header head
5595: WHERE pji.struct_type='PRG'
5596: --AND pji.sup_level<>pji.sub_level --Bug 4624479
5597: AND pji.sup_id IN(l_get_wbs_version_id_tbl(1),l_get_wbs_version_id_tbl(2),l_get_wbs_version_id_tbl(3)

Line 5810: , pji_xbs_denorm denorm

5806: CURSOR struct_list(c_structure_version_id pa_proj_element_versions.element_version_id%TYPE
5807: , c_structure_type VARCHAR2) IS
5808: SELECT vs.element_version_id, vs.project_id
5809: FROM pa_proj_elem_ver_structure vs
5810: , pji_xbs_denorm denorm
5811: WHERE denorm.struct_version_id IS NULL
5812: AND denorm.struct_type = 'PRG'
5813: AND NVL(denorm.relationship_type,'WF') IN ('WF',c_structure_type)
5814: AND denorm.sup_id = c_structure_version_id

Line 5913: FROM pji_xbs_denorm denorm

5909: END IF;
5910:
5911: SELECT COUNT(DISTINCT UPPER(pt.project_type_class_code))
5912: INTO l_proj_type_count
5913: FROM pji_xbs_denorm denorm
5914: ,pa_proj_elem_ver_structure vs
5915: ,pa_projects_all proj
5916: ,pa_project_types_all pt
5917: WHERE struct_type = 'PRG'

Line 6166: pji_xbs_denorm denorm

6162:
6163: Select count(*)
6164: INTO l_count
6165: FROM
6166: pji_xbs_denorm denorm
6167: , pa_proj_elements elem
6168: , pa_proj_elem_ver_structure ppevs
6169: WHERE 1=1
6170: AND denorm.sup_project_id = p_project_id