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_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 5689: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

5685: --bug 2738747
5686: l_task_version_id NUMBER;
5687:
5688: -- Bug 3091798.
5689: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
5690:
5691: --bug 3098668
5692: struct_ver_updatable VARCHAR2(1);
5693: l_str_ver_type VARCHAR2(1);

Line 7451: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

7447:
7448: -- Bug 3010538
7449: l_process_code pa_lookups.lookup_code%TYPE;
7450:
7451: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
7452:
7453: -- Bug 3106457. Obtain the structure version id give the task version id.
7454: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%TYPE)
7455: is

Line 9848: ,pa_proj_elem_ver_structure d

9844: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
9845: IS
9846: SELECT c.element_version_id
9847: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
9848: ,pa_proj_elem_ver_structure d
9849: WHERE c.project_id = c_project_id
9850: AND a.structure_type_id = b.structure_type_id
9851: AND b.proj_element_id = c.proj_element_id
9852: AND a.structure_type = c_structure_type

Line 9863: ,pa_proj_elem_ver_structure d

9859: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
9860: IS
9861: SELECT c.element_version_id
9862: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
9863: ,pa_proj_elem_ver_structure d
9864: WHERE c.project_id = c_project_id
9865: AND a.structure_type_id = b.structure_type_id
9866: AND b.proj_element_id = c.proj_element_id
9867: AND a.structure_type = c_structure_type

Line 22430: , pa_proj_elem_ver_structure d

22426: SELECT c.element_version_id
22427: FROM pa_proj_element_versions c
22428: , pa_structure_types a
22429: , pa_proj_structure_types b
22430: , pa_proj_elem_ver_structure d
22431: WHERE c.project_id = l_project_id
22432: AND a.structure_type_id = b.structure_type_id
22433: AND b.proj_element_id = c.proj_element_id
22434: AND a.structure_type = l_structure_type

Line 22446: , pa_proj_elem_ver_structure d

22442: SELECT c.element_version_id
22443: FROM pa_proj_element_versions c
22444: , pa_structure_types a
22445: , pa_proj_structure_types b
22446: , pa_proj_elem_ver_structure d
22447: WHERE c.project_id = l_project_id
22448: AND a.structure_type_id = b.structure_type_id
22449: AND b.proj_element_id = c.proj_element_id
22450: AND a.structure_type = l_structure_type

Line 28284: FROM PA_PROJ_ELEM_VER_STRUCTURE

28280:
28281: CURSOR l_temp_cursor
28282: IS
28283: SELECT record_version_number, pev_structure_id, name
28284: FROM PA_PROJ_ELEM_VER_STRUCTURE
28285: WHERE project_id = p_pa_project_id and element_version_id = p_structure_version_id;
28286:
28287:
28288: BEGIN

Line 34525: from pa_proj_elem_ver_structure

34521:
34522: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
34523: IS
34524: select STATUS_CODE
34525: from pa_proj_elem_ver_structure
34526: where project_id = c_project_id
34527: and element_version_id = c_structure_version_id;
34528: BEGIN
34529: savepoint create_dep_pub_amg;

Line 34776: from pa_proj_elem_ver_structure

34772:
34773: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
34774: IS
34775: select STATUS_CODE
34776: from pa_proj_elem_ver_structure
34777: where project_id = c_project_id
34778: and element_version_id = c_structure_version_id;
34779:
34780: CURSOR get_rvn(c_id_from NUMBER, c_id_to NUMBER) IS

Line 35037: from pa_proj_elem_ver_structure

35033:
35034: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
35035: IS
35036: select STATUS_CODE
35037: from pa_proj_elem_ver_structure
35038: where project_id = c_project_id
35039: and element_version_id = c_structure_version_id;
35040:
35041: CURSOR get_rvn(c_id_from NUMBER, c_id_to NUMBER) IS

Line 35290: -- from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs

35286: -- The Following cursor has been commented for Performance Bug 4878722 SQL ID 14909071
35287: -- The purpose of this cursor per usage in this API is to verify whether the task exists in any of the previously published versions
35288: -- cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35289: -- select ppe.element_number
35290: -- from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs
35291: -- where ppe.proj_element_id = p_pa_task_id
35292: -- and ppe.parent_structure_id = ppevs.proj_element_id
35293: -- and ppevs.status_code = 'STRUCTURE_PUBLISHED';
35294:

Line 35327: from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs

35323:
35324: cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35325: select 1 from dual
35326: where exists (select ppe.element_number
35327: from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs
35328: where ppe.proj_element_id = p_pa_task_id
35329: and ppe.object_type = 'PA_TASKS'
35330: and ppe.parent_structure_id = ppevs.proj_element_id
35331: and ppe.project_id = ppevs.project_id

Line 35743: l_process_code pa_proj_elem_ver_structure.process_code%TYPE; --Bug# 5973460

35739: l_str_ver_id NUMBER:= null;
35740: l_conc_request_id NUMBER := null;
35741: l_message_name VARCHAR2(30) := null;
35742: l_message_type VARCHAR2(30) := null;
35743: l_process_code pa_proj_elem_ver_structure.process_code%TYPE; --Bug# 5973460
35744:
35745: BEGIN
35746:
35747: -- Standard begin of API savepoint

Line 36005: from pa_proj_elem_ver_structure ppes,

36001: ,ppes.project_id project_id
36002: ,ppes.element_version_id structure_version_id
36003: ,ppa.segment1 project_number
36004: ,ppes.name structure_name
36005: from pa_proj_elem_ver_structure ppes,
36006: pa_projects_all ppa
36007: where ppa.project_id = ppes.project_id
36008: and ppes.process_update_wbs_flag = 'Y'
36009: and NVL(ppes.process_code,'WUE') = 'WUE'

Line 36055: -- the below query will use PA_PROJ_ELEM_VER_STRUCTURE_U1 index

36051: l_status := 'Success';
36052: l_exists := NULL;
36053:
36054: Begin
36055: -- the below query will use PA_PROJ_ELEM_VER_STRUCTURE_U1 index
36056: select 'X'
36057: into l_exists
36058: from pa_proj_elem_ver_structure ppes
36059: where ppes.process_update_wbs_flag = 'Y'

Line 36058: from pa_proj_elem_ver_structure ppes

36054: Begin
36055: -- the below query will use PA_PROJ_ELEM_VER_STRUCTURE_U1 index
36056: select 'X'
36057: into l_exists
36058: from pa_proj_elem_ver_structure ppes
36059: where ppes.process_update_wbs_flag = 'Y'
36060: and NVL(ppes.process_code,'WUE') = 'WUE'
36061: and ppes.pev_structure_id = i.pev_structure_id;
36062:

Line 36383: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

36379: l_task_version_id NUMBER := NULL;
36380:
36381: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
36382: select ppev.element_version_id
36383: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
36384: , pa_proj_structure_types ppst, pa_structure_types pst
36385: where ppevs.proj_element_id = ppst.proj_element_id
36386: and ppst.structure_type_id = pst.structure_type_id
36387: and ppev.project_id = ppevs.project_id

Line 36964: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

36960:
36961:
36962: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
36963: select ppev.element_version_id
36964: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
36965: , pa_proj_structure_types ppst, pa_structure_types pst
36966: where ppevs.proj_element_id = ppst.proj_element_id
36967: and ppst.structure_type_id = pst.structure_type_id
36968: and ppev.project_id = ppevs.project_id

Line 37552: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

37548: l_record_version_number NUMBER := NULL;
37549:
37550: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
37551: select ppev.element_version_id
37552: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
37553: , pa_proj_structure_types ppst, pa_structure_types pst
37554: where ppevs.proj_element_id = ppst.proj_element_id
37555: and ppst.structure_type_id = pst.structure_type_id
37556: and ppev.project_id = ppevs.project_id

Line 37969: from pa_proj_elem_ver_structure ppevs,

37965: --cursor which fetches the previous published version
37966: cursor c_prev_published_version(p_pa_project_id IN NUMBER) is
37967: select element_version_id from (
37968: select element_version_id
37969: from pa_proj_elem_ver_structure ppevs,
37970: pa_proj_structure_types ppst
37971: where ppevs.latest_eff_published_flag = 'N'
37972: and ppst.proj_element_id = ppevs.proj_element_id
37973: and ppst.structure_type_id = 1