APPS.AP_AUTOSELECT_PKG dependencies on AP_UNSELECTED_INVOICES

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 749: insert into ap_unselected_invoices(

745:
746: --Failed Invoice Validation
747: if l_invoice_status = 'NEEDS REAPPROVAL' then
748:
749: insert into ap_unselected_invoices(
750: checkrun_id,
751: invoice_id,
752: payment_num,
753: dont_pay_reason_code,

Line 777: insert into ap_unselected_invoices(

773: --Needs Approval
774: if l_approval_status in ('INITIATED','REQUIRED','NEEDS WFREAPPROVAL') then
775:
776:
777: insert into ap_unselected_invoices(
778: checkrun_id,
779: invoice_id,
780: payment_num,
781: dont_pay_reason_code,

Line 806: insert into ap_unselected_invoices(

802:
803: --Approver Rejected
804: if l_approval_status = 'REJECTED' then
805:
806: insert into ap_unselected_invoices(
807: checkrun_id,
808: invoice_id,
809: payment_num,
810: dont_pay_reason_code,

Line 831: insert into ap_unselected_invoices(

827:
828: --Scheduled Payment Hold
829: if l_ps_hold_flag = 'Y' then
830:
831: insert into ap_unselected_invoices(
832: checkrun_id,
833: invoice_id,
834: payment_num,
835: dont_pay_reason_code,

Line 858: insert into ap_unselected_invoices(

854:
855: --Supplier Site Hold
856: if l_hold_all_payments_flag = 'Y' then
857:
858: insert into ap_unselected_invoices(
859: checkrun_id,
860: invoice_id,
861: payment_num,
862: dont_pay_reason_code,

Line 883: insert into ap_unselected_invoices(

879:
880:
881: --Discount Rate Too Low
882: --4745133, can't call the ebd check in the cursor so doing it here.
883: insert into ap_unselected_invoices(
884: checkrun_id,
885: invoice_id,
886: payment_num,
887: 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: