eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_MATCH_TAX_PROC_PKG dependencies on AP_INVOICES_ALL

Line 324: lv_source ap_invoices_all.source%TYPE;

320: ln_lines_to_insert NUMBER;
321: ln_rec_tax_amt NUMBER;
322: ln_nrec_tax_amt NUMBER;
323: ln_inclurec_tax_amt NUMBER;
324: lv_source ap_invoices_all.source%TYPE;
325: ln_currency_precision NUMBER;
326: l_tax_rec l_tax_line_rec_type;
327: ln_rvs_liablity_acct NUMBER;
328: ln_incls_acct_id NUMBER;

Line 347: ap_invoices_all

343: WHERE apid.invoice_id = Pn_invoice_id
344: AND apid.invoice_line_number = pn_invoice_line_num);
345: CURSOR c_inv_source IS
346: SELECT SOURCE FROM
347: ap_invoices_all
348: WHERE invoice_id = pn_invoice_id;
349: l_api_name CONSTANT VARCHAR2(30) := 'copy_tax_from_po_rcv';
350: BEGIN
351:

Line 608: FROM ap_invoices_all

604: WHERE set_of_books_id = c_sob_id;
605:
606: CURSOR c_invoice_info IS
607: SELECT accts_pay_code_combination_id apccid,legal_entity_id, NVL(exchange_rate, 1) exchange_rate,invoice_currency_code
608: FROM ap_invoices_all
609: WHERE invoice_id = ln_invoice_id;
610:
611:
612: CURSOR c_po_item_info IS

Line 629: FROM ap_invoices_all api,

625: api.created_by,
626: api.last_update_date,
627: api.last_updated_by,
628: api.invoice_date
629: FROM ap_invoices_all api,
630: ap_invoice_distributions_all apd,
631: po_distributions_all pod,
632: po_headers_all poh
633: WHERE apd.invoice_id = api.invoice_id

Line 1465: UPDATE ap_invoices_all

1461: cum_tax_amt := cum_tax_amt + 1;
1462:
1463: v_update_payment_schedule:=update_payment_schedule(cum_tax_amt,ln_invoice_id,pn_currency_precision);
1464:
1465: UPDATE ap_invoices_all
1466: SET invoice_amount = invoice_amount + cum_tax_amt,
1467: approved_amount = approved_amount + cum_tax_amt,
1468: pay_curr_invoice_amount = pay_curr_invoice_amount + cum_tax_amt,
1469: amount_applicable_to_discount = amount_applicable_to_discount + cum_tax_amt,

Line 1475: update ap_invoices_all

1471: WHERE invoice_id = ln_invoice_id;
1472:
1473: if r_invoice_info.invoice_currency_code <> lv_functional_currency then
1474: -- invoice currency is not the functional currency.
1475: update ap_invoices_all
1476: set base_amount = invoice_amount * exchange_rate
1477: where invoice_id = ln_invoice_id;
1478: end if;
1479:

Line 1611: FROM ap_invoices_all

1607: WHERE tax_id = t_id;
1608:
1609: CURSOR for_org_id IS
1610: SELECT org_id, vendor_id, NVL(exchange_rate, 1) exchange_rate, invoice_currency_code,batch_id
1611: FROM ap_invoices_all
1612: WHERE invoice_id = pr_ap_inv_line_item.invoice_id;
1613:
1614: cursor c_get_excise_costing_flag (cp_rcv_transaction_id rcv_transactions.transaction_id%type,
1615: cp_organization_id JAI_RCV_TRANSACTIONS.organization_id%type,

Line 3059: SELECT SOURCE FROM ap_invoices_all WHERE invoice_id = pn_invoice_id;

3055: FROM ap_invoice_lines_all
3056: WHERE invoice_id = pn_invoice_id AND line_number = pn_invoice_line_num;
3057:
3058: CURSOR c_invoice_source IS
3059: SELECT SOURCE FROM ap_invoices_all WHERE invoice_id = pn_invoice_id;
3060:
3061: CURSOR vend_info IS
3062: SELECT vendor_id, vendor_site_id, invoice_type_lookup_code, cancelled_date
3063: FROM ap_invoices_all

Line 3063: FROM ap_invoices_all

3059: SELECT SOURCE FROM ap_invoices_all WHERE invoice_id = pn_invoice_id;
3060:
3061: CURSOR vend_info IS
3062: SELECT vendor_id, vendor_site_id, invoice_type_lookup_code, cancelled_date
3063: FROM ap_invoices_all
3064: WHERE invoice_id = pn_invoice_id;
3065:
3066: CURSOR fetch_rcv_record(v_rcv_trans_id NUMBER) IS
3067: SELECT po_header_id,po_line_id

Line 3082: FROM ap_invoices_all

3078: CURSOR fetch_recpt_num_cur IS
3079: SELECT SUBSTR(SUBSTR(invoice_num, INSTR(invoice_num, '-', 1, 1) + 1 ,
3080: (INSTR(invoice_num, '-', 1, 2)-1) - INSTR(invoice_num, '-', 1, 1)
3081: ),1,30), Source
3082: FROM ap_invoices_all
3083: WHERE invoice_id = pn_invoice_id;
3084:
3085: CURSOR count_receipts(p_pck_slip VARCHAR2, ven_id NUMBER, cpv_transaction_type VARCHAR2 ) IS
3086: SELECT DISTINCT rsh.receipt_num, rsh.shipment_header_id

Line 3133: v_source ap_invoices_all.SOURCE%TYPE;

3129: vend_info_rec vend_info%ROWTYPE;
3130: fetch_rcv_record_rec fetch_rcv_record%ROWTYPE;
3131: set_up_info_rec set_up_info%ROWTYPE;
3132: v_receipt_num RCV_SHIPMENT_HEADERS.RECEIPT_NUM%TYPE;
3133: v_source ap_invoices_all.SOURCE%TYPE;
3134:
3135: v_inv_org_id NUMBER;
3136: v_count_tax_dist NUMBER;
3137:

Line 3675: cursor c_get_source(cp_invoice_id ap_invoices_all.invoice_id%type) is

3671: where invoice_id = ln_invoice_id
3672: and po_distribution_id = ln_po_distribution_id
3673: and line_type_lookup_code = 'MISCELLANEOUS';
3674:
3675: cursor c_get_source(cp_invoice_id ap_invoices_all.invoice_id%type) is
3676: select source from ap_invoices_all where invoice_id = cp_invoice_id;
3677:
3678: ln_invoice_id ap_invoice_lines_all.invoice_id%type;
3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;

Line 3676: select source from ap_invoices_all where invoice_id = cp_invoice_id;

3672: and po_distribution_id = ln_po_distribution_id
3673: and line_type_lookup_code = 'MISCELLANEOUS';
3674:
3675: cursor c_get_source(cp_invoice_id ap_invoices_all.invoice_id%type) is
3676: select source from ap_invoices_all where invoice_id = cp_invoice_id;
3677:
3678: ln_invoice_id ap_invoice_lines_all.invoice_id%type;
3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;
3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;

Line 3682: lv_source ap_invoices_all.source%type;

3678: ln_invoice_id ap_invoice_lines_all.invoice_id%type;
3679: ln_po_dist_id ap_invoice_lines_all.po_distribution_id%type;
3680: lv_discard_flag ap_invoice_lines_all.discarded_flag%type;
3681: ln_line_number ap_invoice_lines_all.line_number%type;
3682: lv_source ap_invoices_all.source%type;
3683: lc_inv_dist ap_invoice_distributions_all%rowtype;
3684: ln_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
3685:
3686: BEGIN

Line 3925: from ap_invoices_all

3921: from ap_invoice_lines_all
3922: where invoice_id = cn_invoice_id;
3923: cursor c_invoice_type(cn_invoice_id number) is
3924: select invoice_type_lookup_code
3925: from ap_invoices_all
3926: where invoice_id = cn_invoice_id;
3927: cursor c_invoice_lines(cn_invoice_id number) is
3928: select * from ap_invoice_lines_all where invoice_id = cn_invoice_id;
3929:

Line 3932: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%type;

3928: select * from ap_invoice_lines_all where invoice_id = cn_invoice_id;
3929:
3930: lv_enable_menu varchar2(1);
3931: lv_count number;
3932: lv_invoice_type ap_invoices_all.invoice_type_lookup_code%type;
3933: lv_match_type varchar2(50);
3934: lv_receipt_code varchar2(50);
3935: ln_shipment_line_id NUMBER;
3936: ln_shipment_header_id NUMBER;