APPS.FLM_AUTO_REPLENISHMENT dependencies on WIP_FLOW_SCHEDULES

Line 620: UPDATE wip_flow_schedules

616: p_schedule_number IN VARCHAR2) IS
617:
618: BEGIN
619:
620: UPDATE wip_flow_schedules
621: SET auto_replenish = 'Y'
622: WHERE schedule_number = p_Schedule_Number;
623:
624: END Update_Flow_Schedule;

Line 812: FROM wip_flow_schedules flow,

808: flow.scheduled_start_date scheduled_start_date,
809: flow.scheduled_completion_date scheduled_completion_date,
810: flow.alternate_bom_designator alternate_bom_designator,
811: flow.alternate_routing_designator alternate_routing_designator
812: FROM wip_flow_schedules flow,
813: wip_lines lines
814: WHERE flow.planned_quantity - nvl(flow.quantity_completed, 0) > 0
815: AND flow.status <> 2
816: AND flow.scheduled_completion_date <= (l_server_compl_date + 1)

Line 927: FROM wip_flow_schedules

923: -- Lock the flow schedule for update of auto_replenish flag
924: BEGIN
925: SELECT auto_replenish
926: INTO l_auto_replenish
927: FROM wip_flow_schedules
928: WHERE schedule_number = l_schedule_number
929: FOR UPDATE OF auto_replenish NOWAIT;
930: EXCEPTION
931: WHEN OTHERS THEN

Line 940: FROM wip_flow_schedules

936: BEGIN
937: --before locking check the auto_replenish flag, this schedule may have been updated by other request
938: SELECT NVL(auto_replenish, 'N')
939: INTO l_auto_replenish
940: FROM wip_flow_schedules
941: WHERE schedule_number = l_schedule_number;
942:
943:
944: IF l_auto_replenish = 'Y' then

Line 1101: FROM wip_flow_schedules

1097:
1098: -- Replenish the Cards
1099: SELECT wip_entity_id
1100: INTO l_wip_entity_id
1101: FROM wip_flow_schedules
1102: WHERE schedule_number = l_comp_table(l_comp_count).schedule_number
1103: AND organization_id = p_organization_id;
1104:
1105: INV_Kanban_GRP.Update_Card_Supply_Status(