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_RELATIONSHIP_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 100: from pa_proj_element_versions

96: and t.structure_type_class_code = c_struc_type;
97:
98: CURSOR Get_Element_Id(c_elem_ver_id NUMBER) IS
99: select proj_element_id, object_type
100: from pa_proj_element_versions
101: where element_version_id = c_elem_ver_id;
102:
103: CURSOR Get_Parent_Struc_Ver_Id(c_elem_ver_id NUMBER) IS
104: select parent_structure_Version_id

Line 105: from pa_proj_element_versions

101: where element_version_id = c_elem_ver_id;
102:
103: CURSOR Get_Parent_Struc_Ver_Id(c_elem_ver_id NUMBER) IS
104: select parent_structure_Version_id
105: from pa_proj_element_versions
106: where element_version_id = c_elem_ver_id;
107:
108: CURSOR Get_Top_Task_ID(c_project_id NUMBER, c_structure_id NUMBER) IS
109: select pev.proj_element_id

Line 110: from pa_proj_element_versions pev,

106: where element_version_id = c_elem_ver_id;
107:
108: CURSOR Get_Top_Task_ID(c_project_id NUMBER, c_structure_id NUMBER) IS
109: select pev.proj_element_id
110: from pa_proj_element_versions pev,
111: pa_proj_element_versions pev2,
112: pa_object_relationships rel
113: where pev2.project_id = c_project_id
114: and pev2.object_type = 'PA_STRUCTURES'

Line 111: pa_proj_element_versions pev2,

107:
108: CURSOR Get_Top_Task_ID(c_project_id NUMBER, c_structure_id NUMBER) IS
109: select pev.proj_element_id
110: from pa_proj_element_versions pev,
111: pa_proj_element_versions pev2,
112: pa_object_relationships rel
113: where pev2.project_id = c_project_id
114: and pev2.object_type = 'PA_STRUCTURES'
115: and pev2.proj_element_id = c_structure_id

Line 137: from pa_proj_elem_ver_schedule a, pa_proj_element_versions b

133: and pevs.latest_eff_published_flag = 'Y';
134:
135: CURSOR Get_Scheduled_Dates(c_element_version_id NUMBER) IS
136: select a.scheduled_start_date, a.scheduled_finish_date
137: from pa_proj_elem_ver_schedule a, pa_proj_element_versions b
138: where b.element_version_id = c_element_version_id
139: and a.project_id = b.project_id
140: and a.element_version_id = b.element_version_id;
141:

Line 966: from pa_proj_element_versions

962: If (l_link_task_ver.relationship_type = 'L') THEN
963: --need to delete link task if removing links.
964: select record_version_number
965: into l_task_version_rvn
966: from pa_proj_element_versions
967: where element_version_id = l_link_task_ver.object_id_from1;
968:
969: PA_TASK_PUB1.DELETE_TASK_VERSION(p_commit => 'N',
970: p_debug_mode => p_debug_mode,

Line 1099: FROM pa_proj_element_versions ppev,

1095:
1096: CURSOR get_src_str_status
1097: IS
1098: SELECT status_code
1099: FROM pa_proj_element_versions ppev,
1100: pa_proj_elem_ver_structure ppevs
1101: WHERE ppev.project_id = p_src_proj_id
1102: AND ppev.element_version_id = p_src_task_ver_id
1103: AND ppev.parent_structure_version_id = ppevs.element_version_id

Line 1110: FROM pa_proj_element_versions pev,

1106:
1107: CURSOR get_dest_task_ver_id
1108: IS
1109: SELECT pev2.element_version_id, 'STRUCTURE_WORKING' status_code
1110: FROM pa_proj_element_versions pev,
1111: pa_proj_elem_ver_structure str,
1112: pa_proj_element_versions pev2
1113: WHERE pev.proj_element_id = pev2.proj_element_id
1114: AND pev.project_id = pev2.project_id

Line 1112: pa_proj_element_versions pev2

1108: IS
1109: SELECT pev2.element_version_id, 'STRUCTURE_WORKING' status_code
1110: FROM pa_proj_element_versions pev,
1111: pa_proj_elem_ver_structure str,
1112: pa_proj_element_versions pev2
1113: WHERE pev.proj_element_id = pev2.proj_element_id
1114: AND pev.project_id = pev2.project_id
1115: AND pev2.parent_structure_version_id = str.element_version_id
1116: AND pev2.project_id = str.project_id

Line 1122: FROM pa_proj_element_versions pev,

1118: AND str.status_code <> 'STRUCTURE_PUBLISHED'
1119: AND pev.element_version_id = p_dest_task_ver_id
1120: UNION ALL
1121: SELECT pev2.element_version_id, 'STRUCTURE_PUBLISHED' status_code
1122: FROM pa_proj_element_versions pev,
1123: pa_proj_elem_ver_structure str,
1124: pa_proj_element_versions pev2
1125: WHERE pev.proj_element_id = pev2.proj_element_id
1126: AND pev.project_id = pev2.project_id

Line 1124: pa_proj_element_versions pev2

1120: UNION ALL
1121: SELECT pev2.element_version_id, 'STRUCTURE_PUBLISHED' status_code
1122: FROM pa_proj_element_versions pev,
1123: pa_proj_elem_ver_structure str,
1124: pa_proj_element_versions pev2
1125: WHERE pev.proj_element_id = pev2.proj_element_id
1126: AND pev.project_id = pev2.project_id
1127: AND pev2.parent_structure_version_id = str.element_version_id
1128: AND pev2.project_id = str.project_id

Line 1674: from pa_proj_element_versions ppev1,

1670: AND por1.relationship_type = 'D'
1671: AND por1.object_id_from1 = por2.object_id_from1
1672: AND por2.object_id_to1 IN (
1673: select ppev1.element_version_id
1674: from pa_proj_element_versions ppev1,
1675: pa_proj_element_versions ppev2
1676: where ppev2.element_version_id = por1.object_id_to1
1677: and ppev2.project_id = ppev1.project_id
1678: and ppev2.proj_element_Id = ppev1.proj_element_id);

Line 1675: pa_proj_element_versions ppev2

1671: AND por1.object_id_from1 = por2.object_id_from1
1672: AND por2.object_id_to1 IN (
1673: select ppev1.element_version_id
1674: from pa_proj_element_versions ppev1,
1675: pa_proj_element_versions ppev2
1676: where ppev2.element_version_id = por1.object_id_to1
1677: and ppev2.project_id = ppev1.project_id
1678: and ppev2.proj_element_Id = ppev1.proj_element_id);
1679: --

Line 1686: pa_proj_element_versions ppev

1682: CURSOR cur_get_struc_det(cp_object_relationship_id NUMBER)
1683: IS
1684: SELECT parent_structure_version_id,project_id
1685: FROM pa_object_relationships por,
1686: pa_proj_element_versions ppev
1687: WHERE por.object_relationship_id = cp_object_relationship_id
1688: AND ppev.element_version_id = por.object_id_from1;
1689: l_project_id NUMBER;
1690: l_struc_ver_id NUMBER;

Line 1831: from pa_proj_element_versions a,

1827: a.project_id,
1828: r.relationship_subtype,
1829: r.lag_day,
1830: r.comments
1831: from pa_proj_element_versions a,
1832: pa_proj_element_versions b,
1833: pa_proj_element_versions c,
1834: pa_proj_element_versions d,
1835: pa_object_relationships r

Line 1832: pa_proj_element_versions b,

1828: r.relationship_subtype,
1829: r.lag_day,
1830: r.comments
1831: from pa_proj_element_versions a,
1832: pa_proj_element_versions b,
1833: pa_proj_element_versions c,
1834: pa_proj_element_versions d,
1835: pa_object_relationships r
1836: where a.project_id = b.project_id

Line 1833: pa_proj_element_versions c,

1829: r.lag_day,
1830: r.comments
1831: from pa_proj_element_versions a,
1832: pa_proj_element_versions b,
1833: pa_proj_element_versions c,
1834: pa_proj_element_versions d,
1835: pa_object_relationships r
1836: where a.project_id = b.project_id
1837: and a.proj_element_id = b.proj_element_id

Line 1834: pa_proj_element_versions d,

1830: r.comments
1831: from pa_proj_element_versions a,
1832: pa_proj_element_versions b,
1833: pa_proj_element_versions c,
1834: pa_proj_element_versions d,
1835: pa_object_relationships r
1836: where a.project_id = b.project_id
1837: and a.proj_element_id = b.proj_element_id
1838: and a.parent_structure_version_id = P_source_struc_ver_id

Line 1864: from pa_proj_element_versions

1860: l_dependency_rec get_dependency%ROWTYPE;
1861:
1862: CURSOR get_parent_struc_ver_id(c_elem_ver_id NUMBER) IS
1863: select parent_structure_version_id, project_id
1864: from pa_proj_element_versions
1865: where element_version_id = c_elem_ver_id;
1866: l_parent_ver_id1 NUMBER;
1867: l_parent_ver_id2 NUMBER;
1868: l_project_id1 NUMBER;

Line 2037: from pa_proj_element_versions ppev

2033:
2034:
2035: cursor l_cur_all_tasks(c_task_ver_id NUMBER) is
2036: select count(ppev.element_version_id)
2037: from pa_proj_element_versions ppev
2038: where ppev.parent_structure_version_id = (select ppev2.parent_structure_version_id
2039: from pa_proj_element_versions ppev2
2040: where ppev2.element_version_id = c_task_ver_id)
2041: and ppev.object_type = 'PA_TASKS'

Line 2039: from pa_proj_element_versions ppev2

2035: cursor l_cur_all_tasks(c_task_ver_id NUMBER) is
2036: select count(ppev.element_version_id)
2037: from pa_proj_element_versions ppev
2038: where ppev.parent_structure_version_id = (select ppev2.parent_structure_version_id
2039: from pa_proj_element_versions ppev2
2040: where ppev2.element_version_id = c_task_ver_id)
2041: and ppev.object_type = 'PA_TASKS'
2042: and ppev.element_version_id not in (select pcdt.src_task_ver_id
2043: from pa_copy_dep_temp pcdt);

Line 2530: FROM pa_proj_element_versions ppev

2526: --
2527: IF l_found_flag = 1 THEN
2528: SELECT project_id
2529: INTO l_src_proj_id
2530: FROM pa_proj_element_versions ppev
2531: WHERE ppev.element_version_id = p_destin_ver_tbl(i);
2532: --
2533: PA_Relationship_Pvt.Create_dependency (
2534: p_src_proj_id => l_src_proj_id

Line 2596: pa_proj_element_versions ppev1

2592:
2593: CURSOR Check_Prev_Ver_Exists IS
2594: Select rel.object_relationship_id, rel.Record_Version_Number
2595: From pa_object_relationships rel,
2596: pa_proj_element_versions ppev1
2597: Where rel.relationship_type = 'D'
2598: and rel.object_id_from1 = ppev1.element_version_id
2599: and rel.object_id_to2 <> rel.object_id_from2
2600: and ppev1.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID;

Line 2604: pa_proj_element_versions ppev1,

2600: and ppev1.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID;
2601: /* --bug 3970398
2602: Select rel.object_relationship_id, rel.Record_Version_Number
2603: From pa_object_relationships rel,
2604: pa_proj_element_versions ppev1,
2605: pa_proj_element_versions ppev2
2606: Where rel.relationship_type = 'D'
2607: and rel.object_id_from1 = ppev1.element_version_id
2608: and rel.object_id_to1 = ppev2.element_version_id

Line 2605: pa_proj_element_versions ppev2

2601: /* --bug 3970398
2602: Select rel.object_relationship_id, rel.Record_Version_Number
2603: From pa_object_relationships rel,
2604: pa_proj_element_versions ppev1,
2605: pa_proj_element_versions ppev2
2606: Where rel.relationship_type = 'D'
2607: and rel.object_id_from1 = ppev1.element_version_id
2608: and rel.object_id_to1 = ppev2.element_version_id
2609: and rel.object_id_to2 <> rel.object_id_from2

Line 2615: pa_proj_element_versions ppev3,

2611: --
2612: and Not Exists (
2613: Select 1
2614: From pa_object_relationships rel2,
2615: pa_proj_element_versions ppev3,
2616: pa_proj_element_versions ppev4
2617: where rel2.relationship_type = 'D'
2618: and rel2.object_id_to2 <> rel2.object_id_from2
2619: and rel.object_id_from1 = ppev3.element_version_id

Line 2616: pa_proj_element_versions ppev4

2612: and Not Exists (
2613: Select 1
2614: From pa_object_relationships rel2,
2615: pa_proj_element_versions ppev3,
2616: pa_proj_element_versions ppev4
2617: where rel2.relationship_type = 'D'
2618: and rel2.object_id_to2 <> rel2.object_id_from2
2619: and rel.object_id_from1 = ppev3.element_version_id
2620: and rel.object_id_to1 = ppev4.element_version_id

Line 2634: pa_proj_element_versions ppev,

2630: select ppev2.element_version_id, ppev2.project_id,
2631: rel1.object_id_to1, rel1.object_id_to2, rel1.lag_day, rel1.comments,
2632: rel1.relationship_subtype
2633: from pa_object_relationships rel1,
2634: pa_proj_element_versions ppev,
2635: pa_proj_element_versions ppev2
2636: where rel1.relationship_type = 'D'
2637: and rel1.object_id_to2 <> rel1.object_id_from2
2638: and rel1.object_id_from1 = ppev.element_version_id

Line 2635: pa_proj_element_versions ppev2

2631: rel1.object_id_to1, rel1.object_id_to2, rel1.lag_day, rel1.comments,
2632: rel1.relationship_subtype
2633: from pa_object_relationships rel1,
2634: pa_proj_element_versions ppev,
2635: pa_proj_element_versions ppev2
2636: where rel1.relationship_type = 'D'
2637: and rel1.object_id_to2 <> rel1.object_id_from2
2638: and rel1.object_id_from1 = ppev.element_version_id
2639: and ppev.project_id = ppev2.project_id

Line 2655: pa_proj_element_versions ppev,

2651: ,rel1.lag_day, rel1.comments, rel1.relationship_subtype
2652: -- , rel1.object_relationship_id -- Fix for Bug # 4349093.
2653: , rel1.record_version_number
2654: from pa_object_relationships rel1,
2655: pa_proj_element_versions ppev,
2656: pa_proj_element_versions ppev2
2657: where rel1.relationship_type = 'D'
2658: and rel1.object_id_to2 <> rel1.object_id_from2
2659: and rel1.object_id_to1 = ppev.element_version_id

Line 2656: pa_proj_element_versions ppev2

2652: -- , rel1.object_relationship_id -- Fix for Bug # 4349093.
2653: , rel1.record_version_number
2654: from pa_object_relationships rel1,
2655: pa_proj_element_versions ppev,
2656: pa_proj_element_versions ppev2
2657: where rel1.relationship_type = 'D'
2658: and rel1.object_id_to2 <> rel1.object_id_from2
2659: and rel1.object_id_to1 = ppev.element_version_id
2660: and ppev.project_id = ppev2.project_id

Line 2672: pa_proj_element_versions ppev,

2668: rel1.object_id_to1, rel1.object_id_to2,
2669: ppev2.element_version_id,
2670: ppev2.project_id, rel1.lag_day, rel1.comments, rel1.relationship_subtype
2671: from pa_object_relationships rel1,
2672: pa_proj_element_versions ppev,
2673: pa_proj_element_versions ppev2
2674: where rel1.relationship_type = 'D'
2675: and rel1.object_id_to2 <> rel1.object_id_from2
2676: and rel1.object_id_to1 = ppev.element_version_id

Line 2673: pa_proj_element_versions ppev2

2669: ppev2.element_version_id,
2670: ppev2.project_id, rel1.lag_day, rel1.comments, rel1.relationship_subtype
2671: from pa_object_relationships rel1,
2672: pa_proj_element_versions ppev,
2673: pa_proj_element_versions ppev2
2674: where rel1.relationship_type = 'D'
2675: and rel1.object_id_to2 <> rel1.object_id_from2
2676: and rel1.object_id_to1 = ppev.element_version_id
2677: and ppev.project_id = ppev2.project_id

Line 2689: pa_proj_element_versions ppev

2685: -- If published version is NULL, use this SQL
2686: CURSOR Delete_Publ_Ver IS
2687: select rel.object_relationship_id, rel.Record_Version_Number
2688: from pa_object_relationships rel,
2689: pa_proj_element_versions ppev
2690: where rel.relationship_type = 'D'
2691: and rel.object_id_from1 = ppev.element_version_id
2692: and ppev.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID
2693: --

Line 2698: pa_proj_element_versions ppev

2694: and rel.object_id_from2 <> rel.object_id_to2
2695: UNION
2696: select rel.object_relationship_id, rel.Record_Version_Number
2697: from pa_object_relationships rel,
2698: pa_proj_element_versions ppev
2699: where rel.relationship_type = 'D'
2700: and rel.object_id_to1 = ppev.element_version_id
2701: and ppev.parent_structure_version_id = P_Previous_Pub_Struc_Ver_ID
2702: --

Line 3111: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */

3107: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Src Structure Elem Id=> '||p_src_task_elem_ver_id);
3108: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3109: END IF;
3110: --
3111: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3112: /* This API call create task in pa_proj_element_versions and creates relationship between */
3113: /* linking task and its parent task in the pa_object_relationships table */
3114: PA_TASK_PUB1.CREATE_TASK_VERSION
3115: ( p_validate_only => FND_API.G_FALSE

Line 3112: /* This API call create task in pa_proj_element_versions and creates relationship between */

3108: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION Linking Task Elem Id => '||x_lnk_task_elem_id);
3109: END IF;
3110: --
3111: /* Creating linking task in the pa_proj_element_versions and pa_object_relationships table */
3112: /* This API call create task in pa_proj_element_versions and creates relationship between */
3113: /* linking task and its parent task in the pa_object_relationships table */
3114: PA_TASK_PUB1.CREATE_TASK_VERSION
3115: ( p_validate_only => FND_API.G_FALSE
3116: ,p_validation_level => 0

Line 3435: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type

3431: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE
3432: -- p_debug_mode IN VARCHAR2 :='N'
3433: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3434: -- p_src_proj_id IN pa_projects_all.project_id%type
3435: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3436: -- p_dest_proj_id IN pa_projects_all.project_id%type
3437: -- p_dest_proj_name IN pa_projects_all.name%type
3438: -- p_comment IN pa_object_relationships.comments%type
3439: -- x_return_status OUT VARCHAR2

Line 3463: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,

3459: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3460: p_debug_mode IN VARCHAR2 :='N',
3461: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3462: p_src_proj_id IN pa_projects_all.project_id%type,
3463: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3464: p_dest_proj_id IN pa_projects_all.project_id%type,
3465: p_dest_proj_name IN pa_projects_all.name%type,
3466: p_comment IN pa_object_relationships.comments%type,
3467: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3475: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;

3471: l_src_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3472: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3473: --
3474: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;
3475: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;
3476: l_src_task_elem_id pa_proj_elements.proj_element_id%type;
3477: l_src_task_financial_flag pa_proj_element_versions.financial_task_flag%type;
3478: --
3479: l_dest_fin_str_ver_id pa_proj_element_versions.element_version_id%type:=0;

Line 3477: l_src_task_financial_flag pa_proj_element_versions.financial_task_flag%type;

3473: --
3474: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;
3475: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;
3476: l_src_task_elem_id pa_proj_elements.proj_element_id%type;
3477: l_src_task_financial_flag pa_proj_element_versions.financial_task_flag%type;
3478: --
3479: l_dest_fin_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3480: l_dest_wp_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3481: l_dest_wp_struct_element_id pa_proj_elements.proj_element_id%type:=0;

Line 3479: l_dest_fin_str_ver_id pa_proj_element_versions.element_version_id%type:=0;

3475: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;
3476: l_src_task_elem_id pa_proj_elements.proj_element_id%type;
3477: l_src_task_financial_flag pa_proj_element_versions.financial_task_flag%type;
3478: --
3479: l_dest_fin_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3480: l_dest_wp_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3481: l_dest_wp_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3482: l_dest_fin_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3483: --

Line 3480: l_dest_wp_str_ver_id pa_proj_element_versions.element_version_id%type:=0;

3476: l_src_task_elem_id pa_proj_elements.proj_element_id%type;
3477: l_src_task_financial_flag pa_proj_element_versions.financial_task_flag%type;
3478: --
3479: l_dest_fin_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3480: l_dest_wp_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3481: l_dest_wp_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3482: l_dest_fin_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3483: --
3484: l_parent_strucutre_version_id pa_proj_element_versions.element_version_id%type;

Line 3484: l_parent_strucutre_version_id pa_proj_element_versions.element_version_id%type;

3480: l_dest_wp_str_ver_id pa_proj_element_versions.element_version_id%type:=0;
3481: l_dest_wp_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3482: l_dest_fin_struct_element_id pa_proj_elements.proj_element_id%type:=0;
3483: --
3484: l_parent_strucutre_version_id pa_proj_element_versions.element_version_id%type;
3485: --
3486: l_src_str_fin_enable_fl CHAR(1):='N';
3487: l_src_str_wp_enable_fl CHAR(1):='N';
3488: l_row_id VARCHAR2(100);

Line 3491: l_lnk_task_elem_ver_id pa_proj_element_versions.element_version_id%type;

3487: l_src_str_wp_enable_fl CHAR(1):='N';
3488: l_row_id VARCHAR2(100);
3489: --
3490: l_lnk_task_elem_id number;
3491: l_lnk_task_elem_ver_id pa_proj_element_versions.element_version_id%type;
3492: l_pev_schedule_id number;
3493: l_task_name_number varchar2(240);
3494: l_msg_count NUMBER;
3495: l_msg_data varchar2(250);

Line 3538: from pa_proj_elements ppe, pa_proj_element_versions ppev

3534: where ppa.project_id = c_project_id;
3535:
3536: cursor cur_task_name (c_task_ver_id NUMBER) is
3537: select ppe.name
3538: from pa_proj_elements ppe, pa_proj_element_versions ppev
3539: where ppe.project_id = ppev.project_id
3540: and ppe.proj_element_id = ppev.proj_element_id
3541: and ppev.element_version_id = c_task_ver_id;
3542:

Line 3608: FROM pa_proj_element_versions ppev1,

3604: INTO l_src_struc_elem_id,
3605: l_src_struc_elem_ver_id,
3606: l_src_task_financial_flag,
3607: l_src_task_elem_id
3608: FROM pa_proj_element_versions ppev1,
3609: pa_proj_element_versions ppev2
3610: WHERE ppev1.element_version_id = p_task_ver_id
3611: AND ppev1.object_type = 'PA_TASKS'
3612: AND ppev1.project_id = p_src_proj_id

Line 3609: pa_proj_element_versions ppev2

3605: l_src_struc_elem_ver_id,
3606: l_src_task_financial_flag,
3607: l_src_task_elem_id
3608: FROM pa_proj_element_versions ppev1,
3609: pa_proj_element_versions ppev2
3610: WHERE ppev1.element_version_id = p_task_ver_id
3611: AND ppev1.object_type = 'PA_TASKS'
3612: AND ppev1.project_id = p_src_proj_id
3613: AND ppev2.element_version_id = ppev1.parent_structure_version_id

Line 3708: FROM pa_proj_element_versions

3704: IF (l_dest_wp_str_ver_id >=0) THEN --SMukka
3705: BEGIN
3706: SELECT proj_element_id
3707: INTO l_dest_wp_struct_element_id
3708: FROM pa_proj_element_versions
3709: WHERE element_version_id = l_dest_wp_str_ver_id;
3710: EXCEPTION
3711: WHEN NO_DATA_FOUND THEN
3712: RAISE;

Line 3730: FROM pa_proj_element_versions

3726: IF (l_dest_fin_str_ver_id >= 0) THEN --SMukka
3727: BEGIN
3728: SELECT proj_element_id
3729: INTO l_dest_fin_struct_element_id
3730: FROM pa_proj_element_versions
3731: WHERE element_version_id = l_dest_fin_str_ver_id;
3732: EXCEPTION
3733: WHEN NO_DATA_FOUND THEN
3734: RAISE;

Line 4443: l_src_lnk_task_ver_id pa_proj_element_versions.element_version_id%type;

4439: IS
4440: -- Deleting sub-project association
4441: -- Input parameters for this API are
4442: -- object_relationship_id= p_object_relationships_id
4443: l_src_lnk_task_ver_id pa_proj_element_versions.element_version_id%type;
4444: l_dest_str_ver_id pa_proj_element_versions.element_version_id%type;
4445: l_src_proj_id pa_projects_all.project_id%type;
4446: l_dest_proj_id pa_projects_all.project_id%type;
4447: l_src_task_ver_id pa_proj_element_versions.element_version_id%type;

Line 4444: l_dest_str_ver_id pa_proj_element_versions.element_version_id%type;

4440: -- Deleting sub-project association
4441: -- Input parameters for this API are
4442: -- object_relationship_id= p_object_relationships_id
4443: l_src_lnk_task_ver_id pa_proj_element_versions.element_version_id%type;
4444: l_dest_str_ver_id pa_proj_element_versions.element_version_id%type;
4445: l_src_proj_id pa_projects_all.project_id%type;
4446: l_dest_proj_id pa_projects_all.project_id%type;
4447: l_src_task_ver_id pa_proj_element_versions.element_version_id%type;
4448: l_task_version_rvn NUMBER;

Line 4447: l_src_task_ver_id pa_proj_element_versions.element_version_id%type;

4443: l_src_lnk_task_ver_id pa_proj_element_versions.element_version_id%type;
4444: l_dest_str_ver_id pa_proj_element_versions.element_version_id%type;
4445: l_src_proj_id pa_projects_all.project_id%type;
4446: l_dest_proj_id pa_projects_all.project_id%type;
4447: l_src_task_ver_id pa_proj_element_versions.element_version_id%type;
4448: l_task_version_rvn NUMBER;
4449: l_upd_prog_grp_status NUMBER:=0;
4450: --
4451: l_data VARCHAR2(250);

Line 4466: FROM pa_proj_element_versions

4462: get_lnk_obj_rel_attr_rec get_lnk_obj_rel_attr%ROWTYPE;
4463: --
4464: CURSOR get_rec_ver_num(cp_lnk_task_ver_id NUMBER) IS
4465: SELECT record_version_number --task_Version_rvn
4466: FROM pa_proj_element_versions
4467: WHERE element_version_id = cp_lnk_task_ver_id;
4468: get_rec_ver_num_rec get_rec_ver_num%ROWTYPE;
4469:
4470: CURSOR get_src_task_ver_id(cp_src_lnk_task_ver_id NUMBER) IS

Line 4485: FROM pa_proj_element_versions ppev,

4481: pora.object_id_to1 lnk_task_ver_id,
4482: porb.object_relationship_id lnk_obj_rel_id,
4483: porb.object_id_to1 lnk_dest_str_ver_id
4484: , porb.record_version_number lnk_record_ver_number -- Bug # 5072032.
4485: FROM pa_proj_element_versions ppev,
4486: pa_object_relationships pora,
4487: pa_object_relationships porb,
4488: pa_proj_elements ppe
4489: WHERE pora.relationship_type = 'S'

Line 4508: FROM pa_proj_element_versions

4504: --bug 4370533 --Issue #3 delete link
4505: CURSOR cur_src_structure_ver_id(c_src_task_ver_id NUMBER)
4506: IS
4507: SELECT project_id, parent_structure_version_id
4508: FROM pa_proj_element_versions
4509: WHERE element_version_id = c_src_task_ver_id
4510: ;
4511: l_src_structure_ver_id NUMBER;
4512: l_src_project_id NUMBER;

Line 4888: pa_proj_element_versions ppev

4884: CURSOR get_linking_task_info(cp_src_str_ver_id NUMBER) IS
4885: SELECT ppev.element_version_id lnk_task_ver_id,
4886: ppe.proj_element_id lnk_task_id
4887: FROM pa_proj_elements ppe,
4888: pa_proj_element_versions ppev
4889: WHERE ppe.proj_element_id = ppev.proj_element_id
4890: AND ppe.link_task_flag = 'Y'
4891: AND ppev.parent_structure_version_id = cp_src_str_ver_id
4892: AND ppe.project_id = ppev.project_id;

Line 4921: FROM pa_proj_element_versions

4917: --
4918:
4919: CURSOR get_new_pub_lnk_task_ver_id(c_dest_str_version_id NUMBER, c_link_task_id NUMBER) IS
4920: SELECT element_version_id
4921: FROM pa_proj_element_versions
4922: WHERE parent_structure_Version_id = c_dest_str_version_id
4923: AND proj_element_id = c_link_task_id;
4924: BEGIN
4925: --

Line 4962: FROM pa_proj_element_versions

4958: /*
4959: BEGIN
4960: SELECT element_version_id
4961: INTO l_new_pub_lnk_task_ver_id
4962: FROM pa_proj_element_versions
4963: WHERE parent_structure_Version_id = p_dest_str_version_id
4964: AND proj_element_id = get_linking_task_info_rec.lnk_task_id;
4965: IF (p_debug_mode = 'Y') THEN
4966: pa_debug.debug('Value of l_new_pub_lnk_task_ver_id after select=> '||l_new_pub_lnk_task_ver_id);

Line 5165: Select 1 from pa_proj_element_versions a, pa_proj_elem_ver_structure b

5161: l_pub_str_ver_enable VARCHAR2(1);
5162: l_upd_prog_grp_status NUMBER:=0;
5163: --
5164: CURSOR get_working_ver(c_ver_id NUMBER) IS
5165: Select 1 from pa_proj_element_versions a, pa_proj_elem_ver_structure b
5166: where a.element_version_id = c_ver_id
5167: and a.project_id = b.project_id
5168: and a.parent_structure_version_id = b.element_version_id
5169: and b.status_code <> 'STRUCTURE_PUBLISHED';

Line 5211: FROM pa_proj_element_versions

5207: IF p_publish_fl = 'Y' THEN
5208: /* Will tell if versioning is enabled or not on the pub str*/
5209: SELECT project_id
5210: INTO l_proj_id
5211: FROM pa_proj_element_versions
5212: WHERE element_Version_id = get_coming_in_lnk_info_rec.object_id_from1;
5213: l_pub_str_ver_enable:=PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_proj_id);
5214: IF l_pub_str_ver_enable = 'N' THEN
5215: l_move_link_fl:='Y';

Line 5591: FROM pa_proj_element_versions

5587: SET PROCESS_UPDATE_WBS_FLAG = 'Y',
5588: process_code = 'CPI'
5589: WHERE project_id = cur_obj_rel_rec.object_id_from2
5590: AND element_version_id=(select parent_structure_version_id
5591: FROM pa_proj_element_versions
5592: WHERE project_id=cur_obj_rel_rec.object_id_from2
5593: AND element_version_id= cur_obj_rel_rec.object_id_from1
5594: );
5595: END LOOP;