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.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_STRUCTURE_TYPES

Line 287: from pa_proj_structure_types p, pa_proj_elements e, pa_structure_types t

283: l_dummy VARCHAR2(1);
284:
285: cursor c1 is
286: select '1'
287: from pa_proj_structure_types p, pa_proj_elements e, pa_structure_types t
288: where e.project_id = p_project_id
289: and e.proj_element_id = p.proj_element_id
290: and p.structure_type_id = t.structure_type_id
291: and t.structure_type_class_code = p_structure_type

Line 352: pa_structure_types t

348:
349: cursor c1 is
350: select '1'
351: from pa_proj_structure_types p,
352: pa_structure_types t
353: where p.proj_element_id = p_structure_id
354: and p.structure_type_id = t.structure_type_id
355: and t.structure_type_class_code = p_structure_type
356: and t.structure_type_class_code IN ('WORKPLAN', 'FINANCIAL');

Line 409: pa_structure_types t, pa_proj_element_versions v

405:
406: cursor c1 is
407: select '1'
408: from pa_proj_structure_types p, pa_proj_elements e,
409: pa_structure_types t, pa_proj_element_versions v
410: where v.element_version_id = p_structure_version_id
411: and v.proj_element_id = e.proj_element_id
412: and e.proj_element_id = p.proj_element_id
413: and p.structure_type_id = t.structure_type_id

Line 1095: ,pa_structure_types pst

1091: CURSOR c1 IS
1092: select wp_approval_reqd_flag, wp_auto_publish_flag
1093: from pa_proj_workplan_attr ppw
1094: ,pa_proj_structure_types ppst
1095: ,pa_structure_types pst
1096: where ppw.project_id = p_project_id
1097: and ppw.proj_element_id = ppst.proj_element_id
1098: and ppst.structure_type_id = pst.structure_type_id
1099: and pst.structure_type = 'WORKPLAN' ;

Line 1421: pa_structure_types d

1417: select c.element_version_id
1418: from pa_proj_element_versions c,
1419: pa_proj_elements b,
1420: pa_proj_structure_types a,
1421: pa_structure_types d
1422: where d.structure_type_class_code = 'WORKPLAN'
1423: and d.structure_type_id = a.structure_type_id
1424: and a.proj_element_id = b.proj_element_id
1425: and b.project_id = p_project_id

Line 1433: pa_structure_types d

1429: */
1430: select c.element_version_id /*New Query with improved Performance : 3968091 */
1431: from pa_proj_element_versions c,
1432: pa_proj_structure_types a,
1433: pa_structure_types d
1434: where d.structure_type_class_code = 'WORKPLAN'
1435: and d.structure_type_id = a.structure_type_id
1436: and a.proj_element_id = c.proj_element_id
1437: and c.project_id = p_project_id

Line 1487: pa_structure_types d

1483: select c.element_version_id
1484: from pa_proj_element_versions c,
1485: pa_proj_elements b,
1486: pa_proj_structure_types a,
1487: pa_structure_types d
1488: where d.structure_type_class_code = 'FINANCIAL'
1489: and d.structure_type_id = a.structure_type_id
1490: and a.proj_element_id = b.proj_element_id
1491: and b.project_id = p_project_id

Line 1499: pa_structure_types d

1495: */
1496: select c.element_version_id /*New Query with improved Performance : 3968091 */
1497: from pa_proj_element_versions c,
1498: pa_proj_structure_types a,
1499: pa_structure_types d
1500: where d.structure_type_class_code = 'FINANCIAL'
1501: and d.structure_type_id = a.structure_type_id
1502: and a.proj_element_id = c.proj_element_id
1503: and c.project_id = p_project_id

Line 1779: pa_structure_types c

1775: CURSOR c1 IS
1776: SELECT 'Y'
1777: FROM pa_proj_elements a,
1778: pa_proj_structure_types b,
1779: pa_structure_types c
1780: WHERE c.structure_type_class_code = 'WORKPLAN'
1781: AND c.structure_type_id = b.structure_type_id
1782: AND b.proj_element_id = a.proj_element_id
1783: AND a.project_id = p_project_id;

Line 1818: pa_structure_types c

1814: CURSOR c1 IS
1815: SELECT 'Y'
1816: FROM pa_proj_elements a,
1817: pa_proj_structure_types b,
1818: pa_structure_types c
1819: WHERE c.structure_type_class_code = 'FINANCIAL'
1820: AND c.structure_type_id = b.structure_type_id
1821: AND b.proj_element_id = a.proj_element_id
1822: AND a.project_id = p_project_id;

Line 1858: pa_structure_types c,

1854: CURSOR c1 IS
1855: SELECT 'Y'
1856: FROM pa_proj_elements a,
1857: pa_proj_structure_types b,
1858: pa_structure_types c,
1859: pa_proj_structure_types d,
1860: pa_structure_types e
1861: WHERE c.structure_type_class_code = 'WORKPLAN'
1862: AND e.structure_type_class_code = 'FINANCIAL'

Line 1860: pa_structure_types e

1856: FROM pa_proj_elements a,
1857: pa_proj_structure_types b,
1858: pa_structure_types c,
1859: pa_proj_structure_types d,
1860: pa_structure_types e
1861: WHERE c.structure_type_class_code = 'WORKPLAN'
1862: AND e.structure_type_class_code = 'FINANCIAL'
1863: AND c.structure_type_id = b.structure_type_id
1864: AND e.structure_type_id = d.structure_type_id

Line 1998: pa_structure_types pst

1994: CURSOR get_wp_id IS
1995: SELECT ppe.proj_element_id
1996: from pa_proj_elements ppe,
1997: pa_proj_structure_types ppst,
1998: pa_structure_types pst
1999: where ppe.project_id = p_project_id
2000: and ppe.proj_element_id = ppst.proj_element_id
2001: and ppst.structure_type_id = pst.structure_type_id
2002: and pst.structure_type_class_code = 'WORKPLAN';

Line 2076: pa_structure_types pst

2072: CURSOR get_wp_id IS
2073: SELECT ppe.proj_element_id
2074: from pa_proj_elements ppe,
2075: pa_proj_structure_types ppst,
2076: pa_structure_types pst
2077: where ppe.project_id = p_project_id
2078: and ppe.proj_element_id = ppst.proj_element_id
2079: and ppst.structure_type_id = pst.structure_type_id
2080: and pst.structure_type_class_code = 'WORKPLAN';

Line 2595: pa_structure_types pst

2591: CURSOR c1 IS
2592: select ppe.proj_element_id
2593: from pa_proj_elements ppe,
2594: pa_proj_structure_types ppst,
2595: pa_structure_types pst
2596: where ppe.project_id = p_project_id
2597: and ppe.proj_element_id = ppst.proj_element_id
2598: and ppst.structure_type_id = pst.structure_type_id
2599: and pst.structure_type_class_code = 'FINANCIAL';

Line 2631: pa_structure_types pst,

2627: CURSOR c1 IS
2628: select ppevs.element_version_id
2629: from pa_proj_elements ppe,
2630: pa_proj_structure_types ppst,
2631: pa_structure_types pst,
2632: pa_proj_elem_ver_structure ppevs
2633: where ppe.project_id = p_project_id
2634: and ppe.proj_element_id = ppst.proj_element_id
2635: and ppe.project_id = ppevs.project_id

Line 2651: pa_structure_types pst,

2647: CURSOR c2 IS
2648: select ppevs.element_version_id
2649: from pa_proj_elements ppe,
2650: pa_proj_structure_types ppst,
2651: pa_structure_types pst,
2652: pa_proj_elem_ver_structure ppevs
2653: where ppe.project_id = p_project_id
2654: and ppe.proj_element_id = ppst.proj_element_id
2655: and ppe.project_id = ppevs.project_id

Line 2734: pa_structure_types pst,

2730: CURSOR c1 IS
2731: select ppevs.element_version_id
2732: from pa_proj_elements ppe,
2733: pa_proj_structure_types ppst,
2734: pa_structure_types pst,
2735: pa_proj_elem_ver_structure ppevs
2736: where ppe.project_id = p_project_id
2737: and ppe.proj_element_id = ppst.proj_element_id
2738: and ppe.project_id = ppevs.project_id

Line 3397: ,p_structure_type IN pa_structure_types.structure_type%TYPE

3393: -- If none of the structure versions are in the above mentioned statuses, the function will return NULL.
3394:
3395: FUNCTION GET_PROCESS_STATUS_CODE(
3396: p_project_id IN pa_projects_all.project_id%TYPE
3397: ,p_structure_type IN pa_structure_types.structure_type%TYPE
3398: )
3399: return VARCHAR2 IS
3400: -- This cursor fetches the process code of WUP or WUE if the process is in
3401: -- progress for any of the structure versions or if the process has errored out.

Line 3403: c_structure_type pa_structure_types.structure_type%TYPE)

3399: return VARCHAR2 IS
3400: -- This cursor fetches the process code of WUP or WUE if the process is in
3401: -- progress for any of the structure versions or if the process has errored out.
3402: Cursor cur_proc_ver(c_project_id pa_projects_all.project_id%TYPE,
3403: c_structure_type pa_structure_types.structure_type%TYPE)
3404: is
3405: select vs.process_code
3406: from pa_proj_elem_ver_structure vs,
3407: pa_proj_structure_types pst,

Line 3408: pa_structure_types st

3404: is
3405: select vs.process_code
3406: from pa_proj_elem_ver_structure vs,
3407: pa_proj_structure_types pst,
3408: pa_structure_types st
3409: where
3410: vs.project_id = c_project_id
3411: and vs.process_code in ('WUP','WUE')
3412: and pst.PROJ_ELEMENT_ID = vs.proj_element_id

Line 3519: ,p_structure_type IN pa_structure_types.structure_type%TYPE

3515: -- concurrent programs running one for the FINANCIAL structure and the other for
3516: -- the WORKPLAN structure.
3517: PROCEDURE GET_CONC_REQUEST_DETAILS(
3518: p_project_id IN pa_projects_all.project_id%TYPE
3519: ,p_structure_type IN pa_structure_types.structure_type%TYPE
3520: ,x_request_id OUT NOCOPY pa_proj_elem_ver_structure.conc_request_id%TYPE -- 4537865
3521: ,x_process_code OUT NOCOPY pa_proj_elem_ver_structure.process_code%TYPE -- 4537865
3522: ,x_structure_version_id OUT NOCOPY pa_proj_elem_ver_structure.element_version_id%TYPE -- 4537865
3523: ,x_return_status OUT NOCOPY VARCHAR2 -- 4537865

Line 3534: c_structure_type pa_structure_types.structure_type%TYPE)

3530: -- This cursor returns the concurrent request id, process code and the
3531: -- structure version for which the concurrent request was launched - This
3532: -- currently could be in process or could have completed with errors.
3533: cursor cur_request_details(c_project_id pa_projects_all.project_id%TYPE,
3534: c_structure_type pa_structure_types.structure_type%TYPE)
3535: IS
3536: select vs.conc_request_id, vs.process_code, vs.element_version_id
3537: from pa_proj_elem_ver_structure vs,
3538: pa_proj_structure_types pst,

Line 3539: pa_structure_types st

3535: IS
3536: select vs.conc_request_id, vs.process_code, vs.element_version_id
3537: from pa_proj_elem_ver_structure vs,
3538: pa_proj_structure_types pst,
3539: pa_structure_types st
3540: where vs.project_id = c_project_id
3541: and vs.process_code in ('WUP','WUE')
3542: and pst.PROJ_ELEMENT_ID = vs.proj_element_id
3543: and pst.structure_type_id = st.structure_type_id

Line 3684: ,p_structure_type IN pa_structure_types.structure_type%TYPE

3680: -- is split, there could be two concurrent programs running one for the FINANCIAL
3681: -- structure and the other for the WORKPLAN structure.
3682: FUNCTION GET_CONC_REQUEST_ID(
3683: p_project_id IN pa_projects_all.project_id%TYPE
3684: ,p_structure_type IN pa_structure_types.structure_type%TYPE
3685: )
3686: return NUMBER IS
3687: -- This cursor returns the concurrent request id, process code and the
3688: -- structure version for which the concurrent request was launched - This

Line 3691: c_structure_type pa_structure_types.structure_type%TYPE)

3687: -- This cursor returns the concurrent request id, process code and the
3688: -- structure version for which the concurrent request was launched - This
3689: -- currently could be in process or could have completed with errors.
3690: cursor cur_request_details(c_project_id pa_projects_all.project_id%TYPE,
3691: c_structure_type pa_structure_types.structure_type%TYPE)
3692: IS
3693: select vs.conc_request_id
3694: from pa_proj_elem_ver_structure vs,
3695: pa_proj_structure_types pst,

Line 3696: pa_structure_types st

3692: IS
3693: select vs.conc_request_id
3694: from pa_proj_elem_ver_structure vs,
3695: pa_proj_structure_types pst,
3696: pa_structure_types st
3697: where vs.project_id = c_project_id
3698: and vs.process_code in ('WUP','WUE')
3699: and pst.PROJ_ELEMENT_ID = vs.proj_element_id
3700: and pst.structure_type_id = st.structure_type_id

Line 3760: pa_structure_types c

3756: CURSOR c1 IS
3757: SELECT 'Y'
3758: FROM pa_proj_elem_ver_structure a, -- Bug 16325665
3759: pa_proj_structure_types b,
3760: pa_structure_types c
3761: WHERE c.structure_type_class_code = 'DELIVERABLE'
3762: AND c.structure_type_id = b.structure_type_id
3763: AND b.proj_element_id = a.proj_element_id
3764: AND a.project_id = p_project_id;

Line 3787: pa_structure_types pst,

3783: IS
3784: SELECT ppevs.element_version_id
3785: FROM pa_proj_elements ppe,
3786: pa_proj_structure_types ppst,
3787: pa_structure_types pst,
3788: pa_proj_elem_ver_structure ppevs
3789: WHERE ppe.project_id = p_project_id
3790: AND ppe.proj_element_id = ppst.proj_element_id
3791: AND ppe.project_id = ppevs.project_id

Line 3922: pa_structure_types pst

3918: cursor get_third_party_flag IS
3919: Select ppwa.SCHEDULE_THIRD_PARTY_FLAG
3920: from pa_proj_workplan_attr ppwa,
3921: pa_proj_structure_types ppst,
3922: pa_structure_types pst
3923: where p_project_id = ppwa.project_id
3924: and ppwa.proj_element_id = ppst.proj_element_id
3925: and ppst.structure_type_id = pst.structure_type_id
3926: and pst.structure_type = 'WORKPLAN';

Line 3947: pa_structure_types pst

3943: cursor get_lowest_tsk_dep_flag IS
3944: Select ppwa.ALLOW_LOWEST_TSK_DEP_FLAG
3945: from pa_proj_workplan_attr ppwa,
3946: pa_proj_structure_types ppst,
3947: pa_structure_types pst
3948: where p_project_id = ppwa.project_id
3949: and ppwa.proj_element_id = ppst.proj_element_id
3950: and ppst.structure_type_id = pst.structure_type_id
3951: and pst.structure_type = 'WORKPLAN';

Line 4036: pa_structure_types pst

4032: FROM pa_proj_elements ppe,
4033: pa_proj_element_versions ppev,
4034: pa_proj_elem_ver_structure ppevs,
4035: pa_proj_structure_types ppst,
4036: pa_structure_types pst
4037: WHERE ppe.proj_element_id = ppev.proj_element_id
4038: AND ppe.project_id = ppev.project_id
4039: AND ppe.project_id = cp_proj_id
4040: AND ppe.object_type = 'PA_STRUCTURES'

Line 4053: pa_structure_types pst

4049: FROM pa_proj_elements ppe,
4050: pa_proj_element_versions ppev,
4051: pa_proj_elem_ver_structure ppevs,
4052: pa_proj_structure_types ppst,
4053: pa_structure_types pst
4054: WHERE ppe.proj_element_id = ppev.proj_element_id
4055: AND ppe.project_id = ppev.project_id
4056: AND ppe.project_id = cp_proj_id
4057: AND ppe.object_type = 'PA_STRUCTURES'

Line 4291: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL

4287: -- Begin fix for Bug # 4373055.
4288:
4289: PROCEDURE GET_PROCESS_STATUS_MSG(
4290: p_project_id IN pa_projects_all.project_id%TYPE
4291: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL
4292: , p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE := NULL
4293: , p_context IN VARCHAR2 := NULL
4294: , x_message_name OUT NOCOPY VARCHAR2 -- 4537865
4295: , x_message_type OUT NOCOPY VARCHAR2 -- 4537865

Line 4308: , c_structure_type pa_structure_types.structure_type%TYPE) is

4304: structure type.
4305: */
4306:
4307: cursor cur_proc_ver(c_project_id pa_projects_all.project_id%TYPE
4308: , c_structure_type pa_structure_types.structure_type%TYPE) is
4309: select vs.process_code, vs.element_version_id, vs.conc_request_id
4310: from pa_proj_elem_ver_structure vs
4311: , pa_proj_structure_types pst
4312: , pa_structure_types st

Line 4312: , pa_structure_types st

4308: , c_structure_type pa_structure_types.structure_type%TYPE) is
4309: select vs.process_code, vs.element_version_id, vs.conc_request_id
4310: from pa_proj_elem_ver_structure vs
4311: , pa_proj_structure_types pst
4312: , pa_structure_types st
4313: where vs.project_id = c_project_id
4314: and pst.PROJ_ELEMENT_ID = vs.proj_element_id
4315: and pst.structure_type_id = st.structure_type_id
4316: and st.structure_type = c_structure_type

Line 4634: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst, pa_structure_types pst

4630: l_str_sharing_code VARCHAR2(30) := null;
4631:
4632: cursor cur_proc_upd_flag(c_project_id NUMBER, c_structure_version_id VARCHAR2) is
4633: select ppevs.process_update_wbs_flag, ppevs.process_code
4634: from pa_proj_elem_ver_structure ppevs, pa_proj_structure_types ppst, pa_structure_types pst
4635: where ppevs.proj_element_id = ppst.proj_element_id
4636: and ppst.structure_type_id = pst.structure_type_id
4637: and ppevs.project_id = c_project_id
4638: and ppevs.element_version_id = c_structure_version_id;

Line 5278: pa_structure_types c

5274: IS
5275: SELECT a.proj_element_id
5276: FROM pa_proj_elements a,
5277: pa_proj_structure_types b,
5278: pa_structure_types c
5279: WHERE a.proj_element_id = b.proj_element_id
5280: AND a.object_type = 'PA_STRUCTURES'
5281: AND a.project_id = p_project_id
5282: AND b.structure_type_id = c.structure_type_id