140: FROM WIP_SCHED_RELATIONSHIPS WSR
141: WHERE WSR.RELATIONSHIP_TYPE = 1
142: CONNECT BY prior WSR.CHILD_OBJECT_ID = WSR.PARENT_OBJECT_ID
143: START WITH WSR.PARENT_OBJECT_ID = l_obj_id) WSR1,
144: WIP_DISCRETE_JOBS WDJ
145: WHERE l_obj_type_id = 1
146: AND WSR1.CHILD_OBJECT_ID = WDJ.WIP_ENTITY_ID
147: AND ( WDJ.firm_planned_flag = l_cur_non_firm_flag OR WDJ.firm_planned_flag = l_cur_firm_flag)
148: AND WDJ.status_type NOT IN (7,4,5,12,14)
156: WDJ.requested_start_date,
157: WDJ.due_date,
158: 0 WO_LEVEL,
159: WDJ.FIRM_PLANNED_FLAG
160: FROM WIP_DISCRETE_JOBS WDJ
161: WHERE WDJ.WIP_ENTITY_ID = l_obj_id
162: AND l_obj_type_id = 1
163: AND WDJ.status_type NOT IN (7,4,5,12,14)
164: ) ORDER BY 8 DESC ;
206: woru.resource_seq_num,
207: woru.instance_id,
208: woru.serial_number,
209: woru.assigned_units
210: FROM wip_operation_resource_usage woru, wip_discrete_jobs wdj
211: WHERE woru.wip_entity_id = l_obj_id
212: AND wdj.wip_entity_id = l_obj_id
213: -- AND wdj.firm_planned_flag = l_cur_firm_flag
214: AND l_obj_type_id = 1;
272: l_completion_date := p_completion_date;
273:
274: select scheduled_start_date, scheduled_completion_date
275: into l_wo_start_date, l_wo_completion_date
276: from wip_discrete_jobs where
277: wip_entity_id = p_work_object_id;
278:
279: if l_offset_days is null then
280: if l_start_date is not null then
648: INTO l_job_status,
649: l_organization_id,
650: l_scheduled_start_date,
651: l_scheduled_completion_date
652: FROM WIP_DISCRETE_JOBS WDJ
653: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
654: AND l_work_object_type_id = 1;
655: EXCEPTION
656: WHEN OTHERS THEN
673:
674: BEGIN
675:
676: /* Update the job start and Enc Dates */
677: UPDATE WIP_DISCRETE_JOBS WDJ
678: SET WDJ.SCHEDULED_START_DATE = WDJ.SCHEDULED_START_DATE + l_offset_days,
679: WDJ.SCHEDULED_COMPLETION_DATE = WDJ.SCHEDULED_COMPLETION_DATE + l_offset_days
680: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
681: AND l_work_object_type_id = 1;
827: INTO l_job_status,
828: l_organization_id,
829: l_scheduled_start_date,
830: l_scheduled_completion_date
831: FROM WIP_DISCRETE_JOBS WDJ
832: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
833: AND l_work_object_type_id = 1;
834: EXCEPTION
835: WHEN OTHERS THEN