[Home] [Help]
22: ----------------------------------------------------------------------
23: tax_line_number varchar2(1),
24: set_of_books_id po_distributions_all.set_of_books_id%TYPE,
25: request_id po_headers_all.request_id%TYPE,
26: trx_number ap_invoices_all.invoice_num%TYPE,
27: previous_trx_header_id number(15),
28: trx_date po_headers_all.last_update_date%TYPE,
29: trx_currency_code po_headers_all.currency_code%TYPE,
30: exchange_rate po_headers_all.rate%TYPE,
206:
207: /* Function called by view JG_AP_TAX_LINES_SUMMARY_V to provide multiple tax inclusive calculation solution. */
208: FUNCTION sum_tax_group_rate
209: (p_tax_group_id IN ar_tax_group_codes_all.tax_group_id%TYPE,
210: p_trx_date IN ap_invoices_all.invoice_date%TYPE,
211: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE
212: )
213: return NUMBER;
214:
217: (p_offset_tax_flag IN ap_supplier_sites_all.offset_tax_flag%TYPE,
218: p_amount_includes_tax_flag IN ap_invoice_distributions_all.amount_includes_tax_flag%TYPE,
219: p_tax_rate IN ap_tax_codes_all.tax_rate%TYPE,
220: p_offset_tax_code_id IN ap_tax_codes_all.offset_tax_code_id%TYPE,
221: p_trx_date IN ap_invoices_all.invoice_date%TYPE)
222: return NUMBER;
223:
224: /* Function called by the tax view to get orginal amount (replace aid.amount) */
225: FUNCTION get_amount( p_invoice_distribution_id NUMBER,