APPS.PA_PROGRESS_PUB dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 276: FROM pa_proj_elem_ver_schedule

272: IS
273: SELECT
274: scheduled_start_date
275: , scheduled_finish_date
276: FROM pa_proj_elem_ver_schedule
277: WHERE project_id = p_project_id
278: AND element_version_id = p_object_version_id
279: AND proj_element_id = p_object_id;
280:

Line 327: FROM pa_proj_elem_ver_schedule

323: IS
324: SELECT
325: pev_schedule_id
326: , record_version_number
327: FROM pa_proj_elem_ver_schedule
328: WHERE project_id = p_project_id
329: AND element_version_id = c_object_version_id;
330:
331: l_pev_schedule_id NUMBER;

Line 5147: -- 3922325 : Added pa_proj_elem_ver_schedule join to get scheduled_start_date

5143: l_msg_index_out NUMBER;
5144: l_error_msg_code VARCHAR2(250);
5145: l_structure_version_id NUMBER;
5146:
5147: -- 3922325 : Added pa_proj_elem_ver_schedule join to get scheduled_start_date
5148: -- 4743866, modified the cursor below as join with ppc is not required in most of the cases
5149: CURSOR cur_tasks
5150: IS
5151: SELECT pobj.object_id_to1, ppev1.proj_element_id,

Line 5165: pa_proj_elem_ver_schedule sch

5161: SELECT to_number(null) object_id_from1, p_object_version_id object_id_to1
5162: FROM DUAL
5163: ) pobj,
5164: pa_proj_element_versions ppev1,
5165: pa_proj_elem_ver_schedule sch
5166: WHERE pobj.object_id_to1 = ppev1.element_version_id
5167: AND ppev1.element_version_id = sch.element_version_id;
5168:
5169: ---4743866, added following cursor on ppc to get required info

Line 6939: from pa_proj_elem_ver_schedule

6935: );
6936: cursor l_scheduled_dates_cur(p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER) is
6937: select scheduled_start_date
6938: ,scheduled_finish_date
6939: from pa_proj_elem_ver_schedule
6940: where project_id = p_project_id
6941: and proj_element_id = p_object_id
6942: and element_version_id = p_object_version_id;
6943:

Line 11326: from pa_proj_elem_ver_schedule

11322: ORDER BY published_date desc;
11323:
11324: CURSOR c_get_sch_dates(c_project_id NUMBER, c_object_version_id NUMBER) IS
11325: select scheduled_start_date, scheduled_finish_date
11326: from pa_proj_elem_ver_schedule
11327: where project_id = c_project_id
11328: and element_version_id = c_object_version_id ;
11329:
11330: CURSOR c_ptav_cur(c_project_id NUMBER, c_object_id NUMBER, c_task_id NUMBER, c_task_version_id NUMBER, c_structure_version_id NUMBER, c_ta_display_flag VARCHAR2) IS

Line 13723: pa_proj_elem_ver_schedule ppevs,

13719: ppevs.scheduled_start_date,
13720: ppevs.scheduled_finish_date
13721: from pa_proj_elements ppe,
13722: pa_proj_element_versions ppev,
13723: pa_proj_elem_ver_schedule ppevs,
13724: pa_task_types ptt
13725: where ppev.proj_element_id = l_obj
13726: and ppev.parent_structure_version_id = l_latest_wp_struct_ver_id
13727: and ppev.proj_element_id = ppe.proj_element_id

Line 20969: from pa_proj_elem_ver_schedule

20965: and trunc(ppr.as_of_date) <= trunc(c_as_of_date);
20966:
20967: CURSOR c_get_sch_dates(c_project_id NUMBER, c_task_id NUMBER, c_task_ver_id NUMBER) IS
20968: select pev_schedule_id, actual_start_date, actual_finish_date, estimated_start_date, estimated_finish_date
20969: from pa_proj_elem_ver_schedule
20970: where project_id = c_project_id
20971: and proj_element_id = c_task_id
20972: and element_version_id = c_task_ver_id
20973: ;

Line 21051: UPDATE pa_proj_elem_ver_schedule

21047: IF l_max_est_fin_date IS NOT NULL AND l_est_fin_date IS NOT NULL THEN
21048: l_estimated_finish_date_rollup := l_est_fin_date - l_max_est_fin_date;
21049: END IF;
21050:
21051: UPDATE pa_proj_elem_ver_schedule
21052: SET actual_start_date_rollup= l_actual_start_date_rollup
21053: , actual_finish_date_rollup = l_actual_finish_date_rollup
21054: , estimated_start_date_rollup = l_estimated_start_date_rollup
21055: , estimated_finish_date_rollup = l_estimated_finish_date_rollup