APPS.AHL_WIP_JOB_PVT dependencies on WIP_INTERFACE_ERRORS

Line 27: FROM wip_interface_errors

23: AND interface_id IS NOT NULL;
24:
25: CURSOR get_error_msg(c_interface_id NUMBER) IS
26: SELECT error
27: FROM wip_interface_errors
28: WHERE error_type = 1
29: AND interface_id = c_interface_id;
30:
31: CURSOR get_wip_entity(c_wip_entity_name VARCHAR2, c_organization_id NUMBER) IS

Line 1076: DELETE FROM wip_interface_errors

1072:
1073: --No deletion for the failed records in debug mode.
1074: IF fnd_profile.value('MRP_DEBUG') <> 'Y' THEN
1075: FOR i IN l_interface_ids.FIRST..l_interface_ids.LAST LOOP
1076: DELETE FROM wip_interface_errors
1077: WHERE interface_id = l_interface_ids(i);
1078: END LOOP;
1079:
1080: DELETE FROM wip_job_dtls_interface

Line 1834: DELETE FROM wip_interface_errors

1830:
1831: --Keep the failed records in interface tables in debug mode
1832: IF fnd_profile.value('MRP_DEBUG') <> 'Y' THEN
1833: FOR j IN l_interface_ids.FIRST..l_interface_ids.LAST LOOP
1834: DELETE FROM wip_interface_errors
1835: WHERE interface_id = l_interface_ids(j);
1836: END LOOP;
1837:
1838: DELETE FROM wip_job_dtls_interface