20: BEGIN
21:
22: for old_request in old_requests loop
23:
24: delete from wip_interface_errors
25: where interface_id = old_request.interface_id ;
26:
27: delete from wip_job_dtls_interface
28: where group_id = p_group_id
120:
121: err_num := SQLCODE;
122: error_text := SUBSTR(SQLERRM, 1, 500);
123:
124: INSERT INTO WIP_INTERFACE_ERRORS(
125: interface_id,
126: error_type,
127: error,
128: last_update_date,