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.

[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 58: pa_proj_element_versions elever

54: allTasks.record_version_number
55:
56: FROM
57: PA_TASKS allTasks,
58: pa_proj_element_versions elever
59: WHERE
60: elever.element_version_id = l_task_version_id
61: AND
62: elever.project_id = l_project_id

Line 5810: FROM pa_proj_element_versions ppev

5806:
5807: --Added for bug 3746912
5808: CURSOR cur_get_str_type_from_str_id( c_structure_version_id IN NUMBER ) IS
5809: SELECT pst.structure_type
5810: FROM pa_proj_element_versions ppev
5811: ,pa_proj_structure_types ppst
5812: ,pa_structure_types pst
5813: WHERE ppev.element_version_id = c_structure_version_id
5814: AND ppev.proj_element_id = ppst.proj_element_id

Line 5847: l_structure_version_id pa_proj_element_versions.element_version_id%TYPE;

5843: l_str_ver_type VARCHAR2(1);
5844: --bug 3098668
5845:
5846: -- Bug 3106457
5847: l_structure_version_id pa_proj_element_versions.element_version_id%TYPE;
5848: --Begin Add by rtarway For FP.M Changes for Mapping and Set Financial Task
5849: l_patask_record_version_number NUMBER;
5850: --End Add by rtarway For FP.M Changes for Mapping and Set Financial Task
5851: --Bug 3279981 To store the project's flags

Line 7452: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%TYPE)

7448: --bug 2732895
7449:
7450: -- This block has been added for the bug 3106457 to derive the structure version id.
7451: declare
7452: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%TYPE)
7453: is
7454: select parent_structure_version_id
7455: from pa_proj_element_versions
7456: where element_version_id = c_task_version_id;

Line 7455: from pa_proj_element_versions

7451: declare
7452: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%TYPE)
7453: is
7454: select parent_structure_version_id
7455: from pa_proj_element_versions
7456: where element_version_id = c_task_version_id;
7457: begin
7458: open cur_str_ver(l_task_version_id);
7459: fetch cur_str_ver into l_structure_version_id;

Line 7698: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%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
7700: select parent_structure_version_id
7701: from pa_proj_element_versions
7702: where element_version_id = c_task_version_id;

Line 7701: from pa_proj_element_versions

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
7700: select parent_structure_version_id
7701: from pa_proj_element_versions
7702: where element_version_id = c_task_version_id;
7703:
7704: -- Begin fix for Bug # 4373055.
7705:

Line 7894: FROM pa_proj_element_versions

7890: -- Bug 3010538
7891: BEGIN
7892: SELECT parent_structure_version_id
7893: INTO l_structure_version_id
7894: FROM pa_proj_element_versions
7895: WHERE element_version_id = p_task_version_id ;
7896: EXCEPTION
7897: WHEN NO_DATA_FOUND THEN
7898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 10099: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

10095: --Cursor to get the current published version when structure type and project id is known
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

Line 10114: FROM pa_proj_element_versions c, pa_structure_types a, pa_proj_structure_types b

10110: --Cursor to get the working version when structure type and project id is known
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

Line 10332: l_update_structure_version_id pa_proj_element_versions.element_version_id%TYPE;

10328: --
10329: struct_ver_updatable VARCHAR(1);
10330:
10331: --For Bug 2931183
10332: l_update_structure_version_id pa_proj_element_versions.element_version_id%TYPE;
10333: l_debug_mode varchar2(1);
10334:
10335: --
10336: l_failed_row_id_list VARCHAR2(32767);

Line 22781: --l_structure_version_id pa_proj_element_versions.element_version_id%TYPE;

22777: l_update_wbs_flag VARCHAR2(1);
22778: l_long_task_name VARCHAR2(240); /*Added for bug 2982057 */
22779:
22780: --Bug 3106457
22781: --l_structure_version_id pa_proj_element_versions.element_version_id%TYPE;
22782: --Changed by rtarway for BUG 3919800, the type gives error when assigned a value containg miss num
22783: l_structure_version_id NUMBER;
22784:
22785: -- FP-M Bug # 3301192

Line 22904: FROM pa_proj_element_versions c

22900: --Used to get current_working_version in case of VE case
22901: CURSOR cur_get_working_struc_ver (l_project_id NUMBER,l_structure_type VARCHAR2)
22902: IS
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

Line 22920: FROM pa_proj_element_versions c

22916: --Used to get structure version in VD case
22917: CURSOR cursor_get_struc_ver (l_project_id NUMBER,l_structure_type VARCHAR2)
22918: IS
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

Line 22935: from pa_proj_element_versions

22931:
22932: CURSOR CUR_GET_FINANCIAL_FLAG (l_project_id NUMBER, l_proj_element_id NUMBER , l_parent_str_ver_id NUMBER)
22933: IS
22934: SELECT FINANCIAL_TASK_FLAG
22935: from pa_proj_element_versions
22936: where project_id = l_project_id
22937: and proj_element_id = l_proj_element_id
22938: and parent_structure_version_id = l_parent_str_ver_id;
22939:

Line 31278: FROM pa_proj_element_versions vers

31274: and lookup_code = p_pm_product_code;
31275:
31276: Cursor C_vers (p_proj_element_id NUMBER) IS
31277: SELECT vers.element_version_id
31278: FROM pa_proj_element_versions vers
31279: , pa_proj_elements elem
31280: WHERE vers.proj_element_id = elem.proj_element_id
31281: AND elem.project_id = vers.project_id
31282: AND elem.proj_element_id = p_proj_element_id

Line 33969: from pa_proj_element_versions

33965: --This cursor is based on assumption that a financial structure will have only one version in a project.
33966: CURSOR cur_get_fin_task_version_id(l_project_id NUMBER, l_fp_task_id NUMBER)
33967: is
33968: Select element_version_id
33969: from pa_proj_element_versions
33970: where proj_element_id = l_fp_task_id
33971: and project_id = l_project_id
33972: and financial_task_flag = 'Y';
33973:

Line 34262: from pa_proj_element_versions

34258: --This cursor is based on assumption that a financial structure will have only one version in a project.
34259: CURSOR cur_get_mapped_task_version_id(p_project_id NUMBER, p_mapped_task_id NUMBER)
34260: is
34261: Select element_version_id
34262: from pa_proj_element_versions
34263: where proj_element_id = p_mapped_task_id
34264: and project_id = p_project_id
34265: and financial_task_flag = 'Y';
34266:

Line 34624: from pa_proj_element_versions

34620: --This cursor is based on assumption that a financial structure will have only one version in a project.
34621: CURSOR cur_get_mapped_task_version_id(p_project_id NUMBER, p_mapped_task_id NUMBER)
34622: is
34623: Select element_version_id
34624: from pa_proj_element_versions
34625: where proj_element_id = p_mapped_task_id
34626: and project_id = p_project_id
34627: and financial_task_flag = 'Y';
34628:

Line 35145: from pa_proj_elements ppe, pa_proj_element_versions ppev

35141: -- CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference NUMBER) --Bug 3735799
35142: CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference VARCHAR2) --Bug 3735799
35143: IS
35144: select ppev.element_version_id
35145: from pa_proj_elements ppe, pa_proj_element_versions ppev
35146: where ppe.project_id = c_project_id
35147: and ppe.PM_SOURCE_REFERENCE = c_pm_task_reference
35148: and ppe.project_id = ppev.project_Id
35149: and ppe.proj_element_id = ppev.proj_element_id

Line 35155: from pa_proj_elements ppe, pa_proj_element_versions ppev

35151:
35152: CURSOR get_task_ver_id2(c_project_id NUMBER, c_task_id NUMBER) --Bug 3880403
35153: IS
35154: select ppev.element_version_id
35155: from pa_proj_elements ppe, pa_proj_element_versions ppev
35156: where ppe.project_id = c_project_id
35157: and ppe.proj_element_id = c_task_id
35158: and ppe.project_id = ppev.project_Id
35159: and ppe.proj_element_id = ppev.proj_element_id

Line 35397: from pa_proj_elements ppe, pa_proj_element_versions ppev

35393: -- CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference NUMBER) --Bug 3735799
35394: CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference VARCHAR2) --Bug 3735799
35395: IS
35396: select ppev.element_version_id
35397: from pa_proj_elements ppe, pa_proj_element_versions ppev
35398: where ppe.project_id = c_project_id
35399: and ppe.PM_SOURCE_REFERENCE = c_pm_task_reference
35400: and ppe.project_id = ppev.project_Id
35401: and ppe.proj_element_id = ppev.proj_element_id

Line 35407: from pa_proj_elements ppe, pa_proj_element_versions ppev

35403:
35404: CURSOR get_task_ver_id2(c_project_id NUMBER, c_task_id NUMBER) --Bug 3880403
35405: IS
35406: select ppev.element_version_id
35407: from pa_proj_elements ppe, pa_proj_element_versions ppev
35408: where ppe.project_id = c_project_id
35409: and ppe.proj_element_id = c_task_id
35410: and ppe.project_id = ppev.project_Id
35411: and ppe.proj_element_id = ppev.proj_element_id

Line 35658: from pa_proj_elements ppe, pa_proj_element_versions ppev

35654: -- CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference NUMBER) --Bug 3735799
35655: CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference VARCHAR2) --Bug 3735799
35656: IS
35657: select ppev.element_version_id
35658: from pa_proj_elements ppe, pa_proj_element_versions ppev
35659: where ppe.project_id = c_project_id
35660: and ppe.PM_SOURCE_REFERENCE = c_pm_task_reference
35661: and ppe.project_id = ppev.project_Id
35662: and ppe.proj_element_id = ppev.proj_element_id

Line 35668: from pa_proj_elements ppe, pa_proj_element_versions ppev

35664:
35665: CURSOR get_task_ver_id2(c_project_id NUMBER, c_task_id NUMBER) --Bug 3880403
35666: IS
35667: select ppev.element_version_id
35668: from pa_proj_elements ppe, pa_proj_element_versions ppev
35669: where ppe.project_id = c_project_id
35670: and ppe.proj_element_id = c_task_id
35671: and ppe.project_id = ppev.project_Id
35672: and ppe.proj_element_id = ppev.proj_element_id

Line 35900: from pa_proj_element_versions ppev

35896:
35897: cursor cur_task_status(c_project_id NUMBER, c_task_id NUMBER, c_task_version_id NUMBER)
35898: is
35899: select task_unpub_ver_status_code,parent_structure_version_id
35900: from pa_proj_element_versions ppev
35901: where ppev.project_id = c_project_id
35902: and ppev.proj_element_id = c_task_id
35903: and ppev.element_version_id = c_task_version_id;
35904:

Line 35914: select element_version_id from pa_proj_element_versions

35910: and project_id = c_project_id ;
35911:
35912: cursor get_task_ver_id(c_task_id NUMBER)
35913: is
35914: select element_version_id from pa_proj_element_versions
35915: where proj_element_id = c_task_id ;
35916:
35917: -- Begin fix for Bug # 4096218 : 09-AUG-2005.
35918:

Line 35986: from pa_proj_element_versions pev

35982: cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35983: select 1 from dual
35984: where exists(
35985: select pev.task_unpub_ver_status_code
35986: from pa_proj_element_versions pev
35987: where pev.proj_element_id = p_pa_task_id
35988: and pev.object_type = 'PA_TASKS'
35989: and pev.task_unpub_ver_status_code in ('PUBLISHED','TO_BE_DELETED'));
35990: -- End fix for Bug 5263429

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 37053: from pa_proj_element_versions ppev

37049: where ppe.proj_element_id = c_task_id;
37050:
37051: cursor l_cur_project_id2(c_task_version_id NUMBER) is
37052: select ppev.project_id, ppev.proj_element_id
37053: from pa_proj_element_versions ppev
37054: where ppev.element_version_id = c_task_version_id;
37055:
37056: l_unexp_error_flag VARCHAR2(1) := 'N';
37057: l_exp_error_flag VARCHAR2(1) := 'N';

Line 37066: from pa_projects_all ppa, pa_proj_element_versions ppev

37062: l_msg_data VARCHAR2(2000) := NULL;
37063:
37064: cursor l_cur_prog_name (c_task_version_id NUMBER) is
37065: select ppa.name
37066: from pa_projects_all ppa, pa_proj_element_versions ppev
37067: where ppa.project_id = ppev.project_id
37068: and ppev.element_version_id = c_task_version_id;
37069:
37070: cursor l_cur_prog_name2 (c_project_id NUMBER) is

Line 37082: from pa_proj_elements ppe, pa_proj_element_versions ppev

37078: where ppa.project_id = c_project_id;
37079:
37080: cursor l_cur_task_name (c_task_ver_id NUMBER) is
37081: select ppe.name
37082: from pa_proj_elements ppe, pa_proj_element_versions ppev
37083: where ppe.project_id = ppev.project_id
37084: and ppe.proj_element_id = ppev.proj_element_id
37085: and ppev.element_version_id = c_task_ver_id;
37086:

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 37646: from pa_projects_all ppa, pa_proj_element_versions ppev

37642: and por.object_relationship_id = c_object_relationship_id;
37643:
37644: cursor l_cur_prog_name (c_task_version_id NUMBER) is
37645: select ppa.name
37646: from pa_projects_all ppa, pa_proj_element_versions ppev
37647: where ppa.project_id = ppev.project_id
37648: and ppev.element_version_id = c_task_version_id;
37649:
37650: cursor l_cur_prog_name2 (c_project_id NUMBER) is

Line 37662: from pa_proj_elements ppe, pa_proj_element_versions ppev

37658: where ppa.project_id = c_project_id;
37659:
37660: cursor l_cur_task_name (c_task_ver_id NUMBER) is
37661: select ppe.name
37662: from pa_proj_elements ppe, pa_proj_element_versions ppev
37663: where ppe.project_id = ppev.project_id
37664: and ppe.proj_element_id = ppev.proj_element_id
37665: and ppev.element_version_id = c_task_ver_id;
37666:

Line 37669: from pa_proj_element_versions ppev

37665: and ppev.element_version_id = c_task_ver_id;
37666:
37667: cursor l_cur_project_id2(c_task_version_id NUMBER) is
37668: select ppev.project_id, ppev.proj_element_id
37669: from pa_proj_element_versions ppev
37670: where ppev.element_version_id = c_task_version_id;
37671:
37672: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
37673: select ppa.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 38236: from pa_projects_all ppa, pa_proj_element_versions ppev

38232: and por.object_relationship_id = c_object_relationship_id;
38233:
38234: cursor l_cur_prog_name (c_task_version_id NUMBER) is
38235: select ppa.name
38236: from pa_projects_all ppa, pa_proj_element_versions ppev
38237: where ppa.project_id = ppev.project_id
38238: and ppev.element_version_id = c_task_version_id;
38239:
38240: cursor l_cur_proj_name (c_project_id NUMBER) is

Line 38247: from pa_proj_elements ppe, pa_proj_element_versions ppev

38243: where ppa.project_id = c_project_id;
38244:
38245: cursor l_cur_task_name (c_task_ver_id NUMBER) is
38246: select ppe.name
38247: from pa_proj_elements ppe, pa_proj_element_versions ppev
38248: where ppe.project_id = ppev.project_id
38249: and ppe.proj_element_id = ppev.proj_element_id
38250: and ppev.element_version_id = c_task_ver_id;
38251:

Line 38254: from pa_proj_element_versions ppev

38250: and ppev.element_version_id = c_task_ver_id;
38251:
38252: cursor l_cur_project_id2(c_task_version_id NUMBER) is
38253: select ppev.project_id, ppev.proj_element_id
38254: from pa_proj_element_versions ppev
38255: where ppev.element_version_id = c_task_version_id;
38256:
38257: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
38258: select ppa.project_id

Line 38639: from pa_proj_element_versions

38635:
38636: --cursor which fetches all tasks added as a result of last publish
38637: cursor c_newly_added_tasks(l_published_version IN NUMBER,l_prev_published_version IN NUMBER) is
38638: select proj_element_id
38639: from pa_proj_element_versions
38640: where project_id = P_PA_PROJECT_ID
38641: and object_type = 'PA_TASKS'
38642: and PARENT_STRUCTURE_VERSION_ID = l_published_version
38643: MINUS

Line 38645: from pa_proj_element_versions

38641: and object_type = 'PA_TASKS'
38642: and PARENT_STRUCTURE_VERSION_ID = l_published_version
38643: MINUS
38644: select proj_element_id
38645: from pa_proj_element_versions
38646: where project_id = P_PA_PROJECT_ID
38647: and object_type = 'PA_TASKS'
38648: and PARENT_STRUCTURE_VERSION_ID = l_prev_published_version;
38649:

Line 38733: FROM pa_proj_element_versions

38729: WHERE project_id = c_project_id;
38730:
38731: CURSOR get_task_details_csr (c_project_id NUMBER) IS
38732: SELECT element_version_id,proj_element_id,display_sequence,wbs_level,wbs_number
38733: FROM pa_proj_element_versions
38734: WHERE project_id = p_project_id
38735: AND object_type = 'PA_TASKS'
38736: ORDER BY display_sequence;
38737:

Line 39641: FROM pa_proj_element_versions

39637: l_cur_project_id NUMBER;
39638: CURSOR cur_proj_id
39639: IS
39640: SELECT project_id
39641: FROM pa_proj_element_versions
39642: WHERE element_version_id = p_structure_version_id;
39643:
39644: CURSOR get_product_code ( c_project_id NUMBER ) IS
39645: SELECT pm_product_code

Line 39815: FROM pa_proj_element_versions

39811: IF nvl(p_task_version_id_tbl.LAST,0)>0 THEN
39812: l_task_version_id := p_task_version_id_tbl(1);
39813:
39814: SELECT proj_element_id INTO l_structure_id
39815: FROM pa_proj_element_versions
39816: WHERE element_version_id = ( Select parent_structure_version_id
39817: from pa_proj_element_versions
39818: where element_version_id = l_task_version_id )
39819: AND object_type = 'PA_STRUCTURES';

Line 39817: from pa_proj_element_versions

39813:
39814: SELECT proj_element_id INTO l_structure_id
39815: FROM pa_proj_element_versions
39816: WHERE element_version_id = ( Select parent_structure_version_id
39817: from pa_proj_element_versions
39818: where element_version_id = l_task_version_id )
39819: AND object_type = 'PA_STRUCTURES';
39820: OPEN cur_struc_type( l_structure_id );
39821: FETCH cur_struc_type INTO l_dummy_char;

Line 40008: , pa_proj_element_versions ppev,

40004:
40005: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
40006: SELECT ptt.prog_entry_enable_flag
40007: FROM pa_task_types ptt
40008: , pa_proj_element_versions ppev,
40009: pa_proj_elements ppe
40010: WHERE ppev.element_version_id = c_element_version_id
40011: AND ppev.proj_element_id = ppe.proj_element_id
40012: AND ptt.object_type = 'PA_TASKS'

Line 40098: from pa_proj_element_versions

40094: l_ref_parent_ver_id NUMBER;
40095:
40096: CURSOR get_wbs_number(c_elem_ver_id NUMBER) is
40097: select wbs_number
40098: from pa_proj_element_versions
40099: where element_version_id = c_elem_ver_id
40100: and object_type ='PA_TASKS';
40101:
40102: l_delete_project_allowed VARCHAR2(1);

Line 40134: FROM pa_proj_element_versions

40130: l_cur_project_id NUMBER;
40131: CURSOR cur_proj_id
40132: IS
40133: SELECT project_id
40134: FROM pa_proj_element_versions
40135: WHERE element_version_id = p_structure_version_id;
40136:
40137: l_plannable_tasks_tbl PA_FP_ELEMENTS_PUB.l_impacted_task_in_tbl_typ;
40138: l_parent_task_id NUMBER;

Line 40170: from pa_object_relationships a, pa_proj_element_versions b

40166: and prior object_type_from = object_type_to
40167: and prior relationship_type = relationship_type
40168: intersect
40169: select a.object_id_to1
40170: from pa_object_relationships a, pa_proj_element_versions b
40171: where a.relationshiP_type = 'S'
40172: and a.object_id_from1 = b.parent_structure_version_id
40173: and b.element_version_id = c_task_ver_id
40174: and a.object_type_from = 'PA_STRUCTURES';

Line 40187: FROM PA_PROJ_ELEMENT_VERSIONS

40183: l_ref_tsk_version_id NUMBER;
40184:
40185: CURSOR cur_get_ref_tsk_ver_id(c_src_wbs_level NUMBER) IS
40186: SELECT element_version_id
40187: FROM PA_PROJ_ELEMENT_VERSIONS
40188: WHERE parent_structure_version_id = p_structure_version_id
40189: AND project_id = p_project_id
40190: AND wbs_level = c_src_wbs_level
40191: AND object_type = 'PA_TASKS'

Line 40195: FROM pa_proj_element_versions

40191: AND object_type = 'PA_TASKS'
40192: AND display_sequence < src_seq_number
40193: AND display_sequence =
40194: (SELECT max (display_sequence)
40195: FROM pa_proj_element_versions
40196: WHERE project_id = p_project_id
40197: AND parent_structure_version_id = p_structure_version_id
40198: AND wbs_level = c_src_wbs_level
40199: AND display_sequence < src_seq_number

Line 40320: FROM PA_PROJ_ELEMENT_VERSIONS

40316:
40317: BEGIN
40318: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
40319: INTO src_elem_ver_id, src_proj_element_id, src_wbs_number, src_wbs_level, src_seq_number, src_parent_str_ver_id, src_object_type
40320: FROM PA_PROJ_ELEMENT_VERSIONS
40321: WHERE element_version_id = p_task_version_id
40322: AND project_id = p_project_id
40323: AND parent_structure_version_id = p_structure_version_id;
40324: EXCEPTION

Line 40346: FROM PA_PROJ_ELEMENT_VERSIONS

40342: -- Get Source Task Information
40343: BEGIN
40344: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
40345: INTO src_elem_ver_id, src_proj_element_id, src_wbs_number, src_wbs_level, src_seq_number, src_parent_str_ver_id, src_object_type
40346: FROM PA_PROJ_ELEMENT_VERSIONS
40347: WHERE element_version_id = p_task_version_id
40348: AND project_id = p_project_id
40349: AND parent_structure_version_id = p_structure_version_id;
40350: EXCEPTION

Line 40384: FROM PA_PROJ_ELEMENT_VERSIONS

40380: -- Otherwise we will again fetch the correct reference task
40381:
40382: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
40383: INTO ref_elem_ver_id, ref_proj_element_id, ref_wbs_number, ref_wbs_level, ref_seq_number, ref_parent_str_ver_id, ref_object_type
40384: FROM PA_PROJ_ELEMENT_VERSIONS
40385: WHERE display_sequence = src_seq_number - 1
40386: AND parent_structure_version_id = p_structure_version_id
40387: AND project_id = p_project_id
40388: AND object_type = 'PA_TASKS';

Line 40406: FROM PA_PROJ_ELEMENT_VERSIONS

40402: l_peer_or_sub := 'PEER';
40403:
40404: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
40405: INTO ref_elem_ver_id, ref_proj_element_id, ref_wbs_number, ref_wbs_level, ref_seq_number, ref_parent_str_ver_id, ref_object_type
40406: FROM PA_PROJ_ELEMENT_VERSIONS
40407: WHERE parent_structure_version_id = p_structure_version_id
40408: AND project_id = p_project_id
40409: AND wbs_level = src_wbs_level+1
40410: AND object_type = 'PA_TASKS'

Line 40414: FROM pa_proj_element_versions

40410: AND object_type = 'PA_TASKS'
40411: AND display_sequence < src_seq_number
40412: AND display_sequence =
40413: (SELECT max (display_sequence)
40414: FROM pa_proj_element_versions
40415: WHERE project_id = p_project_id
40416: AND parent_structure_version_id = p_structure_version_id
40417: AND wbs_level = src_wbs_level+1
40418: AND display_sequence < src_seq_number

Line 40598: pa_proj_element_versions

40594: l_display_sequence_tab, l_wbs_level_tab,
40595: l_wbs_number_tab, l_record_version_tab,
40596: l_changed_flag_tab
40597: FROM
40598: pa_proj_element_versions
40599: WHERE
40600: project_id = p_project_id
40601: AND parent_structure_version_id = p_structure_version_id
40602: AND object_type = 'PA_TASKS'

Line 40618: select proj_element_id INTO l_ref_parent_task_id from pa_proj_element_versions

40614: )
40615: and display_sequence > src_seq_number)
40616: ORDER BY display_sequence ;
40617: */
40618: select proj_element_id INTO l_ref_parent_task_id from pa_proj_element_versions
40619: where element_version_id = l_ref_parent_ver_id and project_id= p_project_id;
40620:
40621: insert into pa_tasks_tmp (task_id)
40622: SELECT task_id

Line 40630: from pa_proj_element_versions

40626: CONNECT BY parent_task_id = prior task_id;
40627:
40628: insert into pa_tasks_tmp (task_id)
40629: select proj_element_id
40630: from pa_proj_element_versions
40631: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);
40632:
40633: SELECT /*+ ordered index(ev1 pa_proj_element_versions_n1) */
40634: element_version_id, proj_element_id, object_type,

Line 40633: SELECT /+ ordered index(ev1 pa_proj_element_versions_n1) /

40629: select proj_element_id
40630: from pa_proj_element_versions
40631: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);
40632:
40633: SELECT /*+ ordered index(ev1 pa_proj_element_versions_n1) */
40634: element_version_id, proj_element_id, object_type,
40635: project_id, parent_structure_version_id,
40636: display_sequence, wbs_level, wbs_number,
40637: record_version_number, 'N' changed_flag

Line 40645: pa_proj_element_versions ev1

40641: l_display_sequence_tab, l_wbs_level_tab,
40642: l_wbs_number_tab, l_record_version_tab,
40643: l_changed_flag_tab
40644: FROM pa_tasks_tmp t1 ,
40645: pa_proj_element_versions ev1
40646: WHERE
40647: project_id = p_project_id
40648: AND parent_structure_version_id = p_structure_version_id
40649: AND object_type = 'PA_TASKS'

Line 40773: UPDATE PA_PROJ_ELEMENT_VERSIONS

40769:
40770: -- Locking should be implemnted here
40771:
40772: FORALL j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST
40773: UPDATE PA_PROJ_ELEMENT_VERSIONS
40774: SET
40775: wbs_level = l_wbs_level_tab(j) ,
40776: wbs_number = l_wbs_number_tab(j) ,
40777: last_update_date = sysdate ,

Line 40949: FROM pa_proj_element_versions

40945:
40946: /*** End Update_task_version and Update_wbs_number code ***/
40947:
40948: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
40949: FROM pa_proj_element_versions
40950: WHERE element_version_id = ( Select parent_structure_version_id
40951: from pa_proj_element_versions
40952: where element_version_id = p_task_version_id )
40953: AND object_type = 'PA_STRUCTURES';

Line 40951: from pa_proj_element_versions

40947:
40948: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
40949: FROM pa_proj_element_versions
40950: WHERE element_version_id = ( Select parent_structure_version_id
40951: from pa_proj_element_versions
40952: where element_version_id = p_task_version_id )
40953: AND object_type = 'PA_STRUCTURES';
40954:
40955:

Line 40985: PA_PROJ_ELEMENT_VERSIONS ppev

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
40989: AND ppev.proj_element_id = pt.task_id;

Line 41419: , pa_proj_element_versions ppev,

41415:
41416: CURSOR check_progress_allowed(c_element_version_id NUMBER) IS
41417: SELECT ptt.prog_entry_enable_flag
41418: FROM pa_task_types ptt
41419: , pa_proj_element_versions ppev,
41420: pa_proj_elements ppe
41421: WHERE ppev.element_version_id = c_element_version_id
41422: AND ppev.proj_element_id = ppe.proj_element_id
41423: AND ppe.TYPE_ID = ptt.task_type_id;

Line 41445: pa_proj_element_versions ppev

41441: -- This case should not be possible for Outdent/Indent
41442: CURSOR cur_new_child(c_ref_task_version_id NUMBER, c_display_sequence NUMBER) IS
41443: SELECT por.object_id_to1, ppev.display_sequence, por.record_version_number, por.object_relationship_id
41444: FROM pa_object_relationships por,
41445: pa_proj_element_versions ppev
41446: WHERE object_id_from1 = c_ref_task_version_id
41447: AND object_id_to1 = element_version_id
41448: AND display_sequence > c_display_sequence
41449: AND relationship_type = 'S'

Line 41545: from pa_proj_element_versions

41541: --end bug 2843737
41542:
41543: CURSOR get_wbs_number(c_elem_ver_id NUMBER) is
41544: select wbs_number
41545: from pa_proj_element_versions
41546: where element_version_id = c_elem_ver_id
41547: and object_type ='PA_TASKS';
41548:
41549: ref_parent_branch_mask VARCHAR2(1000);

Line 41584: FROM pa_proj_element_versions

41580: l_cur_project_id NUMBER;
41581: CURSOR cur_proj_id
41582: IS
41583: SELECT project_id
41584: FROM pa_proj_element_versions
41585: WHERE element_version_id = p_structure_version_id;
41586:
41587: -- end hyau Bug 2852753
41588:

Line 41608: FROM pa_tasks pt, pa_proj_element_versions ppev

41604: CURSOR cur_new_child_task( c_project_id NUMBER, c_wbs_level NUMBER,
41605: c_task_id NUMBER , c_parent_task_id NUMBER )
41606: IS
41607: SELECT pt.task_id, pt.top_task_id, pt.parent_task_id
41608: FROM pa_tasks pt, pa_proj_element_versions ppev
41609: WHERE pt.wbs_level = c_wbs_level
41610: AND parent_task_id = c_parent_task_id
41611: AND pt.project_id = c_project_id
41612: AND pt.task_id = ppev.proj_element_id

Line 41613: AND ppev.display_sequence > ( SELECT display_sequence FROM pa_proj_element_versions

41609: WHERE pt.wbs_level = c_wbs_level
41610: AND parent_task_id = c_parent_task_id
41611: AND pt.project_id = c_project_id
41612: AND pt.task_id = ppev.proj_element_id
41613: AND ppev.display_sequence > ( SELECT display_sequence FROM pa_proj_element_versions
41614: WHERE project_id = c_project_id
41615: AND object_type = 'PA_TASKS'
41616: AND proj_element_id = c_task_id );
41617:

Line 41645: from pa_object_relationships a, pa_proj_element_versions b

41641: and prior object_type_from = object_type_to
41642: and prior relationship_type = relationship_type
41643: intersect
41644: select a.object_id_to1
41645: from pa_object_relationships a, pa_proj_element_versions b
41646: where a.relationshiP_type = 'S'
41647: and a.object_id_from1 = b.parent_structure_version_id
41648: and b.element_version_id = c_task_ver_id
41649: and a.object_type_from = 'PA_STRUCTURES';

Line 41800: FROM PA_PROJ_ELEMENT_VERSIONS

41796: -- Get Source Task Information
41797: BEGIN
41798: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
41799: INTO src_elem_ver_id, src_proj_element_id, src_wbs_number, src_wbs_level, src_seq_number, src_parent_str_ver_id, src_object_type
41800: FROM PA_PROJ_ELEMENT_VERSIONS
41801: WHERE element_version_id = p_task_version_id
41802: AND project_id = p_project_id
41803: AND parent_structure_version_id = p_structure_version_id;
41804: EXCEPTION

Line 41823: FROM PA_PROJ_ELEMENT_VERSIONS

41819:
41820: BEGIN
41821: SELECT element_version_id, proj_element_id, wbs_number, wbs_level, display_sequence, parent_structure_version_id, object_type
41822: INTO ref_elem_ver_id, ref_proj_element_id, ref_wbs_number, ref_wbs_level, ref_seq_number, ref_parent_str_ver_id, ref_object_type
41823: FROM PA_PROJ_ELEMENT_VERSIONS
41824: WHERE parent_structure_version_id = p_structure_version_id
41825: AND project_id = p_project_id
41826: AND (wbs_level = src_wbs_level-1)
41827: AND object_type = 'PA_TASKS'

Line 41830: FROM pa_proj_element_versions

41826: AND (wbs_level = src_wbs_level-1)
41827: AND object_type = 'PA_TASKS'
41828: AND display_sequence =
41829: (SELECT max (display_sequence)
41830: FROM pa_proj_element_versions
41831: WHERE project_id = p_project_id
41832: AND parent_structure_version_id = p_structure_version_id
41833: AND (wbs_level = src_wbs_level-1)
41834: AND display_sequence < src_seq_number

Line 41980: pa_proj_element_versions

41976: l_display_sequence_tab, l_wbs_level_tab,
41977: l_wbs_number_tab, l_record_version_tab,
41978: l_changed_flag_tab
41979: FROM
41980: pa_proj_element_versions
41981: WHERE
41982: project_id = p_project_id
41983: AND parent_structure_version_id = p_structure_version_id
41984: AND object_type = 'PA_TASKS'

Line 41999: select proj_element_id INTO l_ref_parent_task_id from pa_proj_element_versions where element_version_id = l_ref_parent_ver_id and project_id= p_project_id;

41995: and relationship_type = 'S')
41996: )
41997: ORDER BY display_sequence ;
41998: */
41999: select proj_element_id INTO l_ref_parent_task_id from pa_proj_element_versions where element_version_id = l_ref_parent_ver_id and project_id= p_project_id;
42000:
42001: insert into pa_tasks_tmp (task_id)
42002: SELECT task_id
42003: FROM pa_tasks

Line 42010: from pa_proj_element_versions

42006: CONNECT BY parent_task_id = prior task_id;
42007:
42008: insert into pa_tasks_tmp (task_id)
42009: select proj_element_id
42010: from pa_proj_element_versions
42011: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);
42012:
42013: SELECT /*+ ordered index(ev1 pa_proj_element_versions_n1) */
42014: element_version_id, proj_element_id, object_type,

Line 42013: SELECT /+ ordered index(ev1 pa_proj_element_versions_n1) /

42009: select proj_element_id
42010: from pa_proj_element_versions
42011: where ELEMENT_VERSION_ID = p_task_version_id and project_id = p_project_id and not exists (select null from pa_tasks_tmp where task_id = proj_element_id);
42012:
42013: SELECT /*+ ordered index(ev1 pa_proj_element_versions_n1) */
42014: element_version_id, proj_element_id, object_type,
42015: project_id, parent_structure_version_id,
42016: display_sequence, wbs_level, wbs_number,
42017: record_version_number, 'N' changed_flag

Line 42025: pa_proj_element_versions ev1

42021: l_display_sequence_tab, l_wbs_level_tab,
42022: l_wbs_number_tab, l_record_version_tab,
42023: l_changed_flag_tab
42024: FROM pa_tasks_tmp t1 ,
42025: pa_proj_element_versions ev1
42026: WHERE
42027: project_id = p_project_id
42028: AND parent_structure_version_id = p_structure_version_id
42029: AND object_type = 'PA_TASKS'

Line 42214: UPDATE PA_PROJ_ELEMENT_VERSIONS

42210:
42211: -- Locking should be implemented here
42212:
42213: FORALL j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST
42214: UPDATE PA_PROJ_ELEMENT_VERSIONS
42215: SET
42216: wbs_level = l_wbs_level_tab(j) ,
42217: wbs_number = l_wbs_number_tab(j) ,
42218: last_update_date = sysdate ,

Line 42466: FROM pa_proj_element_versions

42462:
42463: /*** End Update_task_version and Update_wbs_number code ***/
42464:
42465: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
42466: FROM pa_proj_element_versions
42467: WHERE element_version_id = ( Select parent_structure_version_id
42468: from pa_proj_element_versions
42469: where element_version_id = p_task_version_id )
42470: AND object_type = 'PA_STRUCTURES';

Line 42468: from pa_proj_element_versions

42464:
42465: SELECT proj_element_id, project_id INTO l_structure_id, l_project_id
42466: FROM pa_proj_element_versions
42467: WHERE element_version_id = ( Select parent_structure_version_id
42468: from pa_proj_element_versions
42469: where element_version_id = p_task_version_id )
42470: AND object_type = 'PA_STRUCTURES';
42471:
42472:

Line 42502: PA_PROJ_ELEMENT_VERSIONS ppev

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
42506: AND ppev.proj_element_id = pt.task_id;

Line 43124: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE=null where project_id=p_project_id

43120: p_msg_name => 'PA_ERROR_UPDATING_PROJECT');
43121: RAISE FND_API.G_EXC_ERROR;
43122: END IF;
43123:
43124: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE=null where project_id=p_project_id
43125: and DEFER_CODE is not null AND parent_structure_version_id=p_structure_version_id;
43126: --Added for bug 16444969
43127: begin
43128: delete from PA_PJI_PROJ_EVENTS_LOG where event_type = 'DEFER_ROLLUP'

Line 43195: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE=null where project_id=i.event_object

43191: p_msg_name => 'PA_ERROR_REFRESHING_STRUCTURE');
43192: RAISE FND_API.G_EXC_ERROR;
43193: END IF;
43194:
43195: UPDATE PA_PROJ_ELEMENT_VERSIONS SET DEFER_CODE=null where project_id=i.event_object
43196: and DEFER_CODE is not null AND parent_structure_version_id=i.attribute4;
43197:
43198:
43199: