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

Line 241: ap_invoice_distributions_all aid

237: cv_prepay_line_num NUMBER)
238: IS
239: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
240: FROM ap_invoice_lines_all ail,
241: ap_invoice_distributions_all aid
242: WHERE ail.invoice_id = cv_prepay_invoice_id
243: AND ail.line_number = cv_prepay_line_num
244: AND NVL(ail.line_selected_for_appl_flag,'N') <> 'Y'
245: AND aid.invoice_id = ail.invoice_id

Line 290: ap_invoice_distributions_all aid

286: (cv_prepay_invoice_id NUMBER)
287: IS
288: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
289: FROM ap_invoice_lines_all ail,
290: ap_invoice_distributions_all aid
291: WHERE ail.invoice_id = cv_prepay_invoice_id
292: AND ail.line_type_lookup_code <> 'TAX'
293: AND NVL(ail.line_selected_for_appl_flag,'N') <> 'Y'
294: AND aid.invoice_id = ail.invoice_id

Line 793: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

789: -- there is no need to verify the payment_status flag.
790:
791: SELECT SUM(NVL(aid.amount,0))
792: INTO l_invoice_amount_remaining
793: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
794: WHERE ail.invoice_id = p_invoice_id
795: AND ail.invoice_id = aid.invoice_id
796: AND ail.line_number = aid.invoice_line_number
797: --Contract Payments: Although Recoupment is modelled as 'PREPAY' dists

Line 820: ap_invoice_distributions_all aid

816: -- Get the Prepay Amount Remaining
817: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
818: INTO l_prepay_amount_remaining
819: FROM ap_invoice_lines_all ail,
820: ap_invoice_distributions_all aid
821: WHERE ail.invoice_id = p_prepay_invoice_id
822: AND ail.line_number = p_prepay_line_num
823: AND ail.line_type_lookup_code = 'ITEM'
824: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 858: ap_invoice_distributions_all aid

854: -- Get the Prepay Amount Remaining
855: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
856: INTO l_prepay_amount_remaining
857: FROM ap_invoice_lines_all ail,
858: ap_invoice_distributions_all aid
859: WHERE ail.invoice_id = p_prepay_invoice_id
860: AND ail.line_type_lookup_code = 'ITEM'
861: AND NVL(ail.discarded_flag,'N') <> 'Y'
862: AND NVL(ail.line_selected_for_appl_flag, 'N') <> 'Y'

Line 1472: ap_invoice_distributions_all.distribution_line_number%TYPE;

1468:
1469: -- PREPAY distributions related variables
1470: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1471: l_max_dist_number
1472: ap_invoice_distributions_all.distribution_line_number%TYPE;
1473: l_loop_counter BINARY_INTEGER := 1;
1474: l_loop_variable BINARY_INTEGER;
1475: l_dist_line_counter NUMBER := 1;
1476: l_prepay_dist_s_quant_invoiced

Line 1477: ap_invoice_distributions_all.quantity_invoiced%TYPE;

1473: l_loop_counter BINARY_INTEGER := 1;
1474: l_loop_variable BINARY_INTEGER;
1475: l_dist_line_counter NUMBER := 1;
1476: l_prepay_dist_s_quant_invoiced
1477: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1478: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1479: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1480:
1481: l_debug_info VARCHAR2(4000);

Line 1478: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;

1474: l_loop_variable BINARY_INTEGER;
1475: l_dist_line_counter NUMBER := 1;
1476: l_prepay_dist_s_quant_invoiced
1477: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1478: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1479: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1480:
1481: l_debug_info VARCHAR2(4000);
1482: l_current_calling_sequence VARCHAR2(2000);

Line 1479: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;

1475: l_dist_line_counter NUMBER := 1;
1476: l_prepay_dist_s_quant_invoiced
1477: ap_invoice_distributions_all.quantity_invoiced%TYPE;
1478: l_prepay_dist_s_pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE;
1479: l_prepay_dist_s_stat_amount ap_invoice_distributions_all.stat_amount%TYPE;
1480:
1481: l_debug_info VARCHAR2(4000);
1482: l_current_calling_sequence VARCHAR2(2000);
1483:

Line 2489: FROM ap_invoice_distributions_all aid

2485: BEGIN
2486:
2487: SELECT SUM(NVL(aid.prepay_tax_diff_amount, 0))
2488: INTO l_prepay_tax_diff_amt
2489: FROM ap_invoice_distributions_all aid
2490: WHERE aid.invoice_id = p_invoice_id
2491: AND aid.invoice_line_number = l_prepay_ln_number
2492: AND aid.line_type_lookup_code = 'NONREC_TAX'
2493: AND NVL(aid.reversal_flag,'N') <> 'Y';

Line 2629: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

2625: -- ==========================================================
2626: --Bug5224883
2627: -- Get the exculusive tax amount for the prepay appln line.
2628: SELECT sum(aid.amount) into l_prepay_excl_tax_amt
2629: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
2630: WHERE ail.line_type_lookup_code='TAX'
2631: AND ail.invoice_id=p_invoice_id
2632: and aid.invoice_id=ail.invoice_id
2633: AND aid.invoice_line_number=ail.line_number

Line 2635: AND exists( select 1 from ap_invoice_distributions_all aid1

2631: AND ail.invoice_id=p_invoice_id
2632: and aid.invoice_id=ail.invoice_id
2633: AND aid.invoice_line_number=ail.line_number
2634: AND ail.prepay_line_number is not null
2635: AND exists( select 1 from ap_invoice_distributions_all aid1
2636: where aid1.invoice_id=p_invoice_id
2637: and aid1.invoice_line_number=l_prepay_ln_number
2638: and aid1.invoice_distribution_id=aid.charge_applicable_to_dist_id);
2639: -- Bug 5307022. Added the NVL for amount calculation in case of non exclusive tax

Line 3229: l_global_attr_category ap_invoice_distributions_all.global_attribute_category%TYPE;

3225: RETURN BOOLEAN IS
3226:
3227: l_loop_counter BINARY_INTEGER;
3228: l_invoice_distribution_id NUMBER;
3229: l_global_attr_category ap_invoice_distributions_all.global_attribute_category%TYPE;
3230: l_result BOOLEAN;
3231: l_debug_info VARCHAR2(100);
3232: l_calling_sequence VARCHAR2(2000);
3233: l_calling_program VARCHAR2(1000);

Line 3802: FROM ap_invoice_distributions_all

3798:
3799: CURSOR C_Update_Prepayments IS
3800: SELECT prepay_distribution_id,
3801: ABS(amount)
3802: FROM ap_invoice_distributions_all
3803: WHERE invoice_id = p_invoice_id
3804: AND invoice_line_number = p_invoice_line_num
3805: AND NVL(reversal_flag,'N') = 'Y'
3806: AND parent_reversal_id IS NOT NULL;

Line 3870: UPDATE ap_invoice_distributions_all dp

3866: -- we will not maintain the prepay_amount_Remaining at that level.
3867:
3868: -- Exclusive Tax Distributions
3869: BEGIN
3870: UPDATE ap_invoice_distributions_all dp
3871: SET dp.prepay_amount_remaining =
3872: (SELECT SUM(NVL(dp.prepay_amount_remaining, dp.total_dist_amount) +
3873: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
3874: FROM ap_invoice_distributions_all ds

Line 3874: FROM ap_invoice_distributions_all ds

3870: UPDATE ap_invoice_distributions_all dp
3871: SET dp.prepay_amount_remaining =
3872: (SELECT SUM(NVL(dp.prepay_amount_remaining, dp.total_dist_amount) +
3873: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
3874: FROM ap_invoice_distributions_all ds
3875: WHERE ds.prepay_distribution_id = dp.invoice_distribution_id)
3876: WHERE dp.invoice_id = p_prepay_invoice_id
3877: AND dp.line_type_lookup_code IN ('REC_TAX','NONREC_TAX')
3878: AND exists (select 'Exclusive Prepay Tax Line'

Line 3891: UPDATE ap_invoice_distributions_all dp

3887: END;
3888:
3889: -- Inclusive Tax Distributions
3890: BEGIN
3891: UPDATE ap_invoice_distributions_all dp
3892: SET dp.prepay_amount_remaining = NVL(dp.prepay_amount_remaining, dp.total_dist_amount) + /*Bug 7372625*/
3893: (SELECT SUM(/*NVL(dp.prepay_amount_remaining, dp.total_dist_amount) +*/
3894: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
3895: FROM ap_invoice_distributions_all ds

Line 3895: FROM ap_invoice_distributions_all ds

3891: UPDATE ap_invoice_distributions_all dp
3892: SET dp.prepay_amount_remaining = NVL(dp.prepay_amount_remaining, dp.total_dist_amount) + /*Bug 7372625*/
3893: (SELECT SUM(/*NVL(dp.prepay_amount_remaining, dp.total_dist_amount) +*/
3894: (NVL(ds.amount, 0) + NVL(ds.prepay_tax_diff_amount, 0)))
3895: FROM ap_invoice_distributions_all ds
3896: WHERE ds.prepay_distribution_id = dp.invoice_distribution_id)
3897: WHERE dp.invoice_id = p_prepay_invoice_id
3898: AND dp.invoice_line_number = p_prepay_line_num
3899: AND dp.line_type_lookup_code IN ('REC_TAX','NONREC_TAX');