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_UTILS_PKG dependencies on AP_INVOICES_ALL

Line 142: Removed the count(distinct(org_id) from ap_invoices_all

138:
139: BEGIN
140:
141: /* Bug 4928860. Added by Lakshmi Gopalsami
142: Removed the count(distinct(org_id) from ap_invoices_all
143: and added the cursor on fnd_product_groups to find out whether
144: multi-org is enabled or not.
145: */
146: OPEN multi_org_installed;

Line 452: Removed the count(distinct(org_id) from ap_invoices_all

448:
449: -------------------------------------------------------------------------------------------------------------------*/
450:
451: /* Bug 4928860. Added by Lakshmi Gopalsami
452: Removed the count(distinct(org_id) from ap_invoices_all
453: and added the cursor on fnd_product_groups to find out whether
454: multi-org is enabled or not.
455: */
456:

Line 916: select legal_entity_id from ap_invoices_all

912: /* ends additions by ssumaith - bug# 4448789*/
913:
914: /*Added below cursor by mmurtuza for bug 13423031*/
915: cursor cur_get_base_legal_entity_id is
916: select legal_entity_id from ap_invoices_all
917: WHERE invoice_id = p_attribute1;
918:
919:
920:

Line 1542: FROM ap_invoices_all

1538:
1539: -- iSupplier porting
1540: CURSOR c_inv(inv_id NUMBER) IS
1541: SELECT source
1542: FROM ap_invoices_all
1543: WHERE invoice_id = inv_id;
1544: -- iSupplier porting
1545:
1546:

Line 1550: v_source ap_invoices_all.source%type; --iSuppleir porting

1546:
1547: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;
1548: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1549: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1550: v_source ap_invoices_all.source%type; --iSuppleir porting
1551:
1552: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1553: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1554: v_receipt_uom rcv_transactions.unit_of_measure%type;

Line 1844: from ap_invoices_all.

1840: PLA/BOE invoices should error out. While polling the status of teh parent request there
1841: should be a delay of 60 seconds between polling.
1842:
1843: Also added exception handling to the main procedure and to the sql that fetches
1844: from ap_invoices_all.
1845:
1846: Since the procedure was revamped with the new approach, deleted the old code.
1847: --------------------------------------------------------------------------------------------------------------------*/
1848: Begin

Line 1885: from ap_invoices_all

1881: begin
1882:
1883: Select invoice_id
1884: into v_invoice_id
1885: from ap_invoices_all
1886: Where invoice_num = p_boe_id
1887: And vendor_id = p_vendor_id;
1888:
1889: result := Fnd_request.set_mode(TRUE);

Line 2358: FROM ap_invoices_all a,

2354:
2355: CURSOR c_batch_name(cp_invoice_id NUMBER)
2356: IS
2357: SELECT b.batch_name
2358: FROM ap_invoices_all a,
2359: ap_batches_all b
2360: WHERE a.batch_id = b.batch_id
2361: AND a.invoice_id = cp_invoice_id;
2362:

Line 2464: from ap_invoices_all

2460:
2461: Begin
2462: Select invoice_currency_code
2463: into lv_inv_curr_code
2464: from ap_invoices_all
2465: where invoice_id = p_invoice_id;
2466:
2467: Exception
2468: When others then

Line 2937: , 'AP_INVOICES_ALL' -- 'AP_INVOICES_ALL'

2933: , pv_reference1
2934: , 'India Localization Entry for accounting inclusive taxes for invoice'||pv_reference10
2935: , 'India Localization Entry' -- 'India Localization Entry'
2936: , pv_reference23
2937: , 'AP_INVOICES_ALL' -- 'AP_INVOICES_ALL'
2938: , 'INVOICE_ID' -- 'INVOICE_ID'
2939: , pv_reference26
2940: , pv_reference27
2941: );

Line 2977: ln_org_id ap_invoices_all.org_id%TYPE;

2973: , xv_process_flag OUT NOCOPY VARCHAR2
2974: , xv_process_message OUT NOCOPY VARCHAR2
2975: )
2976: IS
2977: ln_org_id ap_invoices_all.org_id%TYPE;
2978: ld_gl_date ap_invoices_all.gl_date%TYPE;
2979: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;

Line 2978: ld_gl_date ap_invoices_all.gl_date%TYPE;

2974: , xv_process_message OUT NOCOPY VARCHAR2
2975: )
2976: IS
2977: ln_org_id ap_invoices_all.org_id%TYPE;
2978: ld_gl_date ap_invoices_all.gl_date%TYPE;
2979: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;

Line 2979: lv_invoice_num ap_invoices_all.invoice_num%TYPE;

2975: )
2976: IS
2977: ln_org_id ap_invoices_all.org_id%TYPE;
2978: ld_gl_date ap_invoices_all.gl_date%TYPE;
2979: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;

Line 2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;

2976: IS
2977: ln_org_id ap_invoices_all.org_id%TYPE;
2978: ld_gl_date ap_invoices_all.gl_date%TYPE;
2979: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;

Line 2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;

2977: ln_org_id ap_invoices_all.org_id%TYPE;
2978: ld_gl_date ap_invoices_all.gl_date%TYPE;
2979: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2985:

Line 2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;

2978: ld_gl_date ap_invoices_all.gl_date%TYPE;
2979: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2985:
2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;

Line 2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;

2979: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2985:
2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;

Line 2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;

2980: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2981: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2982: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2983: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2984: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2985:
2986: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2987: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2988: lv_match_type ap_invoice_lines_all.match_type%TYPE;

Line 3097: ap_invoices_all

3093: , ln_exchange_rate
3094: , lv_exchange_rate_type
3095: , ld_exchange_date
3096: FROM
3097: ap_invoices_all
3098: WHERE invoice_id = pn_invoice_id;
3099:
3100: -- Check whether inclusive taxes needs to be accounted separately
3101: BEGIN