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_ACCTG_PAY_ROUND_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 44: l_max_prepay_app_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE; --bug 7614480

40:
41: -- bug 6600341
42: l_acctg_event_id XLA_EVENTS.EVENT_ID%TYPE;
43: exec_final_payment VARCHAR2(1); --bug 7614480
44: l_max_prepay_app_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE; --bug 7614480
45:
46: BEGIN
47:
48: l_curr_calling_sequence := 'AP_Acctg_Pay_Round_Pkg.Do_Rounding<- ' ||

Line 115: AP_Invoice_Distributions_All AID

111: /* Get the prepayment app dists amount that has already been accounted */
112: SELECT SUM(-1 * APAD.Amount)
113: INTO l_prepay_acctg_amt
114: FROM AP_Prepay_App_Dists APAD,
115: AP_Invoice_Distributions_All AID
116: WHERE APAD.Prepay_App_Distribution_ID = AID.Invoice_Distribution_ID
117: AND AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id;
118:
119:

Line 122: FROM AP_Invoice_Distributions_All AID

118:
119:
120: SELECT AID.Amount
121: INTO l_prepay_amt
122: FROM AP_Invoice_Distributions_All AID
123: WHERE AID.Invoice_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id;
124:
125:
126: -- Check for final application rounding only if this prepayment has been

Line 336: FROM AP_Invoice_Distributions_All AID,

332: AID.Base_Amount,
333: AID.Invoice_Id,
334: AID.accounting_event_id,
335: AID.historical_flag
336: FROM AP_Invoice_Distributions_All AID,
337: Financials_System_Params_All FSP
338: WHERE AID.Invoice_ID = p_invoice_id
339: AND AID.Line_Type_Lookup_Code NOT IN ('PREPAY', 'AWT', 'ERV', 'TERV')
340: AND AID.Prepay_Distribution_ID IS NULL

Line 367: FROM ap_invoice_distributions_all aid,

363: -- event is an adjustment event with a net balance 0
364: -- under no liability posting method.
365: CURSOR c_sum_per_event(p_acct_event_id NUMBER) IS
366: SELECT SUM(amount), count(1)
367: FROM ap_invoice_distributions_all aid,
368: xla_events evnt,
369: ap_system_parameters_all asp
370: WHERE aid.accounting_event_id = p_acct_event_id
371: AND aid.accounting_event_id = evnt.event_id

Line 390: l_erv_base_amount AP_INVOICE_DISTRIBUTIONS_ALL.base_amount%type := 0;

386: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
387: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
388: l_max_pay_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
389: l_pd_rec AP_PAYMENT_HIST_DISTS%ROWTYPE;
390: l_erv_base_amount AP_INVOICE_DISTRIBUTIONS_ALL.base_amount%type := 0;
391:
392: -- Logging Infra:
393: l_procedure_name CONSTANT VARCHAR2(30) := 'Final_Pay';
394: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 584: FROM Ap_Invoice_Distributions_All AID

580: AND APAD.Prepay_Dist_Lookup_Code = 'AWT'))
581: AND APH.Invoice_ID = p_inv_rec.invoice_id
582: AND APH.Prepay_History_ID = APAD.Prepay_History_ID
583: AND NOT EXISTS (SELECT 'reversed'
584: FROM Ap_Invoice_Distributions_All AID
585: WHERE APAD.Prepay_App_Distribution_ID =
586: AID.Invoice_Distribution_ID
587: AND AID.reversal_flag = 'Y');
588:

Line 613: FROM ap_invoice_distributions_all AID

609: BEGIN
610:
611: SELECT NVL(base_amount, 0)
612: INTO l_erv_base_amount
613: FROM ap_invoice_distributions_all AID
614: WHERE AID.line_type_lookup_code in ('ERV', 'TERV')
615: AND AID.invoice_id = l_inv_dist_rec.invoice_id
616: AND AID.related_id = l_inv_dist_rec.invoice_distribution_id;
617: EXCEPTION

Line 913: FROM AP_Invoice_Distributions_All AID

909: WHERE APHD1.Accounting_Event_ID = p_xla_event_rec.event_id
910: AND APHD1.Invoice_Payment_ID = p_inv_pay_rec.invoice_payment_id
911: AND APHD1.Invoice_Distribution_ID IN
912: (SELECT AID.Invoice_Distribution_ID
913: FROM AP_Invoice_Distributions_All AID
914: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)
915: AND APHD1.Pay_Dist_Lookup_Code not IN('AWT') --8727277
916: AND ABS(APHD1.Amount) =
917: (SELECT MAX(ABS(APHD2.Amount))

Line 923: FROM AP_Invoice_Distributions_All AID

919: WHERE APHD2.Accounting_Event_ID = p_xla_event_rec.event_id
920: AND APHD2.Invoice_Payment_ID = p_inv_pay_rec.invoice_payment_id
921: AND APHD2.Invoice_Distribution_ID IN
922: (SELECT AID.Invoice_Distribution_ID
923: FROM AP_Invoice_Distributions_All AID
924: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)
925: AND APHD2.Pay_Dist_Lookup_Code not IN('AWT') --8727277
926: ))
927: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id

Line 984: FROM AP_Invoice_Distributions_All AID

980: AND APHD.Invoice_Payment_ID = p_inv_pay_rec.Invoice_Payment_ID
981: AND APHD.Payment_History_ID = APH.Payment_History_ID
982: AND APHD.Invoice_Distribution_ID IN
983: (SELECT AID.Invoice_Distribution_ID
984: FROM AP_Invoice_Distributions_All AID
985: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
986:
987: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
988: l_log_msg := ' sum of the base amounts for each line type obtained';

Line 1043: FROM AP_Invoice_Distributions_All AID

1039: APHD.PAYMENT_HISTORY_ID =APH.PAYMENT_HISTORY_ID
1040: ANd APHD.INVOICE_PAYMENT_ID =p_inv_pay_rec.Invoice_Payment_ID --6614295
1041: AND APHD.Invoice_Distribution_ID IN
1042: (SELECT AID.Invoice_Distribution_ID
1043: FROM AP_Invoice_Distributions_All AID
1044: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
1045:
1046: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1047: l_log_msg := 'query to fetch the sum(amount) and sum(base_amount)' ||

Line 1195: in ap_invoice_distributions_all to balance them in respect to the header base amount.

1191: /* If the exchange rates between the invoice and payment are same then the base
1192: amounts and rounding between the invoice and payment should be same */
1193: /*Bug6600117
1194: The fractional rounding amount is added to the maximun distribution amount
1195: in ap_invoice_distributions_all to balance them in respect to the header base amount.
1196: Same is not done while calculating invoice_dist_Base_Amount in AP_Payment_Hist_Dists
1197: table.This is giving rise to the unbalance accounting entries in accounting journal*/
1198:
1199: IF (p_pay_hist_rec.pmt_to_base_xrate =

Line 2269: FROM AP_Invoice_Distributions_All AID

2265: AND APHD1.Invoice_Payment_ID = p_inv_pay_rec.invoice_payment_id
2266: AND APHD1.Rounding_Amt is NULL
2267: AND APHD1.Invoice_Distribution_ID IN
2268: (SELECT AID.Invoice_Distribution_ID
2269: FROM AP_Invoice_Distributions_All AID
2270: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)
2271: AND ABS(APHD1.Amount) =
2272: (SELECT MAX(ABS(APHD2.Amount))
2273: FROM AP_Payment_Hist_Dists APHD2

Line 2280: FROM AP_Invoice_Distributions_All AID

2276: p_inv_pay_rec.invoice_payment_id
2277: AND APHD2.Rounding_Amt is NULL
2278: AND APHD2.Invoice_Distribution_ID IN
2279: (SELECT AID.Invoice_Distribution_ID
2280: FROM AP_Invoice_Distributions_All AID
2281: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)))
2282: AND APHD.Rounding_Amt is NULL
2283: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id
2284: AND APHD.Invoice_Payment_ID = p_inv_pay_rec.invoice_payment_id

Line 2379: FROM AP_Invoice_Distributions_All AID

2375: WHERE APHD1.Accounting_Event_ID = p_xla_event_rec.event_id
2376: AND APHD1.Invoice_payment_id = P_Inv_Pay_Rec.Invoice_payment_id -- Bug 8722710
2377: AND APHD1.Invoice_Distribution_ID IN
2378: (SELECT AID.Invoice_Distribution_ID
2379: FROM AP_Invoice_Distributions_All AID
2380: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)
2381: AND ABS(APHD1.Amount) =
2382: (SELECT MAX(ABS(APHD2.Amount))
2383: FROM AP_Payment_Hist_Dists APHD2

Line 2388: FROM AP_Invoice_Distributions_All AID

2384: WHERE APHD2.Accounting_Event_ID = p_xla_event_rec.event_id
2385: AND APHD2.Invoice_payment_id = P_Inv_Pay_Rec.Invoice_payment_id -- Bug 8722710
2386: AND APHD2.Invoice_Distribution_ID IN
2387: (SELECT AID.Invoice_Distribution_ID
2388: FROM AP_Invoice_Distributions_All AID
2389: WHERE AID.Invoice_ID = p_inv_rec.invoice_id)))
2390: AND APHD.Accounting_Event_ID = p_xla_event_rec.event_id
2391: AND APHD.Invoice_payment_id = P_Inv_Pay_Rec.Invoice_payment_id -- Bug 8722710
2392: AND Rownum = 1;

Line 2412: FROM AP_Invoice_Distributions_All AID

2408: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')
2409: AND APHD.Invoice_payment_id = P_Inv_Pay_Rec.Invoice_payment_id -- Bug 8722710
2410: AND APHD.Invoice_Distribution_ID IN
2411: (SELECT AID.Invoice_Distribution_ID
2412: FROM AP_Invoice_Distributions_All AID
2413: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
2414:
2415:
2416: -- Get the paid base amounts for the payment maturity event

Line 2431: FROM AP_Invoice_Distributions_All AID

2427: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')
2428: AND APHD.Invoice_payment_id = P_Inv_Pay_Rec.Invoice_payment_id -- Bug 8722710
2429: AND APHD.Invoice_Distribution_ID IN
2430: (SELECT AID.Invoice_Distribution_ID
2431: FROM AP_Invoice_Distributions_All AID
2432: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
2433:
2434:
2435: -- Get the paid base amounts for the payment clearing event

Line 2455: FROM AP_Invoice_Distributions_All AID

2451: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')
2452: AND APHD.Invoice_payment_id = P_Inv_Pay_Rec.Invoice_payment_id -- Bug 8722710
2453: AND APHD.Invoice_Distribution_ID IN
2454: (SELECT AID.Invoice_Distribution_ID
2455: FROM AP_Invoice_Distributions_All AID
2456: WHERE AID.Invoice_ID = p_inv_rec.invoice_id);
2457:
2458: /* If there is any difference between the paid and maturity base amounts between
2459: this event and the prior event then we will insert the appropriate rounding

Line 3043: FROM AP_Invoice_Distributions_All AID

3039: WHERE APH.Related_Event_ID = p_pay_hist_rec.Related_Event_ID
3040: AND APHD.Payment_History_ID = APH.Payment_History_ID
3041: AND Invoice_Distribution_ID IN
3042: (SELECT AID.Invoice_Distribution_ID
3043: FROM AP_Invoice_Distributions_All AID
3044: WHERE AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id)
3045: AND Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT', 'TOTAL PAYMENT ROUNDING',
3046: 'FINAL PAYMENT ROUNDING');
3047:

Line 3057: FROM AP_Invoice_Distributions_All AID

3053: WHERE APH.Related_Event_ID = p_clr_hist_rec.related_event_id
3054: AND APHD.Payment_History_ID = APH.Payment_History_ID
3055: AND Invoice_Distribution_ID IN
3056: (SELECT AID.Invoice_Distribution_ID
3057: FROM AP_Invoice_Distributions_All AID
3058: WHERE AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id)
3059: AND Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT', 'TOTAL CLEARING ROUNDING',
3060: 'FINAL PAYMENT ROUNDING');
3061: */

Line 3098: FROM AP_Invoice_Distributions_All AID

3094: l_sum_prepay_clr_rate_amt
3095: FROM AP_Prepay_App_Dists
3096: WHERE Prepay_App_Distribution_ID IN
3097: (SELECT AID.Invoice_Distribution_ID
3098: FROM AP_Invoice_Distributions_All AID
3099: WHERE AID.Prepay_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id);
3100:
3101:
3102: -- bug9609272, added the corresponding ERV amount to the base amount of

Line 3108: FROM AP_Invoice_Distributions_All AID_erv

3104: -- rate), so as to get a sum as per the Prepayment Invoice Exchange Rate
3105: --
3106: SELECT AID.Base_Amount +
3107: NVL((SELECT SUM(NVL(AID_erv.Base_Amount, 0))
3108: FROM AP_Invoice_Distributions_All AID_erv
3109: WHERE AID_erv.Invoice_id = AID.Invoice_id
3110: AND AID_erv.line_type_lookup_code IN ('ERV', 'TERV')
3111: AND AID_erv.related_id = AID.invoice_distribution_id), 0)
3112: INTO l_sum_pay_base_amt

Line 3113: FROM AP_Invoice_Distributions_All AID

3109: WHERE AID_erv.Invoice_id = AID.Invoice_id
3110: AND AID_erv.line_type_lookup_code IN ('ERV', 'TERV')
3111: AND AID_erv.related_id = AID.invoice_distribution_id), 0)
3112: INTO l_sum_pay_base_amt
3113: FROM AP_Invoice_Distributions_All AID
3114: WHERE AID.Invoice_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id;
3115:
3116: l_diff_prepay_rate_amt := -(l_sum_pay_base_amt + l_sum_prepay_rate_amt); -- 8256981
3117: l_diff_prepay_pay_rate_amt := -(l_sum_pay_paid_base_amt + l_sum_prepay_pay_rate_amt); -- 8256981