APPS.WIP_DISCRETE_JOB_PROCESSOR dependencies on WIP_DISCRETE_JOBS

Line 44: FROM wip_discrete_jobs

40: WHERE header_id = p_header_id;--rowid = l_wlcRec.rowid;
41:
42: SELECT start_quantity - quantity_completed - quantity_scrapped, rowid
43: INTO l_rem_qty, l_rowid
44: FROM wip_discrete_jobs
45: WHERE organization_id = l_wlcRec.organization_id
46: AND wip_entity_id = l_wlcRec.wip_entity_id
47: FOR UPDATE OF quantity_completed;
48:

Line 90: UPDATE wip_discrete_jobs

86: raise FND_API.G_EXC_UNEXPECTED_ERROR;
87: end if;
88:
89: if(round(l_wlcRec.primary_quantity, 6) = l_rem_qty) then --txn completes the job
90: UPDATE wip_discrete_jobs
91: SET quantity_completed = quantity_completed +
92: ROUND(l_wlcRec.primary_quantity,6),
93: date_completed = l_wlcRec.transaction_date,
94: status_type = 4,

Line 102: UPDATE wip_discrete_jobs

98: program_id = l_wlcRec.program_id,
99: program_update_date = l_wlcRec.program_update_date
100: WHERE rowid = l_rowid;
101: else --txn doesn't complete the job
102: UPDATE wip_discrete_jobs
103: SET quantity_completed = quantity_completed +
104: ROUND(l_wlcRec.primary_quantity,6),
105: last_updated_by = l_wlcRec.last_updated_by,
106: last_update_date = sysdate,