APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_PROJ_ELEMENTS

Line 110: FROM pa_proj_elements elem, pa_task_types ptt

106:
107: CURSOR cur_get_del_type_prog_attr
108: IS
109: SELECT nvl(ptt.PROG_ENTRY_ENABLE_FLAG, 'N'), elem.type_id, elem.status_code, elem.NAME -- Bug 6497559
110: FROM pa_proj_elements elem, pa_task_types ptt
111: WHERE project_id = p_project_id
112: AND proj_element_id = p_object_id
113: AND elem.object_type ='PA_DELIVERABLES'
114: AND elem.type_id = ptt.task_type_id(+)

Line 120: FROM pa_proj_elements elem, pa_task_types ptt

116:
117: CURSOR cur_get_task_type_prog_attr
118: IS
119: SELECT nvl(ptt.PROG_ENTRY_ENABLE_FLAG, 'N')
120: FROM pa_proj_elements elem, pa_task_types ptt
121: WHERE project_id = p_project_id
122: AND proj_element_id = p_task_id
123: AND elem.object_type ='PA_TASKS'
124: AND elem.type_id = ptt.task_type_id(+)

Line 260: FROM pa_proj_elements ppe,

256: --- 5194985 either task_id should be 0 or that of the task whose % comp deriv method is deliverable.
257: begin
258: SELECT ppe.proj_element_id
259: into temp_task_id
260: FROM pa_proj_elements ppe,
261: pa_object_relationships por,
262: pa_task_types ttype
263: WHERE
264: ppe.object_type = 'PA_TASKS'

Line 742: UPDATE pa_proj_elements

738: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating progress outdated flag', x_Log_Level=> 3);
739: END IF;
740:
741: --Update outdated flag back to 'N'
742: UPDATE pa_proj_elements
743: SET progress_outdated_flag = 'N'
744: WHERE proj_element_id = p_object_id
745: AND project_id = p_project_id
746: AND object_type = p_object_type;

Line 1769: --Update pa_proj_elements with the status

1765: IF g1_debug_mode = 'Y' THEN
1766: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating Deliverable status', x_Log_Level=> 3);
1767: END IF;
1768:
1769: --Update pa_proj_elements with the status
1770: UPDATE pa_proj_elements
1771: SET status_code = l_del_status
1772: WHERE proj_element_id = p_object_id
1773: AND project_id = p_project_id

Line 1770: UPDATE pa_proj_elements

1766: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating Deliverable status', x_Log_Level=> 3);
1767: END IF;
1768:
1769: --Update pa_proj_elements with the status
1770: UPDATE pa_proj_elements
1771: SET status_code = l_del_status
1772: WHERE proj_element_id = p_object_id
1773: AND project_id = p_project_id
1774: AND object_type = p_object_type;