DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on AP_UNSELECTED_INVOICES_ALL

Line 449: delete from ap_unselected_invoices_all

445:
446: l_current_calling_sequence := p_calling_sequence || '<- remove_all_invoices';
447: l_debug_info := 'delete unselected invoices';
448:
449: delete from ap_unselected_invoices_all
450: where checkrun_id = p_checkrun_id;
451:
452:
453: l_debug_info := 'deleted selected invoices';

Line 532: insert into ap_unselected_invoices_all(

528:
529: if l_remove_invoices.count > 0 then
530: for i in l_remove_invoices.first .. l_remove_invoices.last loop
531:
532: insert into ap_unselected_invoices_all(
533: checkrun_id,
534: invoice_id,
535: payment_num,
536: dont_pay_reason_code,

Line 722: insert into ap_unselected_invoices_all(

718:
719: --Needs Invoice Validation
720: if l_invoice_status in ('NEVER APPROVED', 'UNAPPROVED') then
721:
722: insert into ap_unselected_invoices_all(
723: checkrun_id,
724: invoice_id,
725: payment_num,
726: dont_pay_reason_code,

Line 4610: delete from ap_unselected_invoices_all

4606:
4607:
4608: l_debug_info := 'delete unselected invoices';
4609:
4610: delete from ap_unselected_invoices_all
4611: where checkrun_id = p_checkrun_id;
4612:
4613: l_debug_info := 'undo awt';
4614: