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_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 5660: FROM pa_proj_element_versions ppev

5656:
5657: --Added for bug 3746912
5658: CURSOR cur_get_str_type_from_str_id( c_structure_version_id IN NUMBER ) IS
5659: SELECT pst.structure_type
5660: FROM pa_proj_element_versions ppev
5661: ,pa_proj_structure_types ppst
5662: ,pa_structure_types pst
5663: WHERE ppev.element_version_id = c_structure_version_id
5664: AND ppev.proj_element_id = ppst.proj_element_id

Line 5697: l_structure_version_id pa_proj_element_versions.element_version_id%TYPE;

5693: l_str_ver_type VARCHAR2(1);
5694: --bug 3098668
5695:
5696: -- Bug 3106457
5697: l_structure_version_id pa_proj_element_versions.element_version_id%TYPE;
5698: --Begin Add by rtarway For FP.M Changes for Mapping and Set Financial Task
5699: l_patask_record_version_number NUMBER;
5700: --End Add by rtarway For FP.M Changes for Mapping and Set Financial Task
5701: --Bug 3279981 To store the project's flags

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

7204: --bug 2732895
7205:
7206: -- This block has been added for the bug 3106457 to derive the structure version id.
7207: declare
7208: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%TYPE)
7209: is
7210: select parent_structure_version_id
7211: from pa_proj_element_versions
7212: where element_version_id = c_task_version_id;

Line 7211: from pa_proj_element_versions

7207: declare
7208: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%TYPE)
7209: is
7210: select parent_structure_version_id
7211: from pa_proj_element_versions
7212: where element_version_id = c_task_version_id;
7213: begin
7214: open cur_str_ver(l_task_version_id);
7215: fetch cur_str_ver into l_structure_version_id;

Line 7454: cursor cur_str_ver(c_task_version_id pa_proj_element_versions.element_version_id%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
7456: select parent_structure_version_id
7457: from pa_proj_element_versions
7458: where element_version_id = c_task_version_id;

Line 7457: from pa_proj_element_versions

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
7456: select parent_structure_version_id
7457: from pa_proj_element_versions
7458: where element_version_id = c_task_version_id;
7459:
7460: -- Begin fix for Bug # 4373055.
7461:

Line 7650: FROM pa_proj_element_versions

7646: -- Bug 3010538
7647: BEGIN
7648: SELECT parent_structure_version_id
7649: INTO l_structure_version_id
7650: FROM pa_proj_element_versions
7651: WHERE element_version_id = p_task_version_id ;
7652: EXCEPTION
7653: WHEN NO_DATA_FOUND THEN
7654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

Line 10070: l_update_structure_version_id pa_proj_element_versions.element_version_id%TYPE;

10066: --
10067: struct_ver_updatable VARCHAR(1);
10068:
10069: --For Bug 2931183
10070: l_update_structure_version_id pa_proj_element_versions.element_version_id%TYPE;
10071: l_debug_mode varchar2(1);
10072:
10073: --
10074: l_failed_row_id_list VARCHAR2(32767);

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

22314: l_update_wbs_flag VARCHAR2(1);
22315: l_long_task_name VARCHAR2(240); /*Added for bug 2982057 */
22316:
22317: --Bug 3106457
22318: --l_structure_version_id pa_proj_element_versions.element_version_id%TYPE;
22319: --Changed by rtarway for BUG 3919800, the type gives error when assigned a value containg miss num
22320: l_structure_version_id NUMBER;
22321:
22322: -- FP-M Bug # 3301192

Line 22427: FROM pa_proj_element_versions c

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

Line 22443: FROM pa_proj_element_versions c

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

Line 22458: from pa_proj_element_versions

22454:
22455: CURSOR CUR_GET_FINANCIAL_FLAG (l_project_id NUMBER, l_proj_element_id NUMBER , l_parent_str_ver_id NUMBER)
22456: IS
22457: SELECT FINANCIAL_TASK_FLAG
22458: from pa_proj_element_versions
22459: where project_id = l_project_id
22460: and proj_element_id = l_proj_element_id
22461: and parent_structure_version_id = l_parent_str_ver_id;
22462:

Line 30653: FROM pa_proj_element_versions vers

30649: and lookup_code = p_pm_product_code;
30650:
30651: Cursor C_vers (p_proj_element_id NUMBER) IS
30652: SELECT vers.element_version_id
30653: FROM pa_proj_element_versions vers
30654: , pa_proj_elements elem
30655: WHERE vers.proj_element_id = elem.proj_element_id
30656: AND elem.project_id = vers.project_id
30657: AND elem.proj_element_id = p_proj_element_id

Line 33344: from pa_proj_element_versions

33340: --This cursor is based on assumption that a financial structure will have only one version in a project.
33341: CURSOR cur_get_fin_task_version_id(l_project_id NUMBER, l_fp_task_id NUMBER)
33342: is
33343: Select element_version_id
33344: from pa_proj_element_versions
33345: where proj_element_id = l_fp_task_id
33346: and project_id = l_project_id
33347: and financial_task_flag = 'Y';
33348:

Line 33637: from pa_proj_element_versions

33633: --This cursor is based on assumption that a financial structure will have only one version in a project.
33634: CURSOR cur_get_mapped_task_version_id(p_project_id NUMBER, p_mapped_task_id NUMBER)
33635: is
33636: Select element_version_id
33637: from pa_proj_element_versions
33638: where proj_element_id = p_mapped_task_id
33639: and project_id = p_project_id
33640: and financial_task_flag = 'Y';
33641:

Line 33999: from pa_proj_element_versions

33995: --This cursor is based on assumption that a financial structure will have only one version in a project.
33996: CURSOR cur_get_mapped_task_version_id(p_project_id NUMBER, p_mapped_task_id NUMBER)
33997: is
33998: Select element_version_id
33999: from pa_proj_element_versions
34000: where proj_element_id = p_mapped_task_id
34001: and project_id = p_project_id
34002: and financial_task_flag = 'Y';
34003:

Line 34499: from pa_proj_elements ppe, pa_proj_element_versions ppev

34495: -- CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference NUMBER) --Bug 3735799
34496: CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference VARCHAR2) --Bug 3735799
34497: IS
34498: select ppev.element_version_id
34499: from pa_proj_elements ppe, pa_proj_element_versions ppev
34500: where ppe.project_id = c_project_id
34501: and ppe.PM_SOURCE_REFERENCE = c_pm_task_reference
34502: and ppe.project_id = ppev.project_Id
34503: and ppe.proj_element_id = ppev.proj_element_id

Line 34509: from pa_proj_elements ppe, pa_proj_element_versions ppev

34505:
34506: CURSOR get_task_ver_id2(c_project_id NUMBER, c_task_id NUMBER) --Bug 3880403
34507: IS
34508: select ppev.element_version_id
34509: from pa_proj_elements ppe, pa_proj_element_versions ppev
34510: where ppe.project_id = c_project_id
34511: and ppe.proj_element_id = c_task_id
34512: and ppe.project_id = ppev.project_Id
34513: and ppe.proj_element_id = ppev.proj_element_id

Line 34750: from pa_proj_elements ppe, pa_proj_element_versions ppev

34746: -- CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference NUMBER) --Bug 3735799
34747: CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference VARCHAR2) --Bug 3735799
34748: IS
34749: select ppev.element_version_id
34750: from pa_proj_elements ppe, pa_proj_element_versions ppev
34751: where ppe.project_id = c_project_id
34752: and ppe.PM_SOURCE_REFERENCE = c_pm_task_reference
34753: and ppe.project_id = ppev.project_Id
34754: and ppe.proj_element_id = ppev.proj_element_id

Line 34760: from pa_proj_elements ppe, pa_proj_element_versions ppev

34756:
34757: CURSOR get_task_ver_id2(c_project_id NUMBER, c_task_id NUMBER) --Bug 3880403
34758: IS
34759: select ppev.element_version_id
34760: from pa_proj_elements ppe, pa_proj_element_versions ppev
34761: where ppe.project_id = c_project_id
34762: and ppe.proj_element_id = c_task_id
34763: and ppe.project_id = ppev.project_Id
34764: and ppe.proj_element_id = ppev.proj_element_id

Line 35011: from pa_proj_elements ppe, pa_proj_element_versions ppev

35007: -- CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference NUMBER) --Bug 3735799
35008: CURSOR get_task_ver_id(c_project_id NUMBER, c_pm_task_reference VARCHAR2) --Bug 3735799
35009: IS
35010: select ppev.element_version_id
35011: from pa_proj_elements ppe, pa_proj_element_versions ppev
35012: where ppe.project_id = c_project_id
35013: and ppe.PM_SOURCE_REFERENCE = c_pm_task_reference
35014: and ppe.project_id = ppev.project_Id
35015: and ppe.proj_element_id = ppev.proj_element_id

Line 35021: from pa_proj_elements ppe, pa_proj_element_versions ppev

35017:
35018: CURSOR get_task_ver_id2(c_project_id NUMBER, c_task_id NUMBER) --Bug 3880403
35019: IS
35020: select ppev.element_version_id
35021: from pa_proj_elements ppe, pa_proj_element_versions ppev
35022: where ppe.project_id = c_project_id
35023: and ppe.proj_element_id = c_task_id
35024: and ppe.project_id = ppev.project_Id
35025: and ppe.proj_element_id = ppev.proj_element_id

Line 35253: from pa_proj_element_versions ppev

35249:
35250: cursor cur_task_status(c_project_id NUMBER, c_task_id NUMBER, c_task_version_id NUMBER)
35251: is
35252: select task_unpub_ver_status_code,parent_structure_version_id
35253: from pa_proj_element_versions ppev
35254: where ppev.project_id = c_project_id
35255: and ppev.proj_element_id = c_task_id
35256: and ppev.element_version_id = c_task_version_id;
35257:

Line 35267: select element_version_id from pa_proj_element_versions

35263: and project_id = c_project_id ;
35264:
35265: cursor get_task_ver_id(c_task_id NUMBER)
35266: is
35267: select element_version_id from pa_proj_element_versions
35268: where proj_element_id = c_task_id ;
35269:
35270: -- Begin fix for Bug # 4096218 : 09-AUG-2005.
35271:

Line 35339: from pa_proj_element_versions pev

35335: cursor l_amg_task_csr (p_pa_task_id pa_tasks.task_id%type) is
35336: select 1 from dual
35337: where exists(
35338: select pev.task_unpub_ver_status_code
35339: from pa_proj_element_versions pev
35340: where pev.proj_element_id = p_pa_task_id
35341: and pev.object_type = 'PA_TASKS'
35342: and pev.task_unpub_ver_status_code in ('PUBLISHED','TO_BE_DELETED'));
35343: -- End fix for Bug 5263429

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

36396: where ppe.proj_element_id = c_task_id;
36397:
36398: cursor l_cur_project_id2(c_task_version_id NUMBER) is
36399: select ppev.project_id, ppev.proj_element_id
36400: from pa_proj_element_versions ppev
36401: where ppev.element_version_id = c_task_version_id;
36402:
36403: l_unexp_error_flag VARCHAR2(1) := 'N';
36404: l_exp_error_flag VARCHAR2(1) := 'N';

Line 36413: from pa_projects_all ppa, pa_proj_element_versions ppev

36409: l_msg_data VARCHAR2(2000) := NULL;
36410:
36411: cursor l_cur_prog_name (c_task_version_id NUMBER) is
36412: select ppa.name
36413: from pa_projects_all ppa, pa_proj_element_versions ppev
36414: where ppa.project_id = ppev.project_id
36415: and ppev.element_version_id = c_task_version_id;
36416:
36417: cursor l_cur_prog_name2 (c_project_id NUMBER) is

Line 36429: from pa_proj_elements ppe, pa_proj_element_versions ppev

36425: where ppa.project_id = c_project_id;
36426:
36427: cursor l_cur_task_name (c_task_ver_id NUMBER) is
36428: select ppe.name
36429: from pa_proj_elements ppe, pa_proj_element_versions ppev
36430: where ppe.project_id = ppev.project_id
36431: and ppe.proj_element_id = ppev.proj_element_id
36432: and ppev.element_version_id = c_task_ver_id;
36433:

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

36987: and por.object_relationship_id = c_object_relationship_id;
36988:
36989: cursor l_cur_prog_name (c_task_version_id NUMBER) is
36990: select ppa.name
36991: from pa_projects_all ppa, pa_proj_element_versions ppev
36992: where ppa.project_id = ppev.project_id
36993: and ppev.element_version_id = c_task_version_id;
36994:
36995: cursor l_cur_prog_name2 (c_project_id NUMBER) is

Line 37007: from pa_proj_elements ppe, pa_proj_element_versions ppev

37003: where ppa.project_id = c_project_id;
37004:
37005: cursor l_cur_task_name (c_task_ver_id NUMBER) is
37006: select ppe.name
37007: from pa_proj_elements ppe, pa_proj_element_versions ppev
37008: where ppe.project_id = ppev.project_id
37009: and ppe.proj_element_id = ppev.proj_element_id
37010: and ppev.element_version_id = c_task_ver_id;
37011:

Line 37014: from pa_proj_element_versions ppev

37010: and ppev.element_version_id = c_task_ver_id;
37011:
37012: cursor l_cur_project_id2(c_task_version_id NUMBER) is
37013: select ppev.project_id, ppev.proj_element_id
37014: from pa_proj_element_versions ppev
37015: where ppev.element_version_id = c_task_version_id;
37016:
37017: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
37018: select ppa.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 37579: from pa_projects_all ppa, pa_proj_element_versions ppev

37575: and por.object_relationship_id = c_object_relationship_id;
37576:
37577: cursor l_cur_prog_name (c_task_version_id NUMBER) is
37578: select ppa.name
37579: from pa_projects_all ppa, pa_proj_element_versions ppev
37580: where ppa.project_id = ppev.project_id
37581: and ppev.element_version_id = c_task_version_id;
37582:
37583: cursor l_cur_proj_name (c_project_id NUMBER) is

Line 37590: from pa_proj_elements ppe, pa_proj_element_versions ppev

37586: where ppa.project_id = c_project_id;
37587:
37588: cursor l_cur_task_name (c_task_ver_id NUMBER) is
37589: select ppe.name
37590: from pa_proj_elements ppe, pa_proj_element_versions ppev
37591: where ppe.project_id = ppev.project_id
37592: and ppe.proj_element_id = ppev.proj_element_id
37593: and ppev.element_version_id = c_task_ver_id;
37594:

Line 37597: from pa_proj_element_versions ppev

37593: and ppev.element_version_id = c_task_ver_id;
37594:
37595: cursor l_cur_project_id2(c_task_version_id NUMBER) is
37596: select ppev.project_id, ppev.proj_element_id
37597: from pa_proj_element_versions ppev
37598: where ppev.element_version_id = c_task_version_id;
37599:
37600: cursor l_cur_sub_proj1(c_sub_project_reference VARCHAR2, c_sub_project_id NUMBER) is
37601: select ppa.project_id

Line 37982: from pa_proj_element_versions

37978:
37979: --cursor which fetches all tasks added as a result of last publish
37980: cursor c_newly_added_tasks(l_published_version IN NUMBER,l_prev_published_version IN NUMBER) is
37981: select proj_element_id
37982: from pa_proj_element_versions
37983: where project_id = P_PA_PROJECT_ID
37984: and object_type = 'PA_TASKS'
37985: and PARENT_STRUCTURE_VERSION_ID = l_published_version
37986: MINUS

Line 37988: from pa_proj_element_versions

37984: and object_type = 'PA_TASKS'
37985: and PARENT_STRUCTURE_VERSION_ID = l_published_version
37986: MINUS
37987: select proj_element_id
37988: from pa_proj_element_versions
37989: where project_id = P_PA_PROJECT_ID
37990: and object_type = 'PA_TASKS'
37991: and PARENT_STRUCTURE_VERSION_ID = l_prev_published_version;
37992: