APPS.AP_AUTOSELECT_PKG dependencies on AP_UNSELECTED_INVOICES_ALL

Line 646: delete from ap_unselected_invoices_all

642:
643: l_current_calling_sequence := p_calling_sequence || '<- remove_all_invoices';
644: l_debug_info := 'delete unselected invoices';
645:
646: delete from ap_unselected_invoices_all
647: where checkrun_id = p_checkrun_id;
648:
649:
650: l_debug_info := 'deleted selected invoices';

Line 729: insert into ap_unselected_invoices_all(

725:
726: if l_remove_invoices.count > 0 then
727: for i in l_remove_invoices.first .. l_remove_invoices.last loop
728:
729: insert into ap_unselected_invoices_all(
730: checkrun_id,
731: invoice_id,
732: payment_num,
733: dont_pay_reason_code,

Line 1113: insert into ap_unselected_invoices_all(

1109:
1110: --Needs Invoice Validation
1111: if l_invoice_status in ('NEVER APPROVED', 'UNAPPROVED') then
1112:
1113: insert into ap_unselected_invoices_all(
1114: checkrun_id,
1115: invoice_id,
1116: payment_num,
1117: dont_pay_reason_code,

Line 4954: FND_STATS.GATHER_TABLE_STATS(l_schema, 'AP_UNSELECTED_INVOICES_ALL'); /* Added for bug#10053374 */

4950: )
4951: THEN
4952: IF l_schema IS NOT NULL THEN
4953: FND_STATS.GATHER_TABLE_STATS(l_schema, 'AP_SELECTED_INVOICES_ALL');
4954: FND_STATS.GATHER_TABLE_STATS(l_schema, 'AP_UNSELECTED_INVOICES_ALL'); /* Added for bug#10053374 */
4955: END IF;
4956: END IF;
4957:
4958: /* BUG 14498596 END - Moved Withholding Tax logic before grouping of invoices */

Line 6207: delete from ap_unselected_invoices_all

6203:
6204:
6205: l_debug_info := 'delete unselected invoices';
6206:
6207: delete from ap_unselected_invoices_all
6208: where checkrun_id = p_checkrun_id;
6209:
6210: l_debug_info := 'undo awt';
6211: