APPS.WIP_DISCRETEJOB_UTIL dependencies on WIP_DISCRETE_JOBS

Line 1173: UPDATE WIP_DISCRETE_JOBS

1169: )
1170: IS
1171: BEGIN
1172:
1173: UPDATE WIP_DISCRETE_JOBS
1174: SET ALTERNATE_BOM_DESIGNATOR = p_DiscreteJob_rec.alternate_bom_designator
1175: , ALTERNATE_ROUTING_DESIGNATOR = p_DiscreteJob_rec.alternate_rout_designator
1176: , ATTRIBUTE1 = p_DiscreteJob_rec.attribute1
1177: , ATTRIBUTE10 = p_DiscreteJob_rec.attribute10

Line 1281: INSERT INTO WIP_DISCRETE_JOBS

1277: )
1278: IS
1279: BEGIN
1280:
1281: INSERT INTO WIP_DISCRETE_JOBS
1282: ( ALTERNATE_BOM_DESIGNATOR
1283: , ALTERNATE_ROUTING_DESIGNATOR
1284: , ATTRIBUTE1
1285: , ATTRIBUTE10

Line 1470: DELETE FROM WIP_DISCRETE_JOBS

1466: )
1467: IS
1468: BEGIN
1469:
1470: DELETE FROM WIP_DISCRETE_JOBS
1471: WHERE WIP_ENTITY_ID = p_wip_entity_id
1472: ;
1473:
1474: EXCEPTION

Line 1597: FROM WIP_DISCRETE_JOBS

1593: , STD_COST_ADJUSTMENT_ACCOUNT
1594: , TASK_ID
1595: , WIP_ENTITY_ID
1596: , WIP_SUPPLY_TYPE
1597: FROM WIP_DISCRETE_JOBS
1598: WHERE ( WIP_ENTITY_ID = p_wip_entity_id
1599: );
1600:
1601: BEGIN

Line 1902: FROM WIP_DISCRETE_JOBS

1898: , l_DiscreteJob_rec.std_cost_adj_account
1899: , l_DiscreteJob_rec.task_id
1900: , l_DiscreteJob_rec.wip_entity_id
1901: , l_DiscreteJob_rec.wip_supply_type
1902: FROM WIP_DISCRETE_JOBS
1903: WHERE WIP_ENTITY_ID = p_DiscreteJob_rec.wip_entity_id
1904: FOR UPDATE NOWAIT;
1905:
1906: -- Row locked. Compare IN attributes to DB attributes.

Line 2359: FROM WIP_DISCRETE_JOBS

2355: x_err_msg OUT NOCOPY VARCHAR2,
2356: x_return_status OUT NOCOPY VARCHAR2) IS
2357: CURSOR c_build_seq IS
2358: SELECT 1
2359: FROM WIP_DISCRETE_JOBS
2360: WHERE SCHEDULE_GROUP_ID = p_schedule_group_id
2361: AND BUILD_SEQUENCE = p_build_sequence
2362: AND WIP_ENTITY_ID <> NVL(p_wip_entity_id, -1);
2363:

Line 2415: update wip_discrete_jobs

2411:
2412: close c_build_seq;
2413: end if;
2414:
2415: update wip_discrete_jobs
2416: set due_date = p_due_date,
2417: line_id = p_line_id,
2418: schedule_group_id = p_schedule_group_id,
2419: build_sequence = p_build_sequence,