APPS.WIP_REPSCHEDULE_UTIL dependencies on WIP_REPETITIVE_SCHEDULES

Line 771: UPDATE WIP_REPETITIVE_SCHEDULES

767: )
768: IS
769: BEGIN
770:
771: UPDATE WIP_REPETITIVE_SCHEDULES
772: SET ALTERNATE_BOM_DESIGNATOR = p_RepSchedule_rec.alternate_bom_designator
773: , ALTERNATE_ROUTING_DESIGNATOR = p_RepSchedule_rec.alternate_rout_designator
774: , ATTRIBUTE1 = p_RepSchedule_rec.attribute1
775: , ATTRIBUTE10 = p_RepSchedule_rec.attribute10

Line 858: INSERT INTO WIP_REPETITIVE_SCHEDULES

854: )
855: IS
856: BEGIN
857:
858: INSERT INTO WIP_REPETITIVE_SCHEDULES
859: ( ALTERNATE_BOM_DESIGNATOR
860: , ALTERNATE_ROUTING_DESIGNATOR
861: , ATTRIBUTE1
862: , ATTRIBUTE10

Line 1005: DELETE FROM WIP_REPETITIVE_SCHEDULES

1001: )
1002: IS
1003: BEGIN
1004:
1005: DELETE FROM WIP_REPETITIVE_SCHEDULES
1006: WHERE REPETITIVE_SCHEDULE_ID = p_repetitive_schedule_id
1007: ;
1008:
1009: EXCEPTION

Line 1125: FROM WIP_REPETITIVE_SCHEDULES

1121: , ROUTING_REVISION
1122: , ROUTING_REVISION_DATE
1123: , STATUS_TYPE
1124: , WIP_ENTITY_ID
1125: FROM WIP_REPETITIVE_SCHEDULES
1126: WHERE ( REPETITIVE_SCHEDULE_ID = nvl(p_repetitive_schedule_id,FND_API.G_MISS_NUM)
1127: )
1128: OR ( WIP_ENTITY_ID = nvl(p_wip_entity_id,FND_API.G_MISS_NUM)
1129: );

Line 1392: FROM WIP_REPETITIVE_SCHEDULES

1388: , l_RepSchedule_rec.routing_revision
1389: , l_RepSchedule_rec.routing_revision_date
1390: , l_RepSchedule_rec.status_type
1391: , l_RepSchedule_rec.wip_entity_id
1392: FROM WIP_REPETITIVE_SCHEDULES
1393: WHERE REPETITIVE_SCHEDULE_ID = p_RepSchedule_rec.repetitive_schedule_id
1394: FOR UPDATE NOWAIT;
1395:
1396: -- Row locked. Compare IN attributes to DB attributes.