APPS.WIP_MASS_LOAD_PROCESSOR dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 13: from wip_job_schedule_interface

9: -- case: we want these rows deleted regardless of whether they
10: -- were processed correctly.
11: cursor old_requests is
12: select rowid, interface_id, header_id
13: from wip_job_schedule_interface
14: where
15: group_id = p_group_id and
16: ((process_phase = WIP_CONSTANTS.ML_COMPLETE and
17: process_status = WIP_CONSTANTS.ML_COMPLETE))

Line 31: delete from wip_job_schedule_interface

27: delete from wip_job_dtls_interface
28: where group_id = p_group_id
29: and parent_header_id = old_request.header_id;
30:
31: delete from wip_job_schedule_interface
32: where rowid = old_request.rowid ;
33:
34: end loop ;
35:

Line 116: UPDATE WIP_JOB_SCHEDULE_INTERFACE

112: err_num NUMBER;
113: error_text varchar2(500);
114: BEGIN
115:
116: UPDATE WIP_JOB_SCHEDULE_INTERFACE
117: SET PROCESS_STATUS = WIP_CONSTANTS.ERROR
118: WHERE GROUP_ID = P_Group_Id
119: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;
120:

Line 137: FROM WIP_JOB_SCHEDULE_INTERFACE

133: SELECT interface_id, 1,
134: Error_Text, sysdate, sysdate,
135: created_by, last_update_login,
136: last_updated_by
137: FROM WIP_JOB_SCHEDULE_INTERFACE
138: WHERE GROUP_ID = P_Group_Id
139: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;
140:
141: END Raise_Sql_Error;