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 5839: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

5835: --bug 2738747
5836: l_task_version_id NUMBER;
5837:
5838: -- Bug 3091798.
5839: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
5840:
5841: --bug 3098668
5842: struct_ver_updatable VARCHAR2(1);
5843: l_str_ver_type VARCHAR2(1);

Line 7695: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;

7691:
7692: -- Bug 3010538
7693: l_process_code pa_lookups.lookup_code%TYPE;
7694:
7695: l_request_id pa_proj_elem_ver_structure.conc_request_id%TYPE;
7696:
7697: -- Bug 3106457. Obtain the structure version id give the task version id.
7698: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%TYPE)
7699: is

Line 10100: ,pa_proj_elem_ver_structure d

10096: CURSOR cur_struc_ver_fin(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
10097: IS
10098: SELECT c.element_version_id
10099: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
10100: ,pa_proj_elem_ver_structure d
10101: WHERE c.project_id = c_project_id
10102: AND a.structure_type_id = b.structure_type_id
10103: AND b.proj_element_id = c.proj_element_id
10104: AND a.structure_type = c_structure_type

Line 10115: ,pa_proj_elem_ver_structure d

10111: CURSOR cur_struc_ver_wp(c_project_id pa_projects_all.project_id%TYPE, c_structure_type pa_structure_types.structure_type%TYPE)
10112: IS
10113: SELECT c.element_version_id
10114: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b
10115: ,pa_proj_elem_ver_structure d
10116: WHERE c.project_id = c_project_id
10117: AND a.structure_type_id = b.structure_type_id
10118: AND b.proj_element_id = c.proj_element_id
10119: AND a.structure_type = c_structure_type

Line 22907: , pa_proj_elem_ver_structure d

22903: SELECT c.element_version_id
22904: FROM pa_proj_element_versions c
22905: , pa_structure_types a
22906: , pa_proj_structure_types b
22907: , pa_proj_elem_ver_structure d
22908: WHERE c.project_id = l_project_id
22909: AND a.structure_type_id = b.structure_type_id
22910: AND b.proj_element_id = c.proj_element_id
22911: AND a.structure_type = l_structure_type

Line 22923: , pa_proj_elem_ver_structure d

22919: SELECT c.element_version_id
22920: FROM pa_proj_element_versions c
22921: , pa_structure_types a
22922: , pa_proj_structure_types b
22923: , pa_proj_elem_ver_structure d
22924: WHERE c.project_id = l_project_id
22925: AND a.structure_type_id = b.structure_type_id
22926: AND b.proj_element_id = c.proj_element_id
22927: AND a.structure_type = l_structure_type

Line 28909: FROM PA_PROJ_ELEM_VER_STRUCTURE

28905:
28906: CURSOR l_temp_cursor
28907: IS
28908: SELECT record_version_number, pev_structure_id, name
28909: FROM PA_PROJ_ELEM_VER_STRUCTURE
28910: WHERE project_id = p_pa_project_id and element_version_id = p_structure_version_id;
28911:
28912:
28913: BEGIN

Line 35171: from pa_proj_elem_ver_structure

35167:
35168: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
35169: IS
35170: select STATUS_CODE
35171: from pa_proj_elem_ver_structure
35172: where project_id = c_project_id
35173: and element_version_id = c_structure_version_id;
35174: BEGIN
35175: savepoint create_dep_pub_amg;

Line 35423: from pa_proj_elem_ver_structure

35419:
35420: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
35421: IS
35422: select STATUS_CODE
35423: from pa_proj_elem_ver_structure
35424: where project_id = c_project_id
35425: and element_version_id = c_structure_version_id;
35426:
35427: CURSOR get_rvn(c_id_from NUMBER, c_id_to NUMBER) IS

Line 35684: from pa_proj_elem_ver_structure

35680:
35681: CURSOR get_workplan_status(c_project_id NUMBER, c_structure_version_id NUMBER)
35682: IS
35683: select STATUS_CODE
35684: from pa_proj_elem_ver_structure
35685: where project_id = c_project_id
35686: and element_version_id = c_structure_version_id;
35687:
35688: CURSOR get_rvn(c_id_from NUMBER, c_id_to NUMBER) IS

Line 35937: -- from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs

35933: -- The Following cursor has been commented for Performance Bug 4878722 SQL ID 14909071
35934: -- The purpose of this cursor per usage in this API is to verify whether the task exists in any of the previously published versions
35935: -- cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35936: -- select ppe.element_number
35937: -- from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs
35938: -- where ppe.proj_element_id = p_pa_task_id
35939: -- and ppe.parent_structure_id = ppevs.proj_element_id
35940: -- and ppevs.status_code = 'STRUCTURE_PUBLISHED';
35941:

Line 35974: from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs

35970:
35971: cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35972: select 1 from dual
35973: where exists (select ppe.element_number
35974: from pa_proj_elements ppe, pa_proj_elem_ver_structure ppevs
35975: where ppe.proj_element_id = p_pa_task_id
35976: and ppe.object_type = 'PA_TASKS'
35977: and ppe.parent_structure_id = ppevs.proj_element_id
35978: and ppe.project_id = ppevs.project_id

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

36391: l_str_ver_id NUMBER:= null;
36392: l_conc_request_id NUMBER := null;
36393: l_message_name VARCHAR2(30) := null;
36394: l_message_type VARCHAR2(30) := null;
36395: l_process_code pa_proj_elem_ver_structure.process_code%TYPE; --Bug# 5973460
36396:
36397: BEGIN
36398:
36399: -- Standard begin of API savepoint

Line 36657: from pa_proj_elem_ver_structure ppes,

36653: ,ppes.project_id project_id
36654: ,ppes.element_version_id structure_version_id
36655: ,ppa.segment1 project_number
36656: ,ppes.name structure_name
36657: from pa_proj_elem_ver_structure ppes,
36658: pa_projects_all ppa
36659: where ppa.project_id = ppes.project_id
36660: and ppes.process_update_wbs_flag = 'Y'
36661: and NVL(ppes.process_code,'WUE') = 'WUE'

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

36703: l_status := 'Success';
36704: l_exists := NULL;
36705:
36706: Begin
36707: -- the below query will use PA_PROJ_ELEM_VER_STRUCTURE_U1 index
36708: select 'X'
36709: into l_exists
36710: from pa_proj_elem_ver_structure ppes
36711: where ppes.process_update_wbs_flag = 'Y'

Line 36710: from pa_proj_elem_ver_structure ppes

36706: Begin
36707: -- the below query will use PA_PROJ_ELEM_VER_STRUCTURE_U1 index
36708: select 'X'
36709: into l_exists
36710: from pa_proj_elem_ver_structure ppes
36711: where ppes.process_update_wbs_flag = 'Y'
36712: and NVL(ppes.process_code,'WUE') = 'WUE'
36713: and ppes.pev_structure_id = i.pev_structure_id;
36714:

Line 37036: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

37032: l_task_version_id NUMBER := NULL;
37033:
37034: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
37035: select ppev.element_version_id
37036: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
37037: , pa_proj_structure_types ppst, pa_structure_types pst
37038: where ppevs.proj_element_id = ppst.proj_element_id
37039: and ppst.structure_type_id = pst.structure_type_id
37040: and ppev.project_id = ppevs.project_id

Line 37619: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

37615:
37616:
37617: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
37618: select ppev.element_version_id
37619: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
37620: , pa_proj_structure_types ppst, pa_structure_types pst
37621: where ppevs.proj_element_id = ppst.proj_element_id
37622: and ppst.structure_type_id = pst.structure_type_id
37623: and ppev.project_id = ppevs.project_id

Line 38209: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs

38205: l_record_version_number NUMBER := NULL;
38206:
38207: cursor l_cur_task_ver_id(c_task_id NUMBER, c_structure_type VARCHAR2) is
38208: select ppev.element_version_id
38209: from pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
38210: , pa_proj_structure_types ppst, pa_structure_types pst
38211: where ppevs.proj_element_id = ppst.proj_element_id
38212: and ppst.structure_type_id = pst.structure_type_id
38213: and ppev.project_id = ppevs.project_id

Line 38626: from pa_proj_elem_ver_structure ppevs,

38622: --cursor which fetches the previous published version
38623: cursor c_prev_published_version(p_pa_project_id IN NUMBER) is
38624: select element_version_id from (
38625: select element_version_id
38626: from pa_proj_elem_ver_structure ppevs,
38627: pa_proj_structure_types ppst
38628: where ppevs.latest_eff_published_flag = 'N'
38629: and ppst.proj_element_id = ppevs.proj_element_id
38630: and ppst.structure_type_id = 1

Line 39660: from pa_proj_elem_ver_structure

39656: AND pst.structure_type_class_code = 'FINANCIAL' ;
39657:
39658: CURSOR cur_pub_versions( c_structure_id NUMBER, c_project_id NUMBER ) is
39659: select 'Y'
39660: from pa_proj_elem_ver_structure
39661: where proj_element_id = c_structure_id
39662: AND project_id = c_project_id
39663: and STATUS_CODE = 'STRUCTURE_PUBLISHED';
39664:

Line 39961: FROM pa_proj_elem_ver_structure

39957: SELECT 'Y'
39958: FROM dual
39959: WHERE EXISTS(
39960: SELECT 'xyz'
39961: FROM pa_proj_elem_ver_structure
39962: WHERE proj_element_id = c_structure_id
39963: AND project_id = c_project_id
39964: AND STATUS_CODE = 'STRUCTURE_PUBLISHED'
39965: );

Line 40984: pa_proj_elem_ver_structure ppa,

40980:
40981: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
40982: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
40983: FROM PA_TASKS pt,
40984: pa_proj_elem_ver_structure ppa,
40985: PA_PROJ_ELEMENT_VERSIONS ppev
40986: WHERE ppev.element_version_id = p_task_version_id
40987: AND ppev.parent_structure_version_id = ppa.element_version_id
40988: AND ppev.project_id = ppa.project_id

Line 41372: FROM pa_proj_elem_ver_structure

41368: SELECT 'Y'
41369: FROM dual
41370: WHERE EXISTS(
41371: SELECT 'xyz'
41372: FROM pa_proj_elem_ver_structure
41373: WHERE proj_element_id = c_structure_id
41374: AND project_id = c_project_id
41375: AND STATUS_CODE = 'STRUCTURE_PUBLISHED'
41376: );

Line 42501: pa_proj_elem_ver_structure ppa,

42497:
42498: SELECT ppev.proj_element_id, pt.record_version_number, ppa.wbs_record_version_number, ppev.project_id
42499: INTO l_task_id, l_task_record_version_number, l_wbs_record_version_number, l_project_id
42500: FROM PA_TASKS pt,
42501: pa_proj_elem_ver_structure ppa,
42502: PA_PROJ_ELEMENT_VERSIONS ppev
42503: WHERE ppev.element_version_id = p_task_version_id
42504: AND ppev.parent_structure_version_id = ppa.element_version_id
42505: AND ppev.project_id = ppa.project_id

Line 43008: l_structure_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;

43004: x_return_status OUT NOCOPY VARCHAR2,
43005: x_msg_count OUT NOCOPY NUMBER,
43006: x_msg_data OUT NOCOPY VARCHAR2)
43007: IS
43008: l_structure_version_id pa_proj_elem_ver_structure.element_version_id%TYPE;
43009: l_rollup_as_of_date date;
43010: l_msg_count NUMBER;
43011: l_msg_data VARCHAR2(2000);
43012: l_return_status VARCHAR2(1);