APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_INTERFACE_REJECTIONS

Line 547: Delete from fun_interface_rejections ftr

543: Print('Main Package ~~~'||'Deleting any Rejections from previous failed imports');
544:
545: -- Bug: 7595873
546: /* Delete any rejections from previous failed imports*/
547: Delete from fun_interface_rejections ftr
548: where ftr.batch_id in(select ftb.batch_id
549: from fun_interface_batches ftb
550: where ftb.source = p_source
551: and ftb.group_id = p_group_id);

Line 1074: from fun_interface_rejections ftr

1070: and import_status_code = 'A';
1071:
1072: -- Bug: 7595873
1073: select count(*) into l_count
1074: from fun_interface_rejections ftr
1075: where ftr.batch_id in(select ftb.batch_id
1076: from fun_interface_batches ftb
1077: where ftb.source = p_source
1078: and ftb.group_id = p_group_id);

Line 1113: DELETE FROM fun_interface_rejections

1109: DELETE FROM fun_interface_batches
1110: WHERE batch_id = p_batch_id
1111: AND import_status_code = 'R';
1112:
1113: DELETE FROM fun_interface_rejections
1114: where batch_id=p_batch_id;
1115:
1116: EXCEPTION
1117: