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_PJP_WBS_HEADER

Line 631: , pji_pjp_wbs_header header

627: MAX(DECODE(header_p.plan_version_id,p_current_version_id,header.wbs_version_id,NULL))
628: FROM
629: pji_xbs_denorm denorm
630: , pa_proj_elements elem
631: , pji_pjp_wbs_header header
632: , pji_pjp_wbs_header header_p
633: WHERE 1=1
634: AND header_p.project_id = p_project_id
635: AND header_p.plan_version_id IN

Line 632: , pji_pjp_wbs_header header_p

628: FROM
629: pji_xbs_denorm denorm
630: , pa_proj_elements elem
631: , pji_pjp_wbs_header header
632: , pji_pjp_wbs_header header_p
633: WHERE 1=1
634: AND header_p.project_id = p_project_id
635: AND header_p.plan_version_id IN
636: (

Line 1712: pji_pjp_wbs_header hdr

1708: BEGIN
1709: SELECT hdr.wbs_version_id
1710: INTO x_wbs_version_id
1711: FROM
1712: pji_pjp_wbs_header hdr
1713: WHERE
1714: hdr.project_id = p_project_id
1715: AND hdr.plan_version_id = p_plan_version_id;
1716: EXCEPTION

Line 1736: pji_pjp_wbs_header hdr

1732:
1733: /* SELECT hdr.wbs_version_id,elm.proj_element_id
1734: INTO x_wbs_version_id, x_wbs_element_id
1735: FROM
1736: pji_pjp_wbs_header hdr
1737: , pa_proj_element_versions elm
1738: WHERE
1739: hdr.wbs_version_id = elm.element_version_id
1740: AND hdr.project_id = p_project_id

Line 3018: pji_pjp_wbs_header hdr

3014: IS
3015: CURSOR c_dates IS
3016: SELECT TO_CHAR(sch.scheduled_start_date,'j'),TO_CHAR(sch.scheduled_finish_date,'j')
3017: FROM
3018: pji_pjp_wbs_header hdr
3019: , pa_proj_elem_ver_schedule sch
3020: WHERE
3021: hdr.project_id = p_project_id
3022: AND hdr.plan_version_id IN ( p_published_version_id,p_working_version_id)

Line 3245: FROM pji_pjp_wbs_header

3241: IF ( l_plan_version_ids.COUNT > 0 ) THEN
3242: BEGIN
3243: SELECT MAX(max_txn_date), MIN(min_txn_date)
3244: INTO l_max_date, l_min_date
3245: FROM pji_pjp_wbs_header
3246: WHERE project_id = p_project_id
3247: AND plan_version_id IN (l_plan_version_ids(1),l_plan_version_ids(2),l_plan_version_ids(3),l_plan_version_ids(4),
3248: l_plan_version_ids(5),l_plan_version_ids(6),l_plan_version_ids(7),l_plan_version_ids(8),
3249: l_plan_version_ids(9),l_plan_version_ids(10),l_plan_version_ids(11),l_plan_version_ids(12),

Line 3750: pji_pjp_wbs_header header,

3746: c_margin_code pa_proj_fp_options.margin_derived_from_code%TYPE)
3747: IS
3748: SELECT 1
3749: FROM pji_xbs_denorm denorm,
3750: pji_pjp_wbs_header header,
3751: pa_proj_fp_options opt
3752: WHERE denorm.sup_project_id = c_project_id
3753: AND denorm.sup_id = c_wbs_version_id
3754: AND denorm.struct_type = 'PRG'

Line 3941: pji_pjp_wbs_header header

3937: c_wbs_version_id pji_xbs_denorm.sup_project_id%TYPE)
3938: IS
3939: SELECT header.project_id, header.plan_version_id
3940: FROM pji_xbs_denorm denorm,
3941: pji_pjp_wbs_header header
3942: WHERE denorm.sup_project_id = c_project_id
3943: AND denorm.sup_id = c_wbs_version_id
3944: AND denorm.struct_type = 'PRG'
3945: AND denorm.struct_version_id IS NULL

Line 4047: pji_pjp_wbs_header header,

4043: c_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE)
4044: IS
4045: SELECT 1
4046: FROM pji_xbs_denorm denorm,
4047: pji_pjp_wbs_header header,
4048: pa_proj_fp_options opt
4049: WHERE denorm.sup_project_id = c_project_id
4050: AND denorm.sup_id = c_wbs_version_id
4051: AND denorm.struct_type = 'PRG'

Line 4131: pji_pjp_wbs_header header

4127: CURSOR get_baselined_version(c_project_id pa_projects_all.project_id%TYPE)
4128: IS
4129: SELECT header.plan_version_id
4130: FROM pa_proj_elem_ver_structure str,
4131: pji_pjp_wbs_header header
4132: WHERE str.project_id = c_project_id
4133: AND str.current_flag = 'Y'
4134: AND header.project_id = str.project_id
4135: AND header.wbs_version_id = str.element_version_id

Line 4138: l_baseline_version_id pji_pjp_wbs_header.plan_version_id%TYPE;

4134: AND header.project_id = str.project_id
4135: AND header.wbs_version_id = str.element_version_id
4136: AND header.wp_flag = 'Y';
4137:
4138: l_baseline_version_id pji_pjp_wbs_header.plan_version_id%TYPE;
4139:
4140: BEGIN
4141: OPEN get_baselined_version(p_project_id);
4142: FETCH get_baselined_version INTO l_baseline_version_id;

Line 4158: pji_pjp_wbs_header header

4154: CURSOR get_latest_published_version(c_project_id pa_projects_all.project_id%TYPE)
4155: IS
4156: SELECT header.plan_version_id
4157: FROM pa_proj_elem_ver_structure str,
4158: pji_pjp_wbs_header header
4159: WHERE str.project_id = c_project_id
4160: AND str.latest_eff_published_flag = 'Y'
4161: AND header.project_id = str.project_id
4162: AND header.wbs_version_id = str.element_version_id

Line 4165: l_latest_published_version_id pji_pjp_wbs_header.plan_version_id%TYPE;

4161: AND header.project_id = str.project_id
4162: AND header.wbs_version_id = str.element_version_id
4163: AND header.wp_flag = 'Y';
4164:
4165: l_latest_published_version_id pji_pjp_wbs_header.plan_version_id%TYPE;
4166:
4167: BEGIN
4168: OPEN get_latest_published_version(p_project_id);
4169: FETCH get_latest_published_version INTO l_latest_published_version_id;

Line 5034: FROM pji_pjp_wbs_header head

5030:
5031: BEGIN
5032: SELECT DISTINCT head.wbs_version_id BULK COLLECT
5033: INTO l_get_wbs_version_id_tbl
5034: FROM pji_pjp_wbs_header head
5035: WHERE head.plan_version_id IN ( l_plan_version_id_tbl(1),l_plan_version_id_tbl(2),l_plan_version_id_tbl(3),
5036: l_plan_version_id_tbl(4), l_plan_version_id_tbl(5),l_plan_version_id_tbl(6),
5037: l_plan_version_id_tbl(7),l_plan_version_id_tbl(8), l_plan_version_id_tbl(9),
5038: l_plan_version_id_tbl(10),l_plan_version_id_tbl(11),l_plan_version_id_tbl(12),

Line 5057: FROM pji_pjp_wbs_header head

5053:
5054: BEGIN
5055: SELECT DISTINCT NVL(head.plan_type_id,-1) BULK COLLECT
5056: INTO l_plan_type_id_tbl
5057: FROM pji_pjp_wbs_header head
5058: WHERE head.plan_version_id IN ( l_plan_version_id_tbl(1),l_plan_version_id_tbl(2),l_plan_version_id_tbl(3),
5059: l_plan_version_id_tbl(4), l_plan_version_id_tbl(5),l_plan_version_id_tbl(6),
5060: l_plan_version_id_tbl(7),l_plan_version_id_tbl(8), l_plan_version_id_tbl(9),
5061: l_plan_version_id_tbl(10),l_plan_version_id_tbl(11),l_plan_version_id_tbl(12),

Line 5110: ,pji_pjp_wbs_header head

5106: BEGIN
5107: SELECT DISTINCT head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id BULK COLLECT
5108: INTO l_plan_version_id_tbl, l_project_id_tbl,l_wbs_version_id_tbl
5109: FROM pji_xbs_Denorm pji
5110: ,pji_pjp_wbs_header head
5111: WHERE pji.struct_type='PRG'
5112: --AND pji.sup_level<>pji.sub_level --Bug 4624479
5113: 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)
5114: ,l_get_wbs_version_id_tbl(4),l_get_wbs_version_id_tbl(5),l_get_wbs_version_id_tbl(6)