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 784: FROM ap_invoices_all AI,

780: nvl(AI.exclude_freight_from_discount,'N'),
781: nvl(AI.net_of_retainage_flag,'N'), --9356460
782: nvl(pvs.tolerance_id,ASP.tolerance_id), --added nvl for bug 8425996
783: nvl(pvs.services_tolerance_id,ASP.services_tolerance_id) --added nvl for bug 8425996
784: FROM ap_invoices_all AI,
785: ap_suppliers PV,
786: ap_supplier_sites_all PVS,
787: ap_system_parameters_all ASP --added table for bug 8425996
788: WHERE AI.invoice_id = p_invoice_id

Line 813: FROM ap_invoices_all AI

809: AI.org_id,
810: nvl(AI.disc_is_inv_less_tax_flag,'N'),
811: nvl(AI.exclude_freight_from_discount,'N'),
812: nvl(AI.net_of_retainage_flag,'N') --9356460
813: FROM ap_invoices_all AI
814: WHERE AI.invoice_id = p_invoice_id;
815:
816: CURSOR invoice_type_cur IS
817: SELECT invoice_type_lookup_code

Line 818: FROM ap_invoices_all

814: WHERE AI.invoice_id = p_invoice_id;
815:
816: CURSOR invoice_type_cur IS
817: SELECT invoice_type_lookup_code
818: FROM ap_invoices_all
819: WHERE invoice_id = p_invoice_id;
820:
821: l_unfreeze_count NUMBER:= 0; --Bug9021265
822: TAX_UNFREEZE_EXCEPTION EXCEPTION; --Bug9021265

Line 903: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;

899: Tax_Exception EXCEPTION;
900: Global_Exception EXCEPTION;
901: LCM_Exception EXCEPTION; --Bug 7718385
902: --Retropricing
903: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
904:
905: l_invoice_type_pr AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
906: l_exclude_tax_from_discount VARCHAR2(1);
907: l_exclude_freight_from_disc VARCHAR2(1);

Line 905: l_invoice_type_pr AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;

901: LCM_Exception EXCEPTION; --Bug 7718385
902: --Retropricing
903: l_invoice_type_lookup_code AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
904:
905: l_invoice_type_pr AP_INVOICES_ALL.invoice_type_lookup_code%TYPE;
906: l_exclude_tax_from_discount VARCHAR2(1);
907: l_exclude_freight_from_disc VARCHAR2(1);
908: l_net_of_retainage_flag VARCHAR2(1); --9356460
909: l_cur_count NUMBER := 0;

Line 934: l_inv_header_rec ap_invoices_all%rowtype;

930: -- Bug 6648094
931: l_invoice_line_count NUMBER :=0; --Bug 6684139
932: l_encumbrance_exists NUMBER := 0; -- Bug 6681580
933:
934: l_inv_header_rec ap_invoices_all%rowtype;
935: l_event_class_code zx_trx_headers_gt.event_class_code%TYPE;
936:
937: -- Project LCM 7588322
938: l_lcm_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

Line 1659: FROM ap_invoices_all

1655: --Bug9436217
1656: /*
1657: SELECT invoice_type_lookup_code
1658: INTO l_invoice_type_lookup_code
1659: FROM ap_invoices_all
1660: WHERE invoice_id = l_invoice_id;
1661: */
1662: l_invoice_type_lookup_code := l_invoice_type;
1663: --Bug9436217

Line 2302: UPDATE ap_invoices_all

2298: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2299: END IF;
2300: ----------------------------------------------------------------
2301:
2302: UPDATE ap_invoices_all
2303: SET force_revalidation_flag = 'N'
2304: WHERE invoice_id = l_invoice_id;
2305:
2306: END IF; -- end of approve_invoice_cur cursor count check

Line 2374: FROM ap_invoices_all

2370:
2371: BEGIN
2372: SELECT *
2373: INTO l_inv_header_rec
2374: FROM ap_invoices_all
2375: WHERE invoice_id = P_Invoice_Id;
2376: END;
2377: --BUG 6974733
2378: IF (l_inv_header_rec.invoice_type_lookup_code NOT IN ('AWT', 'INTEREST')) THEN

Line 2632: FROM ap_invoices_all

2628: and NVL(generate_dists,'N') <> 'D';
2629:
2630: CURSOR get_inv_source IS
2631: SELECT upper(nvl(source, 'X')), org_id
2632: FROM ap_invoices_all
2633: WHERE invoice_id = p_invoice_id;
2634:
2635: l_source ap_invoices_all.source%TYPE;
2636: l_org_id ap_invoices_all.org_id%TYPE;

Line 2635: l_source ap_invoices_all.source%TYPE;

2631: SELECT upper(nvl(source, 'X')), org_id
2632: FROM ap_invoices_all
2633: WHERE invoice_id = p_invoice_id;
2634:
2635: l_source ap_invoices_all.source%TYPE;
2636: l_org_id ap_invoices_all.org_id%TYPE;
2637:
2638: BEGIN
2639: OPEN get_inv_source;

Line 2636: l_org_id ap_invoices_all.org_id%TYPE;

2632: FROM ap_invoices_all
2633: WHERE invoice_id = p_invoice_id;
2634:
2635: l_source ap_invoices_all.source%TYPE;
2636: l_org_id ap_invoices_all.org_id%TYPE;
2637:
2638: BEGIN
2639: OPEN get_inv_source;
2640: FETCH get_inv_source INTO l_source, l_org_id;

Line 3891: from ap_invoices_all

3887: Select vendor_id,vendor_site_id,
3888: remit_to_supplier_site_id,invoice_type_lookup_code
3889: into l_vendor_id,l_vendor_site_id,
3890: l_remit_to_supplier_site_id,l_invoice_type_lookup_code
3891: from ap_invoices_all
3892: where invoice_id = p_invoice_id;
3893:
3894: if ( l_invoice_type_lookup_code = 'RETAINAGE RELEASE') then
3895:

Line 3964: from ap_invoices_all

3960: /* Select vendor_id,vendor_site_id,
3961: remit_to_supplier_site_id,invoice_type_lookup_code
3962: into l_vendor_id,l_vendor_site_id,
3963: l_remit_to_supplier_site_id,l_invoice_type_lookup_code
3964: from ap_invoices_all
3965: where invoice_id = p_invoice_id; */
3966:
3967:
3968:

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

4215: p_calling_sequence IN VARCHAR2) IS
4216:
4217: CURSOR PO_Required_Cur IS
4218: -- Perf bug 5058995
4219: -- Modify below SQL to go to base tables : AP_INVOICES_ALL,
4220: -- AP_INVOICE_DISTRIBUTIONS_ALL and
4221: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
4222: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
4223: SELECT 'PO REQUIRED'

Line 4224: FROM ap_invoices_all api, ap_supplier_sites pov

4220: -- AP_INVOICE_DISTRIBUTIONS_ALL and
4221: -- AP_SUPPLIER_SITES(instead of po_vendor_sites)
4222: /* Added the Hint index(apd AP_INVOICE_DISTRIBUTIONS_U1) for bug#7270053 */
4223: SELECT 'PO REQUIRED'
4224: FROM ap_invoices_all api, ap_supplier_sites pov
4225: WHERE EXISTS (select /*+ index(apd AP_INVOICE_DISTRIBUTIONS_U1) */ 'X'
4226: from ap_invoice_distributions_all apd
4227: where apd.invoice_id = api.invoice_id
4228: and apd.line_type_lookup_code in ( 'ITEM', 'ACCRUAL')

Line 4582: l_inv_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

4578: l_debug_loc VARCHAR2(30) := 'Check_Dist_Variance';
4579: l_curr_calling_sequence VARCHAR2(2000);
4580: l_debug_info VARCHAR2(1000);
4581: l_test_var VARCHAR2(50);
4582: l_inv_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;
4583: l_dist_count NUMBER;
4584:
4585: BEGIN
4586:

Line 4598: FROM ap_invoices_all ai

4594:
4595: -- Bug 4539514
4596: SELECT invoice_amount
4597: INTO l_inv_amount
4598: FROM ap_invoices_all ai
4599: WHERE ai.invoice_id = p_invoice_id;
4600:
4601: SELECT count(*) INTO l_dist_count
4602: FROM ap_invoice_distributions_all aid

Line 4864: FROM ap_invoice_lines_all AIL, ap_invoices_all A

4860:
4861:
4862: CURSOR Line_Var_Cur IS
4863: SELECT 'Line Total <> Invoice Amount'
4864: FROM ap_invoice_lines_all AIL, ap_invoices_all A
4865: WHERE AIL.invoice_id = A.invoice_id
4866: AND AIL.invoice_id = p_invoice_id
4867: AND ((AIL.line_type_lookup_code <> 'TAX'
4868: and (AIL.line_type_lookup_code NOT IN ('AWT','PREPAY')

Line 4887: l_inv_amount ap_invoices_all.invoice_amount%TYPE;

4883: l_debug_loc VARCHAR2(30) := 'Check_Line_Variance';
4884: l_curr_calling_sequence VARCHAR2(2000);
4885: l_debug_info VARCHAR2(1000);
4886: l_inv_cur_code ap_invoices.invoice_currency_code%type;
4887: l_inv_amount ap_invoices_all.invoice_amount%TYPE;
4888: l_line_count number;
4889: l_org_id ap_invoices_all.org_id%TYPE; --bug 7271262
4890: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE; --bug 7271262
4891: l_return_code VARCHAR2(100); --bug 7271262

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

4885: l_debug_info VARCHAR2(1000);
4886: l_inv_cur_code ap_invoices.invoice_currency_code%type;
4887: l_inv_amount ap_invoices_all.invoice_amount%TYPE;
4888: l_line_count number;
4889: l_org_id ap_invoices_all.org_id%TYPE; --bug 7271262
4890: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE; --bug 7271262
4891: l_return_code VARCHAR2(100); --bug 7271262
4892: l_return_message VARCHAR2(1000); --bug 7271262
4893:

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

4886: l_inv_cur_code ap_invoices.invoice_currency_code%type;
4887: l_inv_amount ap_invoices_all.invoice_amount%TYPE;
4888: l_line_count number;
4889: l_org_id ap_invoices_all.org_id%TYPE; --bug 7271262
4890: l_set_of_books_id ap_invoices_all.set_of_books_id%TYPE; --bug 7271262
4891: l_return_code VARCHAR2(100); --bug 7271262
4892: l_return_message VARCHAR2(1000); --bug 7271262
4893:
4894: BEGIN

Line 5126: FROM AP_INVOICES_ALL

5122:
5123: --Bug#10416960
5124: SELECT INVOICE_TYPE_LOOKUP_CODE
5125: INTO l_invoice_type
5126: FROM AP_INVOICES_ALL
5127: WHERE INVOICE_ID=p_invoice_id;
5128:
5129: IF(l_invoice_type <> 'PO PRICE ADJUST')THEN
5130: -- get the lines which can be adjusted

Line 5520: FROM ap_invoices_all AI, ap_invoice_lines_all AIL

5516: WHERE ail1.invoice_id=ai.invoice_id
5517: AND ail1.line_type_lookup_code ='AWT')
5518: ,nvl(AI.amount_paid,0)
5519: , (0 - sum(nvl(AIL.amount,0))) -- taking the remaining amount to be paid on as part of bug 8339454
5520: FROM ap_invoices_all AI, ap_invoice_lines_all AIL
5521: WHERE AI.invoice_id = p_invoice_id
5522: AND AIL.invoice_id = AI.invoice_id
5523: AND AIL.invoice_includes_prepay_flag = 'N' --Bug 13050996: Uncommented out this line
5524: AND AIL.line_type_lookup_code IN ('PREPAY', 'TAX')

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

6004: -- invoice has no user non-releaseable holds (ther than AWT ERROR) --
6005: -- invoice has no manual withholding lines --
6006: ------------------------------------------------------------------------
6007: -- Perf bug 5058995
6008: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and
6009: -- AP_INVOICE_DISTRIBUTIONS_ALL
6010: SELECT 'OK to call Withholding Routine',
6011: (AI.invoice_amount * NVL(AI.exchange_rate, 1)),
6012: AI.invoice_num

Line 6016: FROM ap_invoices_all AI

6012: AI.invoice_num
6013: INTO l_ok_to_withhold,
6014: l_withholding_amount,
6015: l_invoice_num
6016: FROM ap_invoices_all AI
6017: WHERE AI.invoice_id = p_invoice_id
6018: AND EXISTS (SELECT 'At least 1 dist has an AWT Group'
6019: FROM ap_invoice_distributions_all AID1
6020: WHERE AID1.invoice_id = AI.invoice_id

Line 6046: ap_invoices_all ai

6042: --bug 9293773
6043: SELECT nvl(asp.withholding_date_basis,'INVOICEDATE')
6044: INTO l_withhold_date_basis
6045: FROM ap_system_parameters_all asp,
6046: ap_invoices_all ai
6047: WHERE ai.invoice_id = p_invoice_id
6048: AND ai.org_id = asp.org_id;
6049:
6050: IF l_withhold_date_basis = 'INVOICEDATE' THEN

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

6098: -- invoice has no manual withholding lines --
6099: ------------------------------------------------------------------------
6100:
6101: -- Perf bug 5058995
6102: -- Modify below SQL to go to base tables : AP_INVOICES_ALL and
6103: -- AP_INVOICE_DISTRIBUTIONS_ALL
6104: SELECT 'OK to call Withholding Routine',
6105: (AI.invoice_amount * NVL(AI.exchange_rate,1)),
6106: AI.invoice_num

Line 6110: FROM ap_invoices_all AI

6106: AI.invoice_num
6107: INTO l_ok_to_withhold,
6108: l_withholding_amount,
6109: l_invoice_num
6110: FROM ap_invoices_all AI
6111: WHERE AI.invoice_id = p_invoice_id
6112: AND NOT EXISTS (SELECT 'Unreleased System holds exist'
6113: FROM ap_holds AH,
6114: ap_hold_codes AHC

Line 6742: from ap_invoices_all

6738: END IF;
6739:
6740: select terms_date
6741: into l_old_terms_date
6742: from ap_invoices_all
6743: where invoice_id = p_invoice_id;
6744:
6745: l_debug_info := 'Before updating invoice terms_date';
6746: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 6750: Update ap_invoices_all

6746: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6747: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6748: END IF;
6749:
6750: Update ap_invoices_all
6751: set terms_date =trunc(sysdate),
6752: invoice_received_date = decode(invoice_received_date,null,null,trunc(sysdate)) --bug9148859
6753: where invoice_id = p_invoice_id;
6754:

Line 8027: from ap_system_parameters_all asp, ap_invoices_all ai

8023: /* bug 13035539 starts */
8024:
8025: select BASE_CURRENCY_CODE
8026: into l_tmp_base_curr_code
8027: from ap_system_parameters_all asp, ap_invoices_all ai
8028: where asp.org_id = ai.org_id
8029: and ai.invoice_id = p_invoice_id;
8030:
8031: /* bug 13035539 ends */

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

9180: TYPE invoiceNUMTab IS TABLE OF ap_invoices.invoice_num%Type INDEX BY BINARY_INTEGER;
9181: TYPE procinvoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type;
9182: TYPE hold_org_idTab IS TABLE OF ap_invoices.org_id%Type;
9183:
9184: TYPE orgIDTab IS TABLE OF ap_invoices_all.org_id%Type INDEX BY BINARY_INTEGER;
9185: TYPE invtypeTab IS TABLE OF ap_invoices_all.invoice_type_lookup_code%Type INDEX BY BINARY_INTEGER;
9186:
9187: l_inv_batch_id NUMBER(15);
9188: l_vendor_id NUMBER(15);

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

9181: TYPE procinvoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type;
9182: TYPE hold_org_idTab IS TABLE OF ap_invoices.org_id%Type;
9183:
9184: TYPE orgIDTab IS TABLE OF ap_invoices_all.org_id%Type INDEX BY BINARY_INTEGER;
9185: TYPE invtypeTab IS TABLE OF ap_invoices_all.invoice_type_lookup_code%Type INDEX BY BINARY_INTEGER;
9186:
9187: l_inv_batch_id NUMBER(15);
9188: l_vendor_id NUMBER(15);
9189: l_pay_group VARCHAR2(25);

Line 9276: FROM ap_invoices_all I,

9272: nvl(I.disc_is_inv_less_tax_flag,'N') disc_is_inv_less_tax_flag,
9273: nvl(I.exclude_freight_from_discount,'N') exclude_freight_from_discount,
9274: nvl(S.tolerance_id,ASP.tolerance_id), --Bug8524767
9275: nvl(S.services_tolerance_id,ASP.services_tolerance_id) --Bug8524767
9276: FROM ap_invoices_all I,
9277: ap_supplier_sites_all S,
9278: ap_system_parameters_all ASP --Bug8524767
9279: WHERE I.vendor_site_id = S.vendor_site_id (+)
9280: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID

Line 9295: FROM ap_invoices_all I

9291: -- Start for bug 6511249
9292: --bug7902867 cusror modified removed ap_supplier_sites_all in join
9293: CURSOR SELC_INV_CURSOR_BULK_ERROR IS
9294: SELECT I.invoice_id, i.invoice_num, i.org_id
9295: FROM ap_invoices_all I
9296: WHERE I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
9297: ORDER BY I.org_id;
9298:
9299: TYPE selc_inv_cursor_blk_err is table of selc_inv_cursor_bulk_error%rowtype;

Line 9349: FROM ap_invoices_all

9345: invoice_id,
9346: invoice_amount,
9347: payment_status_flag,
9348: invoice_type_lookup_code)
9349: FROM ap_invoices_all
9350: WHERE invoice_id = p_invoice_id
9351: FOR UPDATE NOWAIT; -- Bug 13374062
9352: -- bug 9304530 - end
9353:

Line 9489: UPDATE ap_invoices_all ai

9485:
9486: /* 6699825/6684139: Added the AND condition to check if the invoice has any
9487: lines. Otherwise, we will not proceed with validating the invoice */
9488:
9489: UPDATE ap_invoices_all ai
9490: SET ai.validation_request_id = p_conc_request_id
9491: WHERE ai.invoice_id = l_invoice_id
9492: AND ai.validation_request_id IS NULL
9493: /*bug 7029877 Invoice saved but not submitted*/

Line 9521: FROM ap_invoices_all ai,

9517: l_invoice_num, l_sel_org_id, l_sel_invoice_type, l_validation_request_id,
9518: l_invoice_id, l_invoice_date, l_invoice_currency_code, l_exchange_rate,
9519: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
9520: l_services_tolerance_id
9521: FROM ap_invoices_all ai,
9522: ap_supplier_sites_all s,
9523: ap_system_parameters_all asp
9524: WHERE ai.invoice_id = l_invoice_id
9525: AND ai.vendor_site_id = s.vendor_site_id(+)

Line 9703: UPDATE ap_invoices_all

9699: fnd_message.set_token('INV_NUM', l_invoice_num);
9700: fnd_file.put_line(fnd_file.log, fnd_message.get);
9701: END IF; */
9702:
9703: UPDATE ap_invoices_all
9704: SET validation_request_id = NULL
9705: WHERE invoice_id = l_invoice_id;
9706:
9707: END IF;

Line 9772: -- AP_INVOICES_ALL is replace with ap_invoices

9768: /*bug6858309 modified this dynamic update to filter out
9769: recurring invoices havign GL DATE in never open period*/
9770: /* Added for bug#7270053 Start */
9771: --BUG7902867 replace view with base tables in sub queries
9772: -- AP_INVOICES_ALL is replace with ap_invoices
9773: /* BUG 8218038 added nvl condition for historical and payment status flags */
9774: /* Changed the Sql structure to replace the exists with UNION ALL for bug#7584153 */
9775:
9776: -- Bug 9777752 : Restructured dynamic SQL

Line 10045: UPDATE ap_invoices_all

10041:
10042: --Bug9436217
10043:
10044: FORALL k IN 1..l_selected_invoice_ids.COUNT
10045: UPDATE ap_invoices_all
10046: SET validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
10047: WHERE invoice_id = l_selected_invoice_ids(k)
10048: AND validation_request_id IS NULL;
10049:

Line 10118: Update ap_invoices_all set validation_request_id = NULL where invoice_id = l_r_inv_err(i);

10114: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;
10115:
10116:
10117: FORALL i in 1..l_r_inv_err.count
10118: Update ap_invoices_all set validation_request_id = NULL where invoice_id = l_r_inv_err(i);
10119:
10120: -- Bug 14579876: Moved FND_LOG.String() call above SAVEPOINT
10121: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Rows updated ' || sql%rowcount);

Line 10450: UPDATE ap_invoices_all

10446: END LOOP;
10447:
10448: --Bug9436217
10449:
10450: UPDATE ap_invoices_all
10451: SET validation_request_id = NULL
10452: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID;
10453:
10454:

Line 10610: Update ap_invoices_all set validation_request_id = NULL where invoice_id = l_r_inv_err(i);

10606:
10607: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST ;
10608:
10609: FORALL i in 1..l_r_inv_err.count
10610: Update ap_invoices_all set validation_request_id = NULL where invoice_id = l_r_inv_err(i);
10611:
10612: -- Bug 14579876: Moved FND_LOG.String() call above SAVEPOINT
10613: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10614: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Rows updated ' || sql%rowcount);

Line 10896: UPDATE ap_invoices_all

10892: END LOOP;
10893:
10894: --Bug9436217
10895:
10896: UPDATE ap_invoices_all
10897: SET validation_request_id = NULL
10898: WHERE validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID;
10899:
10900: CLOSE SELECTED_INVOICES_CURSOR ;

Line 11052: UPDATE /+ index(a AP_INVOICES_U1) / ap_invoices_all a --hint added for bug 13429649

11048:
11049: --Bug9436217
11050: -- table alias added for bug 13706647
11051: FORALL blk_upd IN 1..l_selected_invoice_ids.COUNT
11052: UPDATE /*+ index(a AP_INVOICES_U1) */ ap_invoices_all a --hint added for bug 13429649
11053: SET validation_request_id = NULL
11054: WHERE invoice_id = l_selected_invoice_ids( blk_upd )
11055: AND validation_request_id IS NOT NULL;
11056:

Line 11834: update ap_invoices_all

11830:
11831: --bugfix:5609186 removed the l_recouped_amount from the pay_curr_invoice_amount
11832: --as pay_curr_invoice_amount has nothing to do with recouped amount. Recoupment
11833: --should effect only amount_paid on the invoice.
11834: update ap_invoices_all
11835: set amount_paid = nvl(amount_paid,0) + abs(l_recouped_amount)
11836: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency
11837: (pay_curr_invoice_amount * payment_cross_rate,
11838: payment_currency_code)

Line 11937: update ap_invoices_all

11933: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_debug_loc,l_debug_info);
11934: END IF;
11935: ----------------------------------------------------------------
11936:
11937: update ap_invoices_all
11938: set amount_applicable_to_discount = amount_applicable_to_discount + l_retained_amount
11939: ,pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency
11940: ((invoice_amount + l_retained_amount) * payment_cross_rate,
11941: payment_currency_code)

Line 12456: UPDATE ap_invoices_all

12452: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_debug_loc,l_debug_info);
12453: END IF;
12454: ----------------------------------------------------------------
12455:
12456: UPDATE ap_invoices_all
12457: SET amount_applicable_to_discount = amount_applicable_to_discount
12458: + l_retained_amount
12459: , pay_curr_invoice_amount = ap_utilities_pkg.ap_round_currency(
12460: (invoice_amount + l_retained_amount)