APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_PROJ_ELEMENTS

Line 109: FROM pa_proj_elements elem, pa_task_types ptt

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

Line 119: FROM pa_proj_elements elem, pa_task_types ptt

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

Line 259: FROM pa_proj_elements ppe,

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

Line 711: UPDATE pa_proj_elements

707: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating progress outdated flag', x_Log_Level=> 3);
708: END IF;
709:
710: --Update outdated flag back to 'N'
711: UPDATE pa_proj_elements
712: SET progress_outdated_flag = 'N'
713: WHERE proj_element_id = p_object_id
714: AND project_id = p_project_id
715: AND object_type = p_object_type;

Line 1738: --Update pa_proj_elements with the status

1734: IF g1_debug_mode = 'Y' THEN
1735: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating Deliverable status', x_Log_Level=> 3);
1736: END IF;
1737:
1738: --Update pa_proj_elements with the status
1739: UPDATE pa_proj_elements
1740: SET status_code = l_del_status
1741: WHERE proj_element_id = p_object_id
1742: AND project_id = p_project_id

Line 1739: UPDATE pa_proj_elements

1735: pa_debug.write(x_Module=>'PA_DELIVERABLE_PROGRESS_PUB.UPDATE_DELIVERABLE_PROGRESS', x_Msg => 'Updating Deliverable status', x_Log_Level=> 3);
1736: END IF;
1737:
1738: --Update pa_proj_elements with the status
1739: UPDATE pa_proj_elements
1740: SET status_code = l_del_status
1741: WHERE proj_element_id = p_object_id
1742: AND project_id = p_project_id
1743: AND object_type = p_object_type;