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 130: Removed the count(distinct(org_id) from ap_invoices_all

126:
127: BEGIN
128:
129: /* Bug 4928860. Added by Lakshmi Gopalsami
130: Removed the count(distinct(org_id) from ap_invoices_all
131: and added the cursor on fnd_product_groups to find out whether
132: multi-org is enabled or not.
133: */
134: OPEN multi_org_installed;

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

406:
407: -------------------------------------------------------------------------------------------------------------------*/
408:
409: /* Bug 4928860. Added by Lakshmi Gopalsami
410: Removed the count(distinct(org_id) from ap_invoices_all
411: and added the cursor on fnd_product_groups to find out whether
412: multi-org is enabled or not.
413: */
414:

Line 1320: FROM ap_invoices_all

1316:
1317: -- iSupplier porting
1318: CURSOR c_inv(inv_id NUMBER) IS
1319: SELECT source
1320: FROM ap_invoices_all
1321: WHERE invoice_id = inv_id;
1322: -- iSupplier porting
1323:
1324:

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

1324:
1325: v_invoice_quantity ap_invoice_distributions_all.quantity_invoiced%type;
1326: v_invoice_price ap_invoice_distributions_all.unit_price%type;
1327: v_invoice_id ap_invoice_distributions_all.invoice_id%type; --iSuppleir porting
1328: v_source ap_invoices_all.source%type; --iSuppleir porting
1329:
1330: v_po_uom rcv_transactions.source_doc_unit_of_measure%type;
1331: v_receipt_price rcv_transactions.po_unit_price%type ; /*Bug 4990941 bduvarag*/
1332: v_receipt_uom rcv_transactions.unit_of_measure%type;

Line 1622: from ap_invoices_all.

1618: PLA/BOE invoices should error out. While polling the status of teh parent request there
1619: should be a delay of 60 seconds between polling.
1620:
1621: Also added exception handling to the main procedure and to the sql that fetches
1622: from ap_invoices_all.
1623:
1624: Since the procedure was revamped with the new approach, deleted the old code.
1625: --------------------------------------------------------------------------------------------------------------------*/
1626: Begin

Line 1663: from ap_invoices_all

1659: begin
1660:
1661: Select invoice_id
1662: into v_invoice_id
1663: from ap_invoices_all
1664: Where invoice_num = p_boe_id
1665: And vendor_id = p_vendor_id;
1666:
1667: result := Fnd_request.set_mode(TRUE);

Line 2134: FROM ap_invoices_all a,

2130:
2131: CURSOR c_batch_name(cp_invoice_id NUMBER)
2132: IS
2133: SELECT b.batch_name
2134: FROM ap_invoices_all a,
2135: ap_batches_all b
2136: WHERE a.batch_id = b.batch_id
2137: AND a.invoice_id = cp_invoice_id;
2138:

Line 2240: from ap_invoices_all

2236:
2237: Begin
2238: Select invoice_currency_code
2239: into lv_inv_curr_code
2240: from ap_invoices_all
2241: where invoice_id = p_invoice_id;
2242:
2243: Exception
2244: When others then

Line 2712: , 'AP_INVOICES_ALL' -- 'AP_INVOICES_ALL'

2708: , pv_reference1
2709: , 'India Localization Entry for accounting inclusive taxes for invoice'||pv_reference10
2710: , 'India Localization Entry' -- 'India Localization Entry'
2711: , pv_reference23
2712: , 'AP_INVOICES_ALL' -- 'AP_INVOICES_ALL'
2713: , 'INVOICE_ID' -- 'INVOICE_ID'
2714: , pv_reference26
2715: , pv_reference27
2716: );

Line 2752: ln_org_id ap_invoices_all.org_id%TYPE;

2748: , xv_process_flag OUT NOCOPY VARCHAR2
2749: , xv_process_message OUT NOCOPY VARCHAR2
2750: )
2751: IS
2752: ln_org_id ap_invoices_all.org_id%TYPE;
2753: ld_gl_date ap_invoices_all.gl_date%TYPE;
2754: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;

Line 2753: ld_gl_date ap_invoices_all.gl_date%TYPE;

2749: , xv_process_message OUT NOCOPY VARCHAR2
2750: )
2751: IS
2752: ln_org_id ap_invoices_all.org_id%TYPE;
2753: ld_gl_date ap_invoices_all.gl_date%TYPE;
2754: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;

Line 2754: lv_invoice_num ap_invoices_all.invoice_num%TYPE;

2750: )
2751: IS
2752: ln_org_id ap_invoices_all.org_id%TYPE;
2753: ld_gl_date ap_invoices_all.gl_date%TYPE;
2754: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;

Line 2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;

2751: IS
2752: ln_org_id ap_invoices_all.org_id%TYPE;
2753: ld_gl_date ap_invoices_all.gl_date%TYPE;
2754: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;

Line 2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;

2752: ln_org_id ap_invoices_all.org_id%TYPE;
2753: ld_gl_date ap_invoices_all.gl_date%TYPE;
2754: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2760:

Line 2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;

2753: ld_gl_date ap_invoices_all.gl_date%TYPE;
2754: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2760:
2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;

Line 2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;

2754: lv_invoice_num ap_invoices_all.invoice_num%TYPE;
2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2760:
2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;

Line 2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;

2755: ld_invoice_date ap_invoices_all.invoice_date%TYPE;
2756: lv_invoice_currency_code ap_invoices_all.invoice_currency_code%TYPE;
2757: ln_exchange_rate ap_invoices_all.exchange_rate%TYPE;
2758: lv_exchange_rate_type ap_invoices_all.exchange_rate_type%TYPE;
2759: ld_exchange_date ap_invoices_all.exchange_date%TYPE;
2760:
2761: ln_inventory_item_id ap_invoice_lines_all.inventory_item_id %TYPE;
2762: ld_accounting_date ap_invoice_lines_all.accounting_date%TYPE;
2763: lv_match_type ap_invoice_lines_all.match_type%TYPE;

Line 2872: ap_invoices_all

2868: , ln_exchange_rate
2869: , lv_exchange_rate_type
2870: , ld_exchange_date
2871: FROM
2872: ap_invoices_all
2873: WHERE invoice_id = pn_invoice_id;
2874:
2875: -- Check whether inclusive taxes needs to be accounted separately
2876: BEGIN