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) or

Line 32: delete from wip_job_schedule_interface

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

Line 117: UPDATE WIP_JOB_SCHEDULE_INTERFACE

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

Line 138: FROM WIP_JOB_SCHEDULE_INTERFACE

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