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

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 689: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;

685: l_debug_loc VARCHAR2(30) := 'Approval';
686: l_curr_calling_sequence VARCHAR2(2000);
687: l_debug_info VARCHAR2(2000);
688:
689: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
690: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
691: l_exchange_date AP_INVOICES.exchange_date%TYPE;
692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;

Line 690: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;

686: l_curr_calling_sequence VARCHAR2(2000);
687: l_debug_info VARCHAR2(2000);
688:
689: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
690: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
691: l_exchange_date AP_INVOICES.exchange_date%TYPE;
692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;
694: l_vendor_id AP_INVOICES.vendor_id%TYPE;

Line 691: l_exchange_date AP_INVOICES.exchange_date%TYPE;

687: l_debug_info VARCHAR2(2000);
688:
689: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
690: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
691: l_exchange_date AP_INVOICES.exchange_date%TYPE;
692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;
694: l_vendor_id AP_INVOICES.vendor_id%TYPE;
695: l_invoice_date AP_INVOICES.invoice_date%TYPE;

Line 692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;

688:
689: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
690: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
691: l_exchange_date AP_INVOICES.exchange_date%TYPE;
692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;
694: l_vendor_id AP_INVOICES.vendor_id%TYPE;
695: l_invoice_date AP_INVOICES.invoice_date%TYPE;
696: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;

Line 693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;

689: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
690: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
691: l_exchange_date AP_INVOICES.exchange_date%TYPE;
692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;
694: l_vendor_id AP_INVOICES.vendor_id%TYPE;
695: l_invoice_date AP_INVOICES.invoice_date%TYPE;
696: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
697: l_invoice_type AP_INVOICES.invoice_type_lookup_code%TYPE;

Line 694: l_vendor_id AP_INVOICES.vendor_id%TYPE;

690: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
691: l_exchange_date AP_INVOICES.exchange_date%TYPE;
692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;
694: l_vendor_id AP_INVOICES.vendor_id%TYPE;
695: l_invoice_date AP_INVOICES.invoice_date%TYPE;
696: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
697: l_invoice_type AP_INVOICES.invoice_type_lookup_code%TYPE;
698:

Line 695: l_invoice_date AP_INVOICES.invoice_date%TYPE;

691: l_exchange_date AP_INVOICES.exchange_date%TYPE;
692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;
694: l_vendor_id AP_INVOICES.vendor_id%TYPE;
695: l_invoice_date AP_INVOICES.invoice_date%TYPE;
696: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
697: l_invoice_type AP_INVOICES.invoice_type_lookup_code%TYPE;
698:
699: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;

Line 696: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;

692: l_invoice_amount AP_INVOICES.invoice_amount%TYPE;
693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;
694: l_vendor_id AP_INVOICES.vendor_id%TYPE;
695: l_invoice_date AP_INVOICES.invoice_date%TYPE;
696: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
697: l_invoice_type AP_INVOICES.invoice_type_lookup_code%TYPE;
698:
699: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
700:

Line 697: l_invoice_type AP_INVOICES.invoice_type_lookup_code%TYPE;

693: l_invoice_base_amount AP_INVOICES.base_amount%TYPE;
694: l_vendor_id AP_INVOICES.vendor_id%TYPE;
695: l_invoice_date AP_INVOICES.invoice_date%TYPE;
696: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
697: l_invoice_type AP_INVOICES.invoice_type_lookup_code%TYPE;
698:
699: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
700:
701: l_insufficient_data_exist BOOLEAN := FALSE;

Line 699: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;

695: l_invoice_date AP_INVOICES.invoice_date%TYPE;
696: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
697: l_invoice_type AP_INVOICES.invoice_type_lookup_code%TYPE;
698:
699: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
700:
701: l_insufficient_data_exist BOOLEAN := FALSE;
702: l_line_variance_hold_exist BOOLEAN := FALSE;
703: l_need_to_round_flag VARCHAR2(1) := 'Y';

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 1146: FROM ap_invoices

1142: ---------------------------------------------------------------
1143:
1144: SELECT invoice_amount, base_amount
1145: INTO l_inv_amount , l_inv_base_amount
1146: FROM ap_invoices
1147: WHERE invoice_id = l_invoice_id;
1148:
1149: ---------------------------------------------------------------
1150: l_debug_info := 'Invoice amount: '|| l_inv_amount ||

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 2232: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

2228: |
2229: *============================================================================*/
2230:
2231: PROCEDURE Check_Insufficient_Line_Data(
2232: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
2233: p_system_user IN NUMBER,
2234: p_holds IN OUT NOCOPY HOLDSARRAY,
2235: p_holds_count IN OUT NOCOPY COUNTARRAY,
2236: p_release_count IN OUT NOCOPY COUNTARRAY,

Line 2382: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,

2378: p_invoice_currency IN VARCHAR2,
2379: p_exchange_rate IN NUMBER,
2380: p_exchange_rate_type IN VARCHAR2,
2381: p_exchange_date IN DATE,
2382: p_inv_line_rec IN AP_INVOICES_PKG.r_invoice_line_rec,
2383: p_system_user IN NUMBER,
2384: p_holds IN OUT NOCOPY HOLDSARRAY,
2385: p_holds_count IN OUT NOCOPY COUNTARRAY,
2386: p_release_count IN OUT NOCOPY COUNTARRAY,

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 3223: FROM ap_invoices I

3219: p_calling_sequence IN VARCHAR2) IS
3220:
3221: CURSOR No_Rate_Cur IS
3222: SELECT 'Foreign Invoice without exchange rate'
3223: FROM ap_invoices I
3224: WHERE I.invoice_id = p_invoice_id
3225: AND I.invoice_currency_code <> p_base_currency_code
3226: AND I.exchange_rate is null;
3227:

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 3505: l_inv_cur_code ap_invoices.invoice_currency_code%type;

3501: l_test_var VARCHAR2(50);
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

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 3531: FROM ap_invoices ai

3527: --select, to pass as parameters for JAI hook jai_ap_tolerance_pkg.inv_holds_check
3528:
3529: SELECT invoice_amount,org_id,set_of_books_id
3530: INTO l_inv_amount,l_org_id,l_set_of_books_id
3531: FROM ap_invoices ai
3532: WHERE ai.invoice_id = p_invoice_id;
3533:
3534: --Added the below code hook for India Localization as part of bug7271262
3535:

Line 3657: l_round_inv_line_numbers AP_INVOICES_UTILITY_PKG.inv_line_num_tab_type; --6892789

3653: l_debug_context VARCHAR2(2000);
3654:
3655: l_modified_line_rounding_amt NUMBER; --6892789
3656: l_base_amt NUMBER; --6892789
3657: l_round_inv_line_numbers AP_INVOICES_UTILITY_PKG.inv_line_num_tab_type; --6892789
3658:
3659: BEGIN
3660:
3661: l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||

Line 3719: l_round_amt_exist := AP_INVOICES_UTILITY_PKG.round_base_amts(

3715: case, adjust line base amount upto zero and adjust the remaing amount in
3716: another line having next max amount */
3717:
3718: -- get the lines which can be adjusted
3719: l_round_amt_exist := AP_INVOICES_UTILITY_PKG.round_base_amts(
3720: X_Invoice_Id => p_invoice_id,
3721: X_Reporting_Ledger_Id => NULL,
3722: X_Rounded_Line_Numbers => l_round_inv_line_numbers,
3723: X_Rounded_Amt => l_rounded_amt,

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 4537: FROM ap_invoices

4533: AND awt_group_id IS NOT NULL; */
4534: /* 5886500 */
4535: SELECT invoice_date
4536: INTO l_withholding_date
4537: FROM ap_invoices
4538: WHERE invoice_id = p_invoice_id;
4539:
4540: EXCEPTION
4541: WHEN NO_DATA_FOUND THEN

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 5646: SELECT AP_INVOICES_PKG.Get_Holds_Count(invoice_id),

5642: p_approval_status IN OUT NOCOPY VARCHAR2,
5643: p_calling_sequence IN VARCHAR2) IS
5644:
5645: CURSOR Invoice_Status_Cur IS
5646: SELECT AP_INVOICES_PKG.Get_Holds_Count(invoice_id),
5647: AP_INVOICES_PKG.Get_Approval_Status(
5648: invoice_id,
5649: invoice_amount,
5650: payment_status_flag,

Line 5647: AP_INVOICES_PKG.Get_Approval_Status(

5643: p_calling_sequence IN VARCHAR2) IS
5644:
5645: CURSOR Invoice_Status_Cur IS
5646: SELECT AP_INVOICES_PKG.Get_Holds_Count(invoice_id),
5647: AP_INVOICES_PKG.Get_Approval_Status(
5648: invoice_id,
5649: invoice_amount,
5650: payment_status_flag,
5651: invoice_type_lookup_code)

Line 5652: FROM ap_invoices

5648: invoice_id,
5649: invoice_amount,
5650: payment_status_flag,
5651: invoice_type_lookup_code)
5652: FROM ap_invoices
5653: WHERE invoice_id = p_invoice_id;
5654:
5655: l_debug_loc VARCHAR2(30) := 'Get_Invoice_Statuses';
5656: l_curr_calling_sequence VARCHAR2(2000);

Line 5921: FROM ap_invoices

5917: l_payment_method,
5918: l_invoice_curr_code,
5919: l_pay_curr_code,
5920: l_invoice_date
5921: FROM ap_invoices
5922: WHERE invoice_id = p_invoice_id;
5923:
5924: EXCEPTION
5925: WHEN OTHERS THEN

Line 6050: UPDATE ap_invoices

6046: ------------------------------------------------------------
6047: l_debug_info := 'Update Invoice Header';
6048: ------------------------------------------------------------
6049:
6050: UPDATE ap_invoices
6051: SET amount_applicable_to_discount = l_new_discountable_amount,
6052: validated_tax_amount = l_total_tax_amount+l_total_freight_amount
6053: WHERE invoice_id = p_invoice_id;
6054:

Line 6073: UPDATE ap_invoices

6069: AND ((line_type_lookup_code NOT IN ('PREPAY', 'AWT')
6070: AND prepay_distribution_id IS NULL)
6071: OR nvl(invoice_includes_prepay_flag,'N') = 'Y');
6072:
6073: UPDATE ap_invoices
6074: SET invoice_amount = l_tmp_invoice_amount,
6075: amount_applicable_to_discount = l_tmp_invoice_amount,
6076: base_amount = l_tmp_base_amount,
6077: pay_curr_invoice_amount = decode(invoice_currency_code,

Line 6119: FROM ap_invoices

6115: l_payment_cross_rate,
6116: l_payment_method,
6117: l_invoice_curr_code,
6118: l_pay_curr_code
6119: FROM ap_invoices
6120: WHERE invoice_id = p_invoice_id;
6121:
6122: EXCEPTION
6123: WHEN OTHERS THEN

Line 6174: -- procedure will not update ap_invoices, but will update payment schedule.

6170: --where prepayment is applied. This will be called from the prcedure
6171: -- Exclude_Tax_Freight_From_Discount for the feature as described in the description of
6172: -- the former procedure. A similar procedure exists in prepayment package
6173: -- however due to some restriction we are creating the procedure here. This
6174: -- procedure will not update ap_invoices, but will update payment schedule.
6175: -------------------------------------------------------------------------------
6176:
6177: PROCEDURE update_payment_schedule_prepay(
6178: p_invoice_id IN NUMBER,

Line 6331: (p_table_name => 'AP_INVOICES',

6327: CLOSE SCHEDULES;
6328:
6329: --Bug 4539462 DBI logging
6330: AP_DBI_PKG.Maintain_DBI_Summary
6331: (p_table_name => 'AP_INVOICES',
6332: p_operation => 'U',
6333: p_key_value1 => P_invoice_id,
6334: p_calling_sequence => l_current_calling_sequence);
6335:

Line 6372: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;

6368: p_last_updated_by IN NUMBER,
6369: p_last_update_login IN NUMBER,
6370: p_calling_sequence IN VARCHAR2) IS
6371: l_manual_awt_amount ap_invoice_distributions.amount%TYPE :=0;
6372: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
6373: l_pay_curr_code ap_invoices.payment_currency_code%TYPE;
6374: l_num_payments NUMBER := 0;
6375: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;--1724924
6376: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;

Line 6373: l_pay_curr_code ap_invoices.payment_currency_code%TYPE;

6369: p_last_update_login IN NUMBER,
6370: p_calling_sequence IN VARCHAR2) IS
6371: l_manual_awt_amount ap_invoice_distributions.amount%TYPE :=0;
6372: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
6373: l_pay_curr_code ap_invoices.payment_currency_code%TYPE;
6374: l_num_payments NUMBER := 0;
6375: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;--1724924
6376: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;
6377: l_gross_amount ap_payment_schedules.gross_amount%TYPE := 0;

Line 6375: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;--1724924

6371: l_manual_awt_amount ap_invoice_distributions.amount%TYPE :=0;
6372: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
6373: l_pay_curr_code ap_invoices.payment_currency_code%TYPE;
6374: l_num_payments NUMBER := 0;
6375: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;--1724924
6376: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;
6377: l_gross_amount ap_payment_schedules.gross_amount%TYPE := 0;
6378: l_debug_loc VARCHAR2(30) := 'Manual_Withhold_Tax';
6379: l_curr_calling_sequence VARCHAR2(2000);

Line 6412: FROM ap_invoices

6408: invoice_type_lookup_code --Bug 1724924
6409: INTO l_payment_cross_rate,
6410: l_pay_curr_code,
6411: l_invoice_type --Bug 1724924
6412: FROM ap_invoices
6413: WHERE invoice_id = p_invoice_id;
6414:
6415: --===================================================================
6416: --Prorate the manual AWT against the invoice amount remaining

Line 6455: update ap_invoices

6451: payment_status_flag = DECODE(payment_status_flag,
6452: 'Y','P',payment_status_flag)
6453: where invoice_id = p_invoice_id;
6454:
6455: update ap_invoices
6456: set payment_status_flag = DECODE(payment_status_flag,
6457: 'Y','P',payment_status_flag)
6458: where invoice_id = p_invoice_id;
6459:

Line 6493: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;

6489: SELECT payment_num,gross_amount,amount_remaining
6490: FROM ap_payment_schedules
6491: WHERE invoice_id=p_invoice_id;
6492: l_automatic_awt_amount ap_invoice_distributions.amount%TYPE :=0;
6493: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
6494: l_pay_curr_code ap_invoices.payment_currency_code%TYPE;
6495: l_num_payments NUMBER := 0;
6496: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
6497: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;

Line 6494: l_pay_curr_code ap_invoices.payment_currency_code%TYPE;

6490: FROM ap_payment_schedules
6491: WHERE invoice_id=p_invoice_id;
6492: l_automatic_awt_amount ap_invoice_distributions.amount%TYPE :=0;
6493: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
6494: l_pay_curr_code ap_invoices.payment_currency_code%TYPE;
6495: l_num_payments NUMBER := 0;
6496: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
6497: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;
6498: l_gross_amount ap_payment_schedules.gross_amount%TYPE := 0;

Line 6496: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;

6492: l_automatic_awt_amount ap_invoice_distributions.amount%TYPE :=0;
6493: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
6494: l_pay_curr_code ap_invoices.payment_currency_code%TYPE;
6495: l_num_payments NUMBER := 0;
6496: l_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
6497: l_inv_amt_remaining ap_payment_schedules.amount_remaining%TYPE := 0;
6498: l_gross_amount ap_payment_schedules.gross_amount%TYPE := 0;
6499: l_payment_num ap_payment_schedules.payment_num%TYPE;
6500: l_debug_loc VARCHAR2(30) := 'Update_Pay_Sched_For_Awt';

Line 6524: FROM ap_invoices

6520: invoice_type_lookup_code
6521: INTO l_payment_cross_rate,
6522: l_pay_curr_code,
6523: l_invoice_type
6524: FROM ap_invoices
6525: WHERE invoice_id = p_invoice_id;
6526:
6527:
6528: OPEN Update_payment_schedule;

Line 6539: from ap_invoices ai

6535: ai.payment_cross_rate,l_pay_curr_code),0)*
6536: l_gross_amount/decode(ai.pay_curr_invoice_amount, 0, 1,
6537: nvl(ai.pay_curr_invoice_amount, 1))
6538: into l_wt_amt_to_subtract
6539: from ap_invoices ai
6540: where ai.invoice_id=p_invoice_id;
6541:
6542: --===================================================================
6543: --Prorate the automatic AWT against the invoice amount remaining

Line 6607: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;

6603: l_terms_date DATE;
6604: l_invoice_amount NUMBER;
6605: l_pay_curr_invoice_amount NUMBER;
6606: l_payment_method VARCHAR2(30);
6607: l_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
6608: l_invoice_curr_code VARCHAR2(15);
6609: l_pay_curr_code VARCHAR2(15);
6610: l_debug_info VARCHAR2(200);
6611: l_debug_loc VARCHAR2(30) := 'createPaymentSchedules';

Line 6661: FROM ap_invoices

6657: l_payment_cross_rate,
6658: l_payment_method,
6659: l_invoice_curr_code,
6660: l_pay_curr_code
6661: FROM ap_invoices
6662: WHERE invoice_id = p_invoice_id;
6663:
6664: EXCEPTION
6665: WHEN OTHERS THEN

Line 6755: P_Invoice_Line_Rec IN AP_INVOICES_PKG.r_invoice_line_rec,

6751:
6752:
6753: FUNCTION Gen_Dists_From_Registration(
6754: P_Batch_Id IN NUMBER,
6755: P_Invoice_Line_Rec IN AP_INVOICES_PKG.r_invoice_line_rec,
6756: P_Registration_Api IN VARCHAR2,
6757: P_Registration_View IN VARCHAR2,
6758: P_Generate_Permanent IN VARCHAR2,
6759: X_Error_Code OUT NOCOPY VARCHAR2,

Line 7073: TYPE invoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type INDEX BY BINARY_INTEGER;

7069:
7070: IS
7071:
7072: TYPE hold_codeTab IS TABLE OF ap_hold_codes.hold_lookup_code%Type;
7073: TYPE invoiceIDTab IS TABLE OF ap_invoices.invoice_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:

Line 7074: TYPE invoiceNUMTab IS TABLE OF ap_invoices.invoice_num%Type INDEX BY BINARY_INTEGER;

7070: IS
7071:
7072: TYPE hold_codeTab IS TABLE OF ap_hold_codes.hold_lookup_code%Type;
7073: TYPE invoiceIDTab IS TABLE OF ap_invoices.invoice_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;

Line 7075: TYPE procinvoiceIDTab IS TABLE OF ap_invoices.invoice_id%Type;

7071:
7072: TYPE hold_codeTab IS TABLE OF ap_hold_codes.hold_lookup_code%Type;
7073: TYPE invoiceIDTab IS TABLE OF ap_invoices.invoice_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;

Line 7076: TYPE hold_org_idTab IS TABLE OF ap_invoices.org_id%Type;

7072: TYPE hold_codeTab IS TABLE OF ap_hold_codes.hold_lookup_code%Type;
7073: TYPE invoiceIDTab IS TABLE OF ap_invoices.invoice_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:

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 7138: l_invoice_date AP_INVOICES.invoice_date%TYPE;

7134:
7135: l_retained_amount NUMBER;
7136: l_recouped_amount NUMBER;
7137: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
7138: l_invoice_date AP_INVOICES.invoice_date%TYPE;
7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;

Line 7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;

7135: l_retained_amount NUMBER;
7136: l_recouped_amount NUMBER;
7137: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
7138: l_invoice_date AP_INVOICES.invoice_date%TYPE;
7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;
7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;

Line 7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;

7136: l_recouped_amount NUMBER;
7137: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
7138: l_invoice_date AP_INVOICES.invoice_date%TYPE;
7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;
7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;

Line 7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;

7137: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
7138: l_invoice_date AP_INVOICES.invoice_date%TYPE;
7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;
7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;
7145:

Line 7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;

7138: l_invoice_date AP_INVOICES.invoice_date%TYPE;
7139: l_invoice_currency_code AP_INVOICES.invoice_currency_code%TYPE;
7140: l_exchange_rate AP_INVOICES.exchange_rate%TYPE;
7141: l_exchange_rate_type AP_INVOICES.exchange_rate_type%TYPE;
7142: l_exchange_date AP_INVOICES.exchange_date%TYPE;
7143: l_tolerance_id AP_SUPPLIER_SITES_ALL.TOLERANCE_ID%TYPE;
7144: l_services_tolerance_id AP_SUPPLIER_SITES_ALL.SERVICES_TOLERANCE_ID%TYPE;
7145:
7146: Tax_Exception EXCEPTION;

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 7226: UPDATE ap_invoices api

7222:
7223: ---------------------------------------------------------------------
7224: Print_Debug(l_api_name, 'Clean-up validation_request_id');
7225: ---------------------------------------------------------------------
7226: UPDATE ap_invoices api
7227: SET validation_request_id = NULL
7228: WHERE validation_request_id IS NOT NULL
7229: AND EXISTS
7230: ( SELECT 'Request Completed'

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 8392: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;

8388: p_calling_sequence IN VARCHAR2,
8389: x_error_code IN VARCHAR2,
8390: p_calling_mode IN VARCHAR2 ) IS /*bug 6833543 - added p_calling_mode*/
8391:
8392: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
8393:
8394: l_curr_calling_sequence VARCHAR2(2000);
8395: l_debug_info VARCHAR2(2000);
8396: l_debug_loc VARCHAR2(30) := 'Generate_Distributions';

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 8753: l_retained_amount := nvl(ap_invoices_utility_pkg.get_retained_total(p_invoice_rec.invoice_id, null),0);

8749: END IF;
8750: END IF;
8751: END LOOP;
8752:
8753: l_retained_amount := nvl(ap_invoices_utility_pkg.get_retained_total(p_invoice_rec.invoice_id, null),0);
8754:
8755: IF l_retained_amount <> 0 THEN
8756:
8757: ----------------------------------------------------------------

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)