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.AP_APPROVAL_PKG dependencies on AP_INVOICES_ALL

Line 606: FROM ap_invoices_all AI,

602: nvl(AI.disc_is_inv_less_tax_flag,'N'),
603: nvl(AI.exclude_freight_from_discount,'N'),
604: pvs.tolerance_id,
605: pvs.services_tolerance_id
606: FROM ap_invoices_all AI,
607: ap_suppliers PV,
608: ap_supplier_sites_all PVS
609: WHERE AI.invoice_id = p_invoice_id
610: AND AI.vendor_id = PV.vendor_id

Line 632: FROM ap_invoices_all AI

628: AI.invoice_date,
629: AI.org_id,
630: nvl(AI.disc_is_inv_less_tax_flag,'N'),
631: nvl(AI.exclude_freight_from_discount,'N')
632: FROM ap_invoices_all AI
633: WHERE AI.invoice_id = p_invoice_id;
634:
635: CURSOR invoice_type_cur IS
636: SELECT invoice_type_lookup_code

Line 637: FROM ap_invoices_all

633: WHERE AI.invoice_id = p_invoice_id;
634:
635: CURSOR invoice_type_cur IS
636: SELECT invoice_type_lookup_code
637: FROM ap_invoices_all
638: WHERE invoice_id = p_invoice_id;
639:
640: l_chart_of_accounts_id NUMBER;
641: l_recalc_pay_schedule_flag VARCHAR2(1);

Line 719: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;

715: Tax_Exception EXCEPTION;
716: Global_Exception EXCEPTION;
717: LCM_Exception EXCEPTION; --Bug 7718385
718: --Retropricing
719: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
720:
721: l_invoice_type_pr AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
722: l_exclude_tax_from_discount VARCHAR2(1);
723: l_exclude_freight_from_disc VARCHAR2(1);

Line 721: l_invoice_type_pr AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;

717: LCM_Exception EXCEPTION; --Bug 7718385
718: --Retropricing
719: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
720:
721: l_invoice_type_pr AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
722: l_exclude_tax_from_discount VARCHAR2(1);
723: l_exclude_freight_from_disc VARCHAR2(1);
724: l_cur_count NUMBER := 0;
725: l_prorate_across_all_items VARCHAR2(1);

Line 749: l_inv_header_rec ap_invoices_all%rowtype;

745: -- Bug 6648094
746: l_invoice_line_count NUMBER :=0; --Bug 6684139
747: l_encumbrance_exists NUMBER := 0; -- Bug 6681580
748:
749: l_inv_header_rec ap_invoices_all%rowtype;
750: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
751:
752: -- Project LCM 7588322
753: l_lcm_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

Line 1262: FROM ap_invoices_all

1258: l_curr_calling_sequence);
1259:
1260: SELECT invoice_type_lookup_code
1261: INTO l_invoice_type_lookup_code
1262: FROM ap_invoices_all
1263: WHERE invoice_id = l_invoice_id;
1264:
1265: IF ((l_exclude_tax_from_discount = 'Y' OR l_exclude_freight_from_disc = 'Y')
1266: OR (l_invoice_type_lookup_code IN ('PO PRICE ADJUST','ADJUSTMENT'))) THEN

Line 1629: UPDATE ap_invoices_all

1625: l_debug_info := 'Update force_revalidation_flag to No';
1626: Print_Debug(l_api_name, l_debug_info);
1627: ----------------------------------------------------------------
1628:
1629: UPDATE ap_invoices_all
1630: SET force_revalidation_flag = 'N'
1631: WHERE invoice_id = l_invoice_id;
1632:
1633: END IF; -- end of approve_invoice_cur cursor count check

Line 1673: FROM ap_invoices_all

1669:
1670: BEGIN
1671: SELECT *
1672: INTO l_inv_header_rec
1673: FROM ap_invoices_all
1674: WHERE invoice_id = P_Invoice_Id;
1675: END;
1676: --BUG 6974733
1677: IF (l_inv_header_rec.invoice_type_lookup_code NOT IN ('AWT', 'INTEREST')) THEN

Line 1847: FROM ap_invoices_all

1843: and NVL(generate_dists,'N') <> 'D';
1844:
1845: CURSOR get_inv_source IS
1846: SELECT upper(nvl(source, 'X')), org_id
1847: FROM ap_invoices_all
1848: WHERE invoice_id = p_invoice_id;
1849:
1850: l_source ap_invoices_all.source%TYPE;
1851: l_org_id ap_invoices_all.org_id%TYPE;

Line 1850: l_source ap_invoices_all.source%TYPE;

1846: SELECT upper(nvl(source, 'X')), org_id
1847: FROM ap_invoices_all
1848: WHERE invoice_id = p_invoice_id;
1849:
1850: l_source ap_invoices_all.source%TYPE;
1851: l_org_id ap_invoices_all.org_id%TYPE;
1852:
1853: BEGIN
1854: OPEN get_inv_source;

Line 1851: l_org_id ap_invoices_all.org_id%TYPE;

1847: FROM ap_invoices_all
1848: WHERE invoice_id = p_invoice_id;
1849:
1850: l_source ap_invoices_all.source%TYPE;
1851: l_org_id ap_invoices_all.org_id%TYPE;
1852:
1853: BEGIN
1854: OPEN get_inv_source;
1855: FETCH get_inv_source INTO l_source, l_org_id;

Line 3116: -- Modify below SQL to go to base tables : AP_INVOICES_ALL,

3112: p_calling_sequence IN VARCHAR2) IS
3113:
3114: CURSOR PO_Required_Cur IS
3115: -- Perf bug 5058995
3116: -- Modify below SQL to go to base tables : AP_INVOICES_ALL,
3117: -- AP_INVOICE_DISTRIBUTIONS_ALL and
3118: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
3119: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
3120: SELECT 'PO REQUIRED'

Line 3121: FROM ap_invoices_all api, ap_supplier_sites pov

3117: -- AP_INVOICE_DISTRIBUTIONS_ALL and
3118: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
3119: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
3120: SELECT 'PO REQUIRED'
3121: FROM ap_invoices_all api, ap_supplier_sites pov
3122: WHERE EXISTS (select /*+ index(apd AP_INVOICE_DISTRIBUTIONS_U1) */ 'X'
3123: from ap_invoice_distributions_all apd
3124: where apd.invoice_id = api.invoice_id
3125: and apd.line_type_lookup_code in ( 'ITEM', 'ACCRUAL')

Line 3356: l_inv_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

3352: l_debug_loc VARCHAR2(30) := 'Check_Dist_Variance';
3353: l_curr_calling_sequence VARCHAR2(2000);
3354: l_debug_info VARCHAR2(1000);
3355: l_test_var VARCHAR2(50);
3356: l_inv_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
3357: l_dist_count NUMBER;
3358:
3359: BEGIN
3360:

Line 3372: FROM ap_invoices_all ai

3368:
3369: -- Bug 4539514
3370: SELECT invoice_amount
3371: INTO l_inv_amount
3372: FROM ap_invoices_all ai
3373: WHERE ai.invoice_id = p_invoice_id;
3374:
3375: SELECT count(*) INTO l_dist_count
3376: FROM ap_invoice_distributions_all aid

Line 3483: FROM ap_invoice_lines_all AIL, ap_invoices_all A

3479:
3480:
3481: CURSOR Line_Var_Cur IS
3482: SELECT 'Line Total <> Invoice Amount'
3483: FROM ap_invoice_lines_all AIL, ap_invoices_all A
3484: WHERE AIL.invoice_id = A.invoice_id
3485: AND AIL.invoice_id = p_invoice_id
3486: AND ((AIL.line_type_lookup_code <> 'TAX'
3487: and (AIL.line_type_lookup_code NOT IN ('AWT','PREPAY')

Line 3506: l_inv_amount ap_invoices_all.invoice_amount%TYPE;

3502: l_debug_loc VARCHAR2(30) := 'Check_Line_Variance';
3503: l_curr_calling_sequence VARCHAR2(2000);
3504: l_debug_info VARCHAR2(1000);
3505: l_inv_cur_code ap_invoices.invoice_currency_code%type;
3506: l_inv_amount ap_invoices_all.invoice_amount%TYPE;
3507: l_line_count number;
3508: l_org_id ap_invoices_all.org_id%TYPE; --bug 7271262
3509: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE; --bug 7271262
3510: l_return_code VARCHAR2(100); --bug 7271262

Line 3508: l_org_id ap_invoices_all.org_id%TYPE; --bug 7271262

3504: l_debug_info VARCHAR2(1000);
3505: l_inv_cur_code ap_invoices.invoice_currency_code%type;
3506: l_inv_amount ap_invoices_all.invoice_amount%TYPE;
3507: l_line_count number;
3508: l_org_id ap_invoices_all.org_id%TYPE; --bug 7271262
3509: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE; --bug 7271262
3510: l_return_code VARCHAR2(100); --bug 7271262
3511: l_return_message VARCHAR2(1000); --bug 7271262
3512:

Line 3509: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE; --bug 7271262

3505: l_inv_cur_code ap_invoices.invoice_currency_code%type;
3506: l_inv_amount ap_invoices_all.invoice_amount%TYPE;
3507: l_line_count number;
3508: l_org_id ap_invoices_all.org_id%TYPE; --bug 7271262
3509: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE; --bug 7271262
3510: l_return_code VARCHAR2(100); --bug 7271262
3511: l_return_message VARCHAR2(1000); --bug 7271262
3512:
3513: BEGIN

Line 4055: FROM ap_invoices_all AI, ap_invoice_lines_all AIL

4051: -- in the invoice. The prepaid amount will include taxes.
4052:
4053: CURSOR Prepay_Var_Cur IS
4054: SELECT AI.invoice_amount, (0 - sum(nvl(AIL.amount,0)))
4055: FROM ap_invoices_all AI, ap_invoice_lines_all AIL
4056: WHERE AI.invoice_id = p_invoice_id
4057: AND AIL.invoice_id = AI.invoice_id
4058: AND AIL.invoice_includes_prepay_flag = 'N'
4059: AND AIL.line_type_lookup_code IN ('PREPAY', 'TAX')

Line 4501: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and

4497: -- invoice has no user non-releaseable holds (ther than AWT ERROR) --
4498: -- invoice has no manual withholding lines --
4499: ------------------------------------------------------------------------
4500: -- Perf bug 5058995
4501: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and
4502: -- AP_INVOICE_DISTRIBUTIONS_ALL
4503: SELECT 'OK to call Withholding Routine',
4504: (AI.invoice_amount * NVL(AI.exchange_rate, 1)),
4505: AI.invoice_num

Line 4509: FROM ap_invoices_all AI

4505: AI.invoice_num
4506: INTO l_ok_to_withhold,
4507: l_withholding_amount,
4508: l_invoice_num
4509: FROM ap_invoices_all AI
4510: WHERE AI.invoice_id = p_invoice_id
4511: AND EXISTS (SELECT 'At least 1 dist has an AWT Group'
4512: FROM ap_invoice_distributions_all AID1
4513: WHERE AID1.invoice_id = AI.invoice_id

Line 4579: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and

4575: -- invoice has no manual withholding lines --
4576: ------------------------------------------------------------------------
4577:
4578: -- Perf bug 5058995
4579: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and
4580: -- AP_INVOICE_DISTRIBUTIONS_ALL
4581: SELECT 'OK to call Withholding Routine',
4582: (AI.invoice_amount * NVL(AI.exchange_rate,1)),
4583: AI.invoice_num

Line 4587: FROM ap_invoices_all AI

4583: AI.invoice_num
4584: INTO l_ok_to_withhold,
4585: l_withholding_amount,
4586: l_invoice_num
4587: FROM ap_invoices_all AI
4588: WHERE AI.invoice_id = p_invoice_id
4589: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
4590: FROM ap_holds AH,
4591: ap_hold_codes AHC

Line 7078: TYPE orgIDTab IS TABLE OF ap_invoices_all.org_id%Type INDEX BY BINARY_INTEGER;

7074: TYPE invoiceNUMTab IS TABLE OF ap_invoices.invoice_num%Type INDEX BY BINARY_INTEGER;
7075: TYPE procinvoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type;
7076: TYPE hold_org_idTab IS TABLE OF ap_invoices.org_id%Type;
7077:
7078: TYPE orgIDTab IS TABLE OF ap_invoices_all.org_id%Type INDEX BY BINARY_INTEGER;
7079: TYPE invtypeTab IS TABLE OF ap_invoices_all.invoice_type_lookup_code%Type INDEX BY BINARY_INTEGER;
7080:
7081: l_inv_batch_id NUMBER(15);
7082: l_vendor_id NUMBER(15);

Line 7079: TYPE invtypeTab IS TABLE OF ap_invoices_all.invoice_type_lookup_code%Type INDEX BY BINARY_INTEGER;

7075: TYPE procinvoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type;
7076: TYPE hold_org_idTab IS TABLE OF ap_invoices.org_id%Type;
7077:
7078: TYPE orgIDTab IS TABLE OF ap_invoices_all.org_id%Type INDEX BY BINARY_INTEGER;
7079: TYPE invtypeTab IS TABLE OF ap_invoices_all.invoice_type_lookup_code%Type INDEX BY BINARY_INTEGER;
7080:
7081: l_inv_batch_id NUMBER(15);
7082: l_vendor_id NUMBER(15);
7083: l_pay_group VARCHAR2(25);

Line 7168: FROM ap_invoices_all I,

7164: nvl(I.disc_is_inv_less_tax_flag,'N') disc_is_inv_less_tax_flag,
7165: nvl(I.exclude_freight_from_discount,'N') exclude_freight_from_discount,
7166: S.tolerance_id,
7167: s.services_tolerance_id
7168: FROM ap_invoices_all I,
7169: ap_supplier_sites_all S
7170: WHERE I.vendor_site_id = S.vendor_site_id (+)
7171: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7172: ORDER BY I.org_id;

Line 7179: FROM ap_invoices_all I,

7175:
7176: -- Start for bug 6511249
7177: CURSOR SELC_INV_CURSOR_BULK_ERROR IS
7178: SELECT I.invoice_id, i.invoice_num, i.org_id
7179: FROM ap_invoices_all I,
7180: ap_supplier_sites_all S
7181: WHERE I.vendor_site_id = S.vendor_site_id (+)
7182: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7183: ORDER BY I.org_id;

Line 7252: UPDATE ap_invoices_all ai

7248:
7249: /* 6699825/6684139: Added the AND condition to check if the invoice has any
7250: lines. Otherwise, we will not proceed with validating the invoice */
7251:
7252: UPDATE ap_invoices_all ai
7253: SET ai.validation_request_id = p_conc_request_id
7254: WHERE ai.invoice_id = l_invoice_id
7255: AND ai.validation_request_id IS NULL
7256: /*bug 7029877 Invoice saved but not submitted*/

Line 7280: FROM ap_invoices_all ai,

7276: l_invoice_num, l_sel_org_id, l_sel_invoice_type, l_validation_request_id,
7277: l_invoice_id, l_invoice_date, l_invoice_currency_code, l_exchange_rate,
7278: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
7279: l_services_tolerance_id
7280: FROM ap_invoices_all ai,
7281: ap_supplier_sites_all s
7282: WHERE ai.invoice_id = l_invoice_id
7283: AND ai.vendor_site_id = s.vendor_site_id(+);
7284: EXCEPTION

Line 7398: UPDATE ap_invoices_all

7394: fnd_message.set_token('INV_NUM', l_invoice_num);
7395: fnd_file.put_line(fnd_file.log, fnd_message.get);
7396: END IF; */
7397:
7398: UPDATE ap_invoices_all
7399: SET validation_request_id = NULL
7400: WHERE invoice_id = l_invoice_id;
7401:
7402: END IF;

Line 7425: 'SELECT invoice_id from AP_INVOICES_ALL AI '|| -- 7461423

7421: /*bug6858309 modified this dynamic update to filter out
7422: recurring invoices havign GL DATE in never open period*/
7423: /* Added for bug#7270053 Start */
7424: l_sql_stmt :=l_sql_stmt||
7425: 'SELECT invoice_id from AP_INVOICES_ALL AI '|| -- 7461423
7426: ' WHERE AI.VALIDATION_REQUEST_ID IS NULL '||
7427: ' AND AI.APPROVAL_READY_FLAG <> ''S'' '||
7428: ' AND (UPPER(NVL(AI.SOURCE, ''X'')) <> ''RECURRING INVOICE'' OR '||
7429: ' (UPPER(NVL(AI.SOURCE, ''X'')) = ''RECURRING INVOICE'' AND NOT EXISTS '||

Line 7550: UPDATE ap_invoices_all

7546:
7547: FOR k IN 1..l_selected_invoice_ids.count
7548: LOOP
7549:
7550: UPDATE ap_invoices_all
7551: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7552: WHERE invoice_id = l_selected_invoice_ids(k)
7553: AND validation_request_id IS NULL;
7554:

Line 7599: UPDATE ap_invoices_all

7595: OPEN SELC_INV_CURSOR_BULK_ERROR;
7596: FETCH SELC_INV_CURSOR_BULK_ERROR
7597: BULK COLLECT INTO l_selc_inv_cursor_blk_err;
7598:
7599: UPDATE ap_invoices_all
7600: SET validation_request_id = NULL
7601: WHERE validation_request_id IS NOT NULL
7602: AND invoice_id IN (SELECT invoice_id
7603: FROM ap_invoices_all

Line 7603: FROM ap_invoices_all

7599: UPDATE ap_invoices_all
7600: SET validation_request_id = NULL
7601: WHERE validation_request_id IS NOT NULL
7602: AND invoice_id IN (SELECT invoice_id
7603: FROM ap_invoices_all
7604: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID);
7605:
7606: FOR i IN 1..l_selc_inv_cursor_blk_err.count
7607: LOOP

Line 7611: UPDATE ap_invoices_all

7607: LOOP
7608:
7609: SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7610:
7611: UPDATE ap_invoices_all
7612: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7613: WHERE invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id;
7614:
7615: BEGIN

Line 7629: ap_invoices_all ai,

7625: l_invoice_id, l_invoice_date, l_invoice_currency_code, l_exchange_rate,
7626: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
7627: l_services_tolerance_id
7628: FROM
7629: ap_invoices_all ai,
7630: ap_supplier_sites_all s
7631: WHERE
7632: ai.invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id
7633: AND

Line 7750: UPDATE ap_invoices_all

7746: END IF;
7747:
7748: END IF;
7749: -- BUG 7509921 Update Validation Request id to null
7750: UPDATE ap_invoices_all
7751: SET validation_request_id = NULL
7752: WHERE invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id;
7753: --End 7509921
7754: ---------------------------------------------------------------------

Line 7872: UPDATE ap_invoices_all

7868: OPEN SELC_INV_CURSOR_BULK_ERROR;
7869: FETCH SELC_INV_CURSOR_BULK_ERROR
7870: BULK COLLECT INTO l_selc_inv_cursor_blk_err;
7871:
7872: UPDATE ap_invoices_all
7873: SET validation_request_id = NULL
7874: WHERE validation_request_id IS NOT NULL
7875: AND invoice_id IN (SELECT invoice_id
7876: FROM ap_invoices_all

Line 7876: FROM ap_invoices_all

7872: UPDATE ap_invoices_all
7873: SET validation_request_id = NULL
7874: WHERE validation_request_id IS NOT NULL
7875: AND invoice_id IN (SELECT invoice_id
7876: FROM ap_invoices_all
7877: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID);
7878:
7879: FOR i IN 1..l_selc_inv_cursor_blk_err.count
7880: LOOP

Line 7884: UPDATE ap_invoices_all

7880: LOOP
7881:
7882: SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7883:
7884: UPDATE ap_invoices_all
7885: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
7886: WHERE invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id;
7887:
7888: BEGIN

Line 7954: UPDATE ap_invoices_all

7950: END IF;
7951:
7952: END IF;
7953: -- BUG 7509921 Update Validation Request id to null
7954: UPDATE ap_invoices_all
7955: SET validation_request_id = NULL
7956: WHERE invoice_id = l_selc_inv_cursor_blk_err(i).invoice_id;
7957: --End 7509921
7958: ---------------------------------------------------------------------

Line 8065: UPDATE ap_invoices_all

8061: fnd_file.put_line(fnd_file.log, fnd_message.get);
8062: END IF;
8063:
8064: -- Update Validation Request_ID to NULL;
8065: UPDATE ap_invoices_all
8066: SET validation_request_id = NULL
8067: WHERE invoice_id = AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_id;
8068:
8069: END LOOP;

Line 8690: update ap_invoices_all

8686:
8687: --bugfix:5609186 removed the l_recouped_amount from the pay_curr_invoice_amount
8688: --as pay_curr_invoice_amount has nothing to do with recouped amount. Recoupment
8689: --should effect only amount_paid on the invoice.
8690: update ap_invoices_all
8691: set amount_paid = nvl(amount_paid,0) + abs(l_recouped_amount)
8692: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency
8693: (pay_curr_invoice_amount * payment_cross_rate,
8694: payment_currency_code)

Line 8762: update ap_invoices_all

8758: l_debug_info := 'Adjust Amount Applicable To Discount with Retainage';
8759: Print_Debug(l_debug_loc, l_debug_info);
8760: ----------------------------------------------------------------
8761:
8762: update ap_invoices_all
8763: set amount_applicable_to_discount = amount_applicable_to_discount + l_retained_amount
8764: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency
8765: ((invoice_amount + l_retained_amount) * payment_cross_rate,
8766: payment_currency_code)