APPS.WIP_FLOWSCHEDULE_UTIL dependencies on WIP_FLOW_SCHEDULES

Line 867: UPDATE WIP_FLOW_SCHEDULES

863: )
864: IS
865: BEGIN
866:
867: UPDATE WIP_FLOW_SCHEDULES
868: SET ALTERNATE_BOM_DESIGNATOR = p_FlowSchedule_rec.alternate_bom_designator
869: , ALTERNATE_ROUTING_DESIGNATOR = p_FlowSchedule_rec.alternate_rout_designator
870: , ATTRIBUTE1 = p_FlowSchedule_rec.attribute1
871: , ATTRIBUTE10 = p_FlowSchedule_rec.attribute10

Line 963: INSERT INTO WIP_FLOW_SCHEDULES

959: )
960: IS
961: BEGIN
962:
963: INSERT INTO WIP_FLOW_SCHEDULES
964: ( ALTERNATE_BOM_DESIGNATOR
965: , ALTERNATE_ROUTING_DESIGNATOR
966: , ATTRIBUTE1
967: , ATTRIBUTE10

Line 1128: DELETE FROM WIP_FLOW_SCHEDULES

1124: )
1125: IS
1126: BEGIN
1127:
1128: DELETE FROM WIP_FLOW_SCHEDULES
1129: WHERE SCHEDULE_NUMBER = p_schedule_number
1130: ;
1131:
1132: EXCEPTION

Line 1258: FROM WIP_FLOW_SCHEDULES

1254: , STATUS
1255: , STD_COST_ADJUSTMENT_ACCOUNT
1256: , TASK_ID
1257: , WIP_ENTITY_ID
1258: FROM WIP_FLOW_SCHEDULES
1259: WHERE ( SCHEDULE_NUMBER = p_schedule_number
1260: )
1261: OR ( WIP_ENTITY_ID = p_wip_entity_id
1262: );

Line 1552: FROM WIP_FLOW_SCHEDULES

1548: , l_FlowSchedule_rec.status
1549: , l_FlowSchedule_rec.std_cost_adj_account
1550: , l_FlowSchedule_rec.task_id
1551: , l_FlowSchedule_rec.wip_entity_id
1552: FROM WIP_FLOW_SCHEDULES
1553: WHERE SCHEDULE_NUMBER = p_FlowSchedule_rec.schedule_number
1554: FOR UPDATE NOWAIT;
1555:
1556: -- Row locked. Compare IN attributes to DB attributes.