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

Line 11: -- Note : Call insert_row method of pa_proj_elements, pa_proj_element_versions,

7:
8: -- Procedure : Create_Deliverable
9: -- Type : PRIVATE
10: -- Purpose : Create_Deliverable Procedure will be called for creation of deliverable
11: -- Note : Call insert_row method of pa_proj_elements, pa_proj_element_versions,
12: -- : pa_proj_element_sch and pa_object_relationships packages
13: -- Assumptions : None
14:
15: -- Parameters Type Required Description and Purpose

Line 88: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

84: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
85: , p_dlvr_owner_name IN VARCHAR2 := NULL
86: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
87: , p_carrying_out_org_name IN VARCHAR2 := NULL
88: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
89: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
91: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL

Line 91: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

87: , p_carrying_out_org_name IN VARCHAR2 := NULL
88: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
89: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
91: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
93: , p_dlvr_type_name IN VARCHAR2 := NULL
94: , p_dlvr_reference IN VARCHAR2 := NULL -- 3435905
95: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL

Line 139: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL;

135: l_debug_level5 CONSTANT NUMBER := 5;
136:
137: X_ROW_ID VARCHAR2(18);
138: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL;
139: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL;
140: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE := NULL;
141: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE := NULL;
142: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL; -- 3570283 added
143: l_prog_rollup_method VARCHAR2(30) := NULL;

Line 298: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Called ',

294: l_debug_level3);
295: END IF;
296:
297: IF l_debug_mode = 'Y' THEN
298: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Called ',
299: l_debug_level3);
300: END IF;
301:
302: -- call insert_row of pa_proj_element_versions package

Line 302: -- call insert_row of pa_proj_element_versions package

298: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Called ',
299: l_debug_level3);
300: END IF;
301:
302: -- call insert_row of pa_proj_element_versions package
303:
304: l_dlvr_version_id := p_dlvr_version_id;
305:
306: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row

Line 306: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row

302: -- call insert_row of pa_proj_element_versions package
303:
304: l_dlvr_version_id := p_dlvr_version_id;
305:
306: PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row
307: (
308: X_ROW_ID => X_ROW_ID
309: ,X_ELEMENT_VERSION_ID => l_dlvr_version_id
310: ,X_PROJ_ELEMENT_ID => l_proj_element_id

Line 339: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Element['||l_dlvr_version_id||']',

335: ,X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
336: );
337:
338: IF l_debug_mode = 'Y' THEN
339: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_VERSIONS_PKG.Insert_Row Element['||l_dlvr_version_id||']',
340: l_debug_level3);
341: END IF;
342:
343: IF l_debug_mode = 'Y' THEN

Line 606: -- Note : Call update_row method of pa_proj_elements, pa_proj_element_versions,

602:
603: -- Procedure : Update_Deliverable
604: -- Type : PRIVATE
605: -- Purpose : Update_Deliverable Procedure will be called for creation of deliverable
606: -- Note : Call update_row method of pa_proj_elements, pa_proj_element_versions,
607: -- : pa_proj_element_sch and pa_object_relationships packages
608: -- Assumptions : None
609:
610: -- Parameters Type Required Description and Purpose

Line 683: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

679: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
680: , p_dlvr_owner_name IN VARCHAR2 := NULL
681: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
682: , p_carrying_out_org_name IN VARCHAR2 := NULL
683: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
684: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
685: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
686: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
687: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL

Line 686: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

682: , p_carrying_out_org_name IN VARCHAR2 := NULL
683: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
684: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
685: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
686: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
687: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
688: , p_dlvr_type_name IN VARCHAR2 := NULL
689: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
690: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL

Line 792: PA_PROJ_ELEMENT_VERSIONS PEV

788: IS
789: SELECT
790: ROWID
791: FROM
792: PA_PROJ_ELEMENT_VERSIONS PEV
793: WHERE
794: PEV.PROJ_ELEMENT_ID = p_dlvr_item_id AND
795: PEV.ELEMENT_VERSION_ID = p_dlvr_version_id AND
796: PEV.PROJECT_ID = p_project_id AND

Line 1334: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row Called ',

1330: l_debug_level3);
1331: END IF;
1332:
1333: IF l_debug_mode = 'Y' THEN
1334: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row Called ',
1335: l_debug_level3);
1336: END IF;
1337:
1338: -- call update_row of pa_proj_element_versions package

Line 1338: -- call update_row of pa_proj_element_versions package

1334: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row Called ',
1335: l_debug_level3);
1336: END IF;
1337:
1338: -- call update_row of pa_proj_element_versions package
1339:
1340: OPEN l_row_id_pev_csr;
1341: FETCH l_row_id_pev_csr INTO pev_rec;
1342: CLOSE l_row_id_pev_csr;

Line 1344: PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row

1340: OPEN l_row_id_pev_csr;
1341: FETCH l_row_id_pev_csr INTO pev_rec;
1342: CLOSE l_row_id_pev_csr;
1343:
1344: PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row
1345: (
1346: X_ROW_ID => pev_rec.rowid
1347: ,X_ELEMENT_VERSION_ID => p_dlvr_version_id
1348: ,X_PROJ_ELEMENT_ID => p_dlvr_item_id

Line 1376: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row ',

1372: ,X_TASK_UNPUB_VER_STATUS_CODE => NULL
1373: );
1374:
1375: IF l_debug_mode = 'Y' THEN
1376: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENT_VERSIONS_PKG.Update_Row ',
1377: l_debug_level3);
1378: END IF;
1379:
1380: IF l_debug_mode = 'Y' THEN

Line 1646: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

1642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1643: ,p_debug_mode IN VARCHAR2 :='N'
1644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1645: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1646: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1647: ,p_rec_ver_number IN pa_proj_elements.record_version_number%TYPE
1648: ,p_project_id IN pa_projects_all.project_id%TYPE
1649: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1650: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1810: FROM Pa_Proj_Element_Versions

1806: IF (p_calling_module = 'AMG') THEN
1807:
1808: SELECT Pa_Deliverable_Utils.IS_Dlvr_Item_Based(element_version_id)
1809: INTO l_item_dlv
1810: FROM Pa_Proj_Element_Versions
1811: WHERE proj_element_id = p_dlv_element_id
1812: AND project_id = p_project_id;
1813:
1814: END IF;

Line 1847: DELETE FROM PA_PROJ_ELEMENT_VERSIONS

1843: --The following delete Statements remove the deliverable details
1844: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
1845: WHERE ELEMENT_VERSION_ID = p_dlv_version_id ;
1846:
1847: DELETE FROM PA_PROJ_ELEMENT_VERSIONS
1848: WHERE ELEMENT_VERSION_ID = p_dlv_version_id ;
1849:
1850: DELETE FROM PA_PROJ_ELEMENTS
1851: WHERE PROJ_ELEMENT_ID = p_dlv_element_id ;

Line 1948: DELETE FROM PA_PROJ_ELEMENT_VERSIONS

1944: DELETE FROM PA_PROJ_ELEMENTS
1945: WHERE PROJ_ELEMENT_ID = l_action_element_id_tbl(i);
1946:
1947: FORALL i IN l_action_version_id_tbl.FIRST..l_action_version_id_tbl.LAST
1948: DELETE FROM PA_PROJ_ELEMENT_VERSIONS
1949: WHERE ELEMENT_VERSION_ID = l_action_version_id_tbl(i) ;
1950:
1951:
1952: FORALL i IN l_action_version_id_tbl.FIRST..l_action_version_id_tbl.LAST

Line 2084: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

2080: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2081: ,p_debug_mode IN VARCHAR2 :='N'
2082: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2083: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2084: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2085: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2086: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2087: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
2088: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE

Line 2086: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

2082: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2083: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2084: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2085: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2086: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2087: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
2088: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
2089: ,p_project_id IN pa_projects_all.project_id%TYPE
2090: ,p_calling_context IN VARCHAR2 -- Bug 3555460

Line 2311: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

2307: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2308: ,p_debug_mode IN VARCHAR2 :='N'
2309: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2310: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2311: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2312: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2313: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2314: ,p_project_id IN pa_projects_all.project_id%TYPE
2315: ,p_calling_context IN VARCHAR2 -- Bug 3555460

Line 2313: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

2309: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2310: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2311: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2312: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2313: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2314: ,p_project_id IN pa_projects_all.project_id%TYPE
2315: ,p_calling_context IN VARCHAR2 -- Bug 3555460
2316: ,x_disassociation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2317: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2683: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

2679: ,p_debug_mode IN VARCHAR2 :='N'
2680: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2681: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2682: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2683: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2684: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2685: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2686: ,p_project_id IN pa_projects_all.project_id%TYPE
2687: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2685: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

2681: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2682: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2683: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2684: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2685: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2686: ,p_project_id IN pa_projects_all.project_id%TYPE
2687: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2688: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2689: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2992: DELETE FROM PA_PROJ_ELEMENT_VERSIONS

2988: WHERE structure_type_id = 8
2989: )
2990: RETURNING proj_element_id INTO l_proj_element_id ;
2991:
2992: DELETE FROM PA_PROJ_ELEMENT_VERSIONS
2993: WHERE proj_element_id = l_proj_element_id
2994: AND object_type = 'PA_STRUCTURES'
2995: RETURNING element_version_id INTO l_element_version_id ;
2996:

Line 3013: DELETE FROM PA_PROJ_ELEMENT_VERSIONS

3009: /* Moved the following code to top for Performance Bug Fix 3614361
3010: BULK DELETE Approach is a better approach in this case */
3011:
3012: -- Delete the deliverables,actions and the relationships
3013: DELETE FROM PA_PROJ_ELEMENT_VERSIONS
3014: WHERE project_id = p_project_id
3015: AND object_type in ('PA_DELIVERABLES','PA_ACTIONS')
3016: RETURNING ELEMENT_VERSION_ID ,OBJECT_TYPE,PROJ_ELEMENT_ID --Included Proj_element_id for Bug 3538320
3017: BULK COLLECT INTO l_dlv_version_tbl,l_object_type_tbl,l_dlv_proj_elt_tbl;

Line 3180: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

3176: ,p_debug_mode IN VARCHAR2 :='N'
3177: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3178: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
3179: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
3180: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
3181: ,p_project_id IN pa_projects_all.project_id%TYPE
3182: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete ( default )
3183: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3184: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3208: FROM pa_proj_element_versions pev

3204: CURSOR C(c_project_id IN NUMBER) IS
3205: SELECT 'Y'
3206: FROM DUAL
3207: WHERE EXISTS (SELECT 'Y'
3208: FROM pa_proj_element_versions pev
3209: ,pa_object_relationships obj1
3210: ,pa_object_relationships obj2
3211: WHERE obj1.object_id_from2 = p_task_element_id
3212: AND obj1.relationship_type = 'A'

Line 3439: FROM PA_PROJ_ELEMENT_VERSIONS pev1,

3435: SELECT 'Y'
3436: from dual
3437: WHERE EXISTS(
3438: SELECT 'Y'
3439: FROM PA_PROJ_ELEMENT_VERSIONS pev1,
3440: PA_OBJECT_RELATIONSHIPS obj1,
3441: PA_PROJ_ELEMENT_VERSIONS pev,
3442: PA_OBJECT_RELATIONSHIPS obj2
3443: WHERE obj1.object_id_from2 = pev1.proj_element_id

Line 3441: PA_PROJ_ELEMENT_VERSIONS pev,

3437: WHERE EXISTS(
3438: SELECT 'Y'
3439: FROM PA_PROJ_ELEMENT_VERSIONS pev1,
3440: PA_OBJECT_RELATIONSHIPS obj1,
3441: PA_PROJ_ELEMENT_VERSIONS pev,
3442: PA_OBJECT_RELATIONSHIPS obj2
3443: WHERE obj1.object_id_from2 = pev1.proj_element_id
3444: AND pev1.project_id = c_project_id
3445: AND pev1.object_type = 'PA_TASKS'

Line 3723: ,pa_proj_element_versions pev

3719: ,pvs.scheduled_finish_date
3720: ,ptt.initial_status_code -- Bug#3515852
3721: FROM pa_proj_elements ppe
3722: ,pa_proj_elem_ver_schedule pvs
3723: ,pa_proj_element_versions pev
3724: ,pa_task_types ptt
3725: WHERE ppe.proj_element_id = c_proj_element_id
3726: AND ppe.object_type = 'PA_DELIVERABLES'
3727: AND pev.proj_element_id = c_proj_element_id

Line 3770: ,pa_proj_element_versions pev

3766: ,pvs.scheduled_finish_date
3767: ,ptt.initial_status_code -- Bug#3515852
3768: FROM pa_proj_elements ppe
3769: ,pa_proj_elem_ver_schedule pvs
3770: ,pa_proj_element_versions pev
3771: ,pa_task_types ptt
3772: WHERE ppe.project_id = p_source_project_id
3773: AND ppe.object_type = 'PA_DELIVERABLES'
3774: AND pev.proj_element_id = ppe.proj_element_id

Line 3804: ,pa_proj_element_versions pev

3800: ,pev.element_version_id
3801: FROM pa_proj_structure_types pst
3802: ,pa_structure_types sty
3803: ,pa_proj_elements ppe
3804: ,pa_proj_element_versions pev
3805: WHERE ppe.project_id = p_target_project_id
3806: AND ppe.object_type = 'PA_STRUCTURES'
3807: AND pev.proj_element_id = ppe.proj_element_id
3808: AND pev.project_id = ppe.project_id

Line 3937: ,pa_proj_element_versions_s.nextval

3933: l_name := substr(l_project_name||':'||l_suffix, 1, 240) ;
3934:
3935: -- Get the structure element id and version id before inserting .
3936: SELECT pa_tasks_s.nextval
3937: ,pa_proj_element_versions_s.nextval
3938: INTO l_parent_structure_id
3939: ,l_parent_structure_version_id
3940: FROM dual ;
3941:

Line 3997: INSERT INTO PA_PROJ_ELEMENT_VERSIONS

3993: AND pst.proj_element_id = ppe.proj_element_id
3994: AND pst.structure_type_id = 8 ;--For Deliverable
3995:
3996:
3997: INSERT INTO PA_PROJ_ELEMENT_VERSIONS
3998: ( element_version_id
3999: ,proj_element_id
4000: ,object_type
4001: ,project_id

Line 4340: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENT_VERSIONS ';

4336: RETURNING proj_element_id
4337: BULK COLLECT INTO l_proj_element_id_tbl ;
4338:
4339: IF l_debug_mode = 'Y' THEN
4340: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENT_VERSIONS ';
4341: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4342: END IF;
4343:
4344: -- Populate pa_proj_element_version table

Line 4346: INSERT INTO PA_PROJ_ELEMENT_VERSIONS

4342: END IF;
4343:
4344: -- Populate pa_proj_element_version table
4345: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
4346: INSERT INTO PA_PROJ_ELEMENT_VERSIONS
4347: ( element_version_id
4348: ,proj_element_id
4349: ,object_type
4350: ,project_id

Line 4362: (pa_proj_element_versions_s.nextval

4358: ,source_object_id
4359: ,source_object_type
4360: )
4361: VALUES
4362: (pa_proj_element_versions_s.nextval
4363: ,l_proj_element_id_tbl(i)
4364: ,'PA_DELIVERABLES'
4365: ,p_target_project_id
4366: ,l_parent_structure_version_id

Line 4508: ,pa_proj_element_versions dlv2

4504: ,1
4505: ,fnd_global.login_id
4506: FROM pa_proj_elements tsk1
4507: ,pa_proj_elements dlv1
4508: ,pa_proj_element_versions dlv2
4509: ,pa_object_relationships obj
4510: WHERE dlv1.project_id = p_target_project_id
4511: AND dlv1.object_type = 'PA_DELIVERABLES'
4512: AND dlv1.attribute15 = obj.object_id_to2