[Home] [Help]
247: l_derive_type_rcv_curr VARCHAR2(10); --Bug fix:1891850
248: l_derive_type_payment_curr VARCHAR2(10); --Bug fix:1891850
249: -- Bug fix : 1971188 - definition of variables
250: l_auto_tax_calc_flag_sys ap_system_parameters.auto_tax_calc_flag%TYPE;
251: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
252:
253: --Bug: 2902340
254: l_match_option po_line_locations.match_option%TYPE;
255: l_invoice_exists varchar2(1);
271: l_remit_party_id ap_invoices_all.party_id%TYPE;
272: l_remit_party_site_id ap_invoices_all.party_site_id%TYPE; --End 7758980
273:
274: -- Start 9267199
275: l_default_pay_site_id ap_supplier_sites.vendor_site_id%type;
276: l_valid_pay_site_flag VARCHAR2(1);
277: l_api_name CONSTANT VARCHAR2(200) := 'Create_DM';
278: --End 9267199
279:
545:
546: if (l_remit_to_supplier_site_id is not null) then
547: select party_site_id,vendor_site_code
548: into l_remit_party_site_id,l_remit_to_supplier_site
549: from ap_supplier_sites_all
550: where vendor_site_id = l_remit_to_supplier_site_id;
551: end if; --End 7758980
552:
553: -- Bug 8774769: Added back NVL condition which was part of bug 8345877
1013: p_auto_tax_calc_flag,
1014: p_party_id,
1015: p_party_site_id
1016: FROM po_vendors pv,
1017: ap_supplier_sites pvs
1018: WHERE pvs.vendor_site_id = p_vendor_site_id --l_default_pay_site_id modified for bug#9267199
1019: and pv.vendor_id = pvs.vendor_id;
1020:
1021: Exception
1202: l_inv_base_amt ap_invoices.base_amount%TYPE;
1203: l_invoice_id ap_invoices.invoice_id%TYPE;
1204: l_alter_pay_site_id NUMBER;
1205: --Modified for bug#9267199
1206: l_vendor_site_id ap_supplier_Sites.vendor_site_id%type := p_vendor_site_id;
1207: l_rts_txn_le_date DATE; --Bug 3492081
1208: curr_calling_sequence VARCHAR2(2000);
1209: debug_info VARCHAR2(2000);
1210: