DBA Data[Home] [Help]

APPS.WIP_OPERATION_DEFAULT dependencies on WIP_JOB_DTLS_INTERFACE

Line 28: FROM WIP_JOB_DTLS_INTERFACE

24: attribute_category, attribute1, attribute2, attribute3,
25: attribute4, attribute5,
26: attribute6, attribute7, attribute8, attribute9, attribute10,
27: attribute11, attribute12, attribute13, attribute14, attribute15
28: FROM WIP_JOB_DTLS_INTERFACE
29: WHERE group_id = p_group_id
30: AND process_phase = WIP_CONSTANTS.ML_VALIDATION
31: AND process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
32: AND wip_entity_id = p_wip_entity_id

Line 180: /******* UPDATE THE WIP_JOB_DTLS_INTERFACE TABLE *************/

176: x_err_code := SQLCODE;
177: return;
178: end;
179:
180: /******* UPDATE THE WIP_JOB_DTLS_INTERFACE TABLE *************/
181:
182: UPDATE WIP_JOB_DTLS_INTERFACE
183: SET
184: department_id = decode(p_department_id,

Line 182: UPDATE WIP_JOB_DTLS_INTERFACE

178: end;
179:
180: /******* UPDATE THE WIP_JOB_DTLS_INTERFACE TABLE *************/
181:
182: UPDATE WIP_JOB_DTLS_INTERFACE
183: SET
184: department_id = decode(p_department_id,
185: NULL, l_department_id, p_department_id),
186: minimum_transfer_quantity = decode(p_min_xfer_qty,