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

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 := NULL
91: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
92: , p_dlvr_type_name IN VARCHAR2 := NULL

Line 157: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

153: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
154: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
155: l_scheduled_finish_date DATE;
156: l_actual_finish_date DATE;
157: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
158:
159: l_dlvr_prg_enabled VARCHAR2(1) := NULL;
160: l_dlvr_action_enabled VARCHAR2(1) := NULL;
161: l_status_code Pa_task_types.initial_status_code%TYPE := NULL;

Line 178: l_dlv_elem_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

174: l_item_description VARCHAR2(2000);
175: l_unit_price OKE_DELIVERABLES_B.UNIT_PRICE%TYPE;
176: l_unit_number OKE_DELIVERABLES_B.UNIT_NUMBER%TYPE;
177: l_currency_code OKE_DELIVERABLES_B.CURRENCY_CODE%TYPE;
178: l_dlv_elem_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
179: l_master_inv_org_id PA_PLAN_RES_DEFAULTS.item_master_id%TYPE;
180:
181: BEGIN
182:

Line 336: SELECT PA_PROJ_ELEMENT_VERSIONS_S.nextval

332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334:
335: -- Fetch dlvr_version_id from sequence
336: SELECT PA_PROJ_ELEMENT_VERSIONS_S.nextval
337: INTO l_dlvr_version_id
338: FROM DUAL;
339:
340: /*==============3435905 : FP M : Deliverables Changes For AMG - END ============================== */

Line 593: FROM Pa_Proj_Element_Versions

589: -- 3630378 changed below cursor to retrieve deliverable element version id
590:
591: SELECT Pa_Deliverable_Utils.IS_Dlvr_Item_Based(element_version_id), element_version_id
592: INTO l_item_dlv, l_dlv_elem_ver_id
593: FROM Pa_Proj_Element_Versions
594: WHERE proj_element_id = p_dlvr_item_id
595: AND project_id = p_project_id;
596:
597: -- 3630378 Added below code for item information

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

863: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
864: , p_dlvr_owner_name IN VARCHAR2 := NULL
865: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
866: , p_carrying_out_org_name IN VARCHAR2 := NULL
867: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
868: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
869: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
870: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
871: , p_dlvr_type_name IN VARCHAR2 := NULL

Line 928: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

924: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
925: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
926: l_scheduled_finish_date DATE;
927: l_actual_finish_date DATE;
928: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
929: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
930: l_dlvr_type_id PA_PROJ_ELEMENTS.TYPE_ID%TYPE;
931: l_task_id PA_TASKS.TASK_ID%TYPE; --added bug 3651538
932: l_deliverable_reference PA_PROJ_ELEMENTS.PM_SOURCE_CODE%TYPE; -- added for bug# 3749447

Line 980: l_dlv_elem_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

976:
977: l_dlv_rec oke_amg_grp.dlv_rec_type;
978:
979: -- added for bug# 3651542
980: l_dlv_elem_ver_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
981: l_master_inv_org_id PA_PLAN_RES_DEFAULTS.item_master_id%TYPE;
982: l_return_status VARCHAR2(1);
983: -- end bug# 3651542
984:

Line 1317: FROM Pa_Proj_Element_Versions

1313: -- this retrieved element_version_id will be passed to oke
1314:
1315: SELECT Pa_Deliverable_Utils.IS_Dlvr_Item_Based(element_version_id), element_version_id
1316: INTO l_item_dlv, l_dlv_elem_ver_id
1317: FROM Pa_Proj_Element_Versions
1318: WHERE proj_element_id = p_dlvr_item_id
1319: AND project_id = p_project_id;
1320:
1321: -- Bug 7562076

Line 1529: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

1525: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1526: ,p_debug_mode IN VARCHAR2 :='N'
1527: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1528: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
1529: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1532: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
1533: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE

Line 1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

1527: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1528: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
1529: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1532: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
1533: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
1534: ,p_project_id IN pa_projects_all.project_id%TYPE
1535: ,p_calling_context IN VARCHAR2 := 'TASKS'

Line 2234: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

2230: ,p_debug_mode IN VARCHAR2 :='N'
2231: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2232: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2233: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2234: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2235: ,p_project_id IN pa_projects_all.project_id%TYPE
2236: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete
2237: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2238: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2679: ,pa_proj_element_versions pev1

2675: ,pev1.element_version_id
2676: ,ppe.element_number
2677: ,ppe.name
2678: FROM pa_proj_elements ppe
2679: ,pa_proj_element_versions pev1
2680: ,pa_proj_element_versions pev2
2681: ,pa_object_relationships obj
2682: WHERE pev2.element_version_id = c_task_version_id
2683: AND obj.object_id_from2 = pev2.proj_element_id

Line 2680: ,pa_proj_element_versions pev2

2676: ,ppe.element_number
2677: ,ppe.name
2678: FROM pa_proj_elements ppe
2679: ,pa_proj_element_versions pev1
2680: ,pa_proj_element_versions pev2
2681: ,pa_object_relationships obj
2682: WHERE pev2.element_version_id = c_task_version_id
2683: AND obj.object_id_from2 = pev2.proj_element_id
2684: AND obj.object_type_from = 'PA_TASKS'

Line 2696: pa_proj_element_versions pev

2692: IS
2693: SELECT ppe.proj_element_id
2694: ,ppe.project_id
2695: FROM pa_proj_elements ppe ,
2696: pa_proj_element_versions pev
2697: WHERE pev.element_version_id = c_task_version_id
2698: AND ppe.proj_element_id = pev.proj_element_id
2699: AND nvl(ppe.base_percent_comp_deriv_code,'X') <> 'DELIVERABLE' ; -- 3461959 added nvl function
2700: