[Home] [Help]
3254: p_le_id IN xle_entity_profiles.legal_entity_id%TYPE,
3255: p_bank_num IN ce_banks_v.bank_number%TYPE,
3256: x_return_status OUT NOCOPY VARCHAR2)
3257: IS
3258: l_vendor_name po_vendors.vendor_name%TYPE;
3259: l_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;
3260: l_check_id ap_checks.check_id%TYPE;
3261: l_old_invoice ap_invoices.invoice_id%TYPE;
3262: amt_remaining ap_payment_schedules.amount_remaining%TYPE;
3267: l_return_status VARCHAR2(1);
3268: m integer;
3269: l_path VARCHAR2(100);
3270: l_gl_date date; -- Bug: 7639863
3271: TYPE vendor_type IS TABLE OF po_vendors.vendor_id%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE vendor_site_type IS TABLE OF po_vendor_sites_all.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
3328: FOR i IN 1..vendor_list.count
3329: LOOP
3330: fun_net_util.Log_String(g_event_level,l_path,'vendor_id'|| vendor_list(i));
3331: /* Get Vendor Name and Vendor Site Name */
3332: ap_check_rec.VENDOR_NAME := PO_VENDORS_SV.get_vendor_name_func(
3333: vendor_list(i));
3334: fun_net_util.Log_String(g_event_level,l_path,'vendor_site_id'||vendor_site_list(i));
3335: PO_VENDOR_SITES_SV.get_vendor_site_name(
3336: vendor_site_list(i),