APPS.PA_DELIVERABLE_PVT dependencies on PA_PROJ_STRUCTURE_TYPES

Line 2987: FROM pa_proj_structure_types

2983: DELETE FROM PA_PROJ_ELEMENTS
2984: WHERE project_id = p_project_id
2985: AND object_type = 'PA_STRUCTURES'
2986: AND proj_element_id in (SELECT proj_element_id
2987: FROM pa_proj_structure_types
2988: WHERE structure_type_id = 8
2989: )
2990: RETURNING proj_element_id INTO l_proj_element_id ;
2991:

Line 2997: DELETE FROM PA_PROJ_STRUCTURE_TYPES

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:
2997: DELETE FROM PA_PROJ_STRUCTURE_TYPES
2998: WHERE proj_element_id = l_proj_element_id ;
2999:
3000: DELETE FROM PA_PROJ_ELEM_VER_SCHEDULE
3001: WHERE proj_element_id = l_proj_element_id

Line 3789: ,pa_proj_structure_types pst

3785: CURSOR c_structure_id IS
3786: SELECT ppe.proj_element_id
3787: ,ppe.element_version_id
3788: FROM pa_proj_elem_ver_structure ppe
3789: ,pa_proj_structure_types pst
3790: ,pa_structure_types sty
3791: WHERE ppe.project_id = p_target_project_id
3792: AND ppe.proj_element_id = pst.proj_element_id
3793: AND pst.structure_type_id = sty.structure_type_id

Line 3801: FROM pa_proj_structure_types pst

3797:
3798: /* Commented for Performance Bug 3614361
3799: SELECT ppe.proj_element_id
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

Line 3990: pa_proj_structure_types pst

3986: ,l_parent_structure_id
3987: ,p_target_project_id
3988: ,'PA_PROJECTS'
3989: FROM pa_proj_elements ppe,
3990: pa_proj_structure_types pst
3991: WHERE ppe.object_type = 'PA_STRUCTURES'
3992: AND ppe.project_id = p_source_project_id
3993: AND pst.proj_element_id = ppe.proj_element_id
3994: AND pst.structure_type_id = 8 ;--For Deliverable

Line 4028: INSERT INTO PA_PROJ_STRUCTURE_TYPES

4024: ,p_target_project_id,
4025: 'PA_PROJECTS'
4026: ) ;
4027:
4028: INSERT INTO PA_PROJ_STRUCTURE_TYPES
4029: ( proj_structure_type_id
4030: ,proj_element_id
4031: ,structure_type_id
4032: ,creation_date

Line 4040: (pa_proj_structure_types_s.nextval

4036: ,last_update_login
4037: ,record_version_number
4038: )
4039: VALUES
4040: (pa_proj_structure_types_s.nextval
4041: ,l_parent_structure_id
4042: ,8
4043: ,SYSDATE
4044: ,fnd_global.user_id

Line 4091: ,pa_proj_structure_types pst

4087: ,p_target_project_id
4088: ,'PA_PROJECTS'
4089: FROM pa_proj_elem_ver_structure ver
4090: ,pa_proj_elements ppe
4091: ,pa_proj_structure_types pst
4092: WHERE ver.project_id = p_source_project_id
4093: AND ppe.proj_element_id = ver.proj_element_id
4094: AND ppe.object_type = 'PA_STRUCTURES'
4095: AND ppe.proj_element_id = pst.proj_element_id