[Home] [Help]
2574: x_return_status OUT NOCOPY VARCHAR2)
2575: IS
2576: l_vendor_name po_vendors.vendor_name%TYPE;
2577: l_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;
2578: l_check_id ap_checks.check_id%TYPE;
2579: l_old_invoice ap_invoices.invoice_id%TYPE;
2580: amt_remaining ap_payment_schedules.amount_remaining%TYPE;
2581: l_bank_num ce_banks_v.bank_number%TYPE;
2582: l_return_status VARCHAR2(1);
2586:
2587: TYPE vendor_type IS TABLE OF po_vendors.vendor_id%TYPE INDEX BY BINARY_INTEGER;
2588: TYPE vendor_site_type IS TABLE OF po_vendor_sites_all.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
2589: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
2590: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
2591: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
2592: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;
2593: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;
2594:
2602: party_list party_type;
2603: party_site_list party_site_type;
2604:
2605: ap_payment_info_tab AP_PAYMENT_PUBLIC_PKG.Invoice_Payment_Info_Tab;
2606: ap_check_rec ap_checks_all%ROWTYPE;
2607: p_schd_tab pymt_sch_tab;
2608:
2609: BEGIN
2610:
2676:
2677:
2678: /* Get Check Number from Sequence */
2679:
2680: SELECT fun.fun_net_ap_checks_s.nextval
2681: INTO ap_check_rec.check_number
2682: FROM DUAL;
2683:
2684: ap_check_rec.CHECK_DATE := g_batch_details.settlement_date;