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_PREPAY_APP_DISTS

Line 114: FROM AP_Prepay_App_Dists APAD,

110: THEN
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:

Line 386: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;

382: l_dist_count_per_event NUMBER;
383:
384:
385:
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;

Line 387: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

383:
384:
385:
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:

Line 574: FROM AP_Prepay_App_Dists APAD,

570: -- independent of accounting events
571: --
572: SELECT SUM(APAD.Base_Amount)
573: INTO l_sum_prepay_base_amt
574: FROM AP_Prepay_App_Dists APAD,
575: AP_Prepay_History_All APH
576: WHERE ((APAD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
577: AND APAD.Prepay_Dist_Lookup_Code IN ('PREPAY APPL', 'PREPAY APPL REC TAX',
578: 'PREPAY APPL NONREC TAX'))

Line 654: FROM AP_Prepay_App_Dists APAD

650: -- Get the prepay appl pay dists info for this distribution
651: --bug 7614480
652: /* SELECT APAD.*
653: INTO l_max_prepay_rec
654: FROM AP_Prepay_App_Dists APAD
655: WHERE APAD.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
656: AND APAD.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
657: AND APAD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
658: AND Rownum = 1;*/

Line 2645: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;

2641: l_td_diff_prepay_rate_amt NUMBER;
2642: l_td_diff_prepay_pay_rate_amt NUMBER;
2643: l_td_diff_prepay_clr_rate_amt NUMBER;
2644:
2645: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2646: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2647:
2648: -- Logging Infra:
2649: l_procedure_name CONSTANT VARCHAR2(30) := 'Total_Appl';

Line 2646: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

2642: l_td_diff_prepay_pay_rate_amt NUMBER;
2643: l_td_diff_prepay_clr_rate_amt NUMBER;
2644:
2645: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2646: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2647:
2648: -- Logging Infra:
2649: l_procedure_name CONSTANT VARCHAR2(30) := 'Total_Appl';
2650: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 2667: FROM AP_Prepay_App_Dists APAD

2663: -- Get the max of the largest distribution for inserting the rounding line
2664: BEGIN
2665: SELECT APAD.*
2666: INTO l_max_prepay_rec
2667: FROM AP_Prepay_App_Dists APAD
2668: WHERE Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
2669: AND APAD.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
2670: AND Invoice_Distribution_ID =
2671: (SELECT MAX(APAD1.Invoice_Distribution_ID)

Line 2672: FROM AP_Prepay_App_Dists APAD1

2668: WHERE Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
2669: AND APAD.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
2670: AND Invoice_Distribution_ID =
2671: (SELECT MAX(APAD1.Invoice_Distribution_ID)
2672: FROM AP_Prepay_App_Dists APAD1
2673: WHERE APAD1.Prepay_App_Distribution_ID =
2674: p_prepay_dist_rec.invoice_distribution_id
2675: AND APAD1.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
2676: AND ABS(APAD1.Amount) =

Line 2678: FROM AP_Prepay_App_Dists APAD2

2674: p_prepay_dist_rec.invoice_distribution_id
2675: AND APAD1.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
2676: AND ABS(APAD1.Amount) =
2677: (SELECT MAX(ABS(APAD2.Amount))
2678: FROM AP_Prepay_App_Dists APAD2
2679: WHERE APAD2.Prepay_App_Distribution_ID =
2680: p_prepay_dist_rec.invoice_distribution_id
2681: AND APAD2.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id))
2682: AND Rownum = 1;

Line 2805: FROM AP_Prepay_App_Dists APAD

2801: l_td_sum_inv_rate_amt,
2802: l_td_sum_prepay_rate_amt,
2803: l_td_sum_prepay_pay_rate_amt,
2804: l_td_sum_prepay_clr_rate_amt
2805: FROM AP_Prepay_App_Dists APAD
2806: WHERE APAD.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id;
2807:
2808:
2809: /* If there is difference between the total and sum amounts then we will insert the

Line 2837: UPDATE AP_Prepay_App_Dists APPD

2833: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2834: END IF;
2835:
2836:
2837: UPDATE AP_Prepay_App_Dists APPD
2838: SET Base_Amount = Base_Amount + NVL(l_diff_inv_rate_amt,0),
2839: Rounding_Amt = l_diff_inv_rate_amt,
2840: Base_Amt_At_Prepay_XRate = Base_Amt_At_Prepay_XRate
2841: + NVL(l_diff_prepay_rate_amt,0),

Line 2875: UPDATE AP_Prepay_App_Dists APPD

2871: l_log_msg := 'Updating tax diff rounding amount';
2872: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
2873: END IF;
2874:
2875: UPDATE AP_Prepay_App_Dists APPD
2876: SET Base_Amount = Base_Amount + NVL(l_td_diff_inv_rate_amt,0),
2877: Rounding_Amt = l_td_diff_inv_rate_amt,
2878: Base_Amt_At_Prepay_XRate = Base_Amt_At_Prepay_XRate
2879: + NVL(l_td_diff_prepay_rate_amt,0),

Line 2956: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;

2952: l_diff_prepay_rate_amt NUMBER;
2953: l_diff_prepay_pay_rate_amt NUMBER;
2954: l_diff_prepay_clr_rate_amt NUMBER;
2955:
2956: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2957: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2958:
2959: -- Logging Infra:
2960: l_procedure_name CONSTANT VARCHAR2(30) := 'Final_Appl';

Line 2957: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;

2953: l_diff_prepay_pay_rate_amt NUMBER;
2954: l_diff_prepay_clr_rate_amt NUMBER;
2955:
2956: l_max_prepay_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2957: l_pad_rec AP_PREPAY_APP_DISTS%ROWTYPE;
2958:
2959: -- Logging Infra:
2960: l_procedure_name CONSTANT VARCHAR2(30) := 'Final_Appl';
2961: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 3013: FROM AP_Prepay_App_Dists APAD

3009: -- Getting the max of the largest distribution for inserting the rounding dist
3010: BEGIN
3011: SELECT APAD.*
3012: INTO l_max_prepay_rec
3013: FROM AP_Prepay_App_Dists APAD
3014: WHERE Invoice_Distribution_ID IN
3015: (SELECT MAX(APAD1.Invoice_Distribution_ID)
3016: FROM AP_Prepay_App_Dists APAD1
3017: WHERE APAD1.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id

Line 3016: FROM AP_Prepay_App_Dists APAD1

3012: INTO l_max_prepay_rec
3013: FROM AP_Prepay_App_Dists APAD
3014: WHERE Invoice_Distribution_ID IN
3015: (SELECT MAX(APAD1.Invoice_Distribution_ID)
3016: FROM AP_Prepay_App_Dists APAD1
3017: WHERE APAD1.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
3018: AND APAD1.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
3019: AND ABS(APAD1.Amount) =
3020: (SELECT MAX(ABS(APAD2.Amount))

Line 3021: FROM AP_Prepay_App_Dists APAD2

3017: WHERE APAD1.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
3018: AND APAD1.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id
3019: AND ABS(APAD1.Amount) =
3020: (SELECT MAX(ABS(APAD2.Amount))
3021: FROM AP_Prepay_App_Dists APAD2
3022: WHERE APAD2.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
3023: AND APAD2.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id))
3024: AND APAD.Prepay_App_Distribution_ID = p_prepay_dist_rec.invoice_distribution_id
3025: AND APAD.Prepay_History_ID = p_prepay_hist_rec.prepay_history_id

Line 3095: FROM AP_Prepay_App_Dists

3091: SUM(Base_Amt_At_Prepay_Clr_XRate)
3092: INTO l_sum_prepay_rate_amt,
3093: l_sum_prepay_pay_rate_amt,
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);