[Home] [Help]
762:
763:
764: --------------------------------------------------
765: -- This procedure updates the Current Line Operation
766: -- in the Wip_Flow_Schedules for a particular
767: -- flow schedule.
768: --------------------------------------------------
769: PROCEDURE Update_Line_Operation (
770: p_line_operation IN NUMBER,
773: IS
774:
775: BEGIN
776:
777: Update Wip_Flow_Schedules
778: SET current_Line_Operation = p_line_operation
779: WHERE
780: Wip_Entity_Id = p_wip_entity_id
781: AND Organization_Id = p_organization_id ;
940: sysdate,
941: x_userid,
942: x_appl_id
943: from
944: wip_flow_schedules wfs
945: where
946: wfs.line_id = p_line_id
947: and trunc(wip_sfcb_utilities.sdate_to_cdate(wfs.scheduled_completion_date))
948: between p_date_from and x_date_to
1378: FROM
1379: wip_lines wl,
1380: bom_operation_sequences_v bos,
1381: bom_operational_routings bor,
1382: wip_flow_schedules wfs
1383: WHERE
1384: wfs.scheduled_flag = 1
1385: and bor.organization_id = wfs.organization_id
1386: and bor.assembly_item_id = wfs.primary_item_id
1699:
1700: 2. In this case, the fraction returned should still be 1,
1701: eventhough the scheduled_start_date is less than the
1702: p_date_from, because the completed quantities are handled
1703: by the quantity_completed column in the wip_flow_schedules
1704:
1705: 3. For this case, the fraction returned is actually =
1706:
1707: Number of calendar working days for the resource
1719: between p_date_from and sch_end
1720:
1721: As the fraction of the schedule before the p_date_from
1722: is actually handled by quantity_completed column in the
1723: wip_flow_schedules
1724:
1725:
1726: *********************************************************************/
1727: