DBA Data[Home] [Help]

APPS.AP_PREPAY_PKG dependencies on AP_INVOICE_LINES_ALL

Line 240: FROM ap_invoice_lines_all ail,

236: (cv_prepay_invoice_id NUMBER,
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'

Line 289: FROM ap_invoice_lines_all ail,

285: CURSOR C_Check_No_Apply_Inv_Amount
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'

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 819: FROM ap_invoice_lines_all ail,

815:
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'

Line 857: FROM ap_invoice_lines_all ail,

853:
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'

Line 967: ap_invoice_lines_all ail

963: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
964: (ail.invoice_id,
965: ail.line_number)
966: FROM ap_invoices_all ai,
967: ap_invoice_lines_all ail
968: WHERE ai.invoice_id = cv_prepay_invoice_id
969: AND ail.invoice_id = ai.invoice_id
970: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
971: (ail.invoice_id,

Line 1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;

1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1431:
1432: -- Prepayment Line Related Variables
1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

Line 1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1431:
1432: -- Prepayment Line Related Variables
1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

Line 1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1432: -- Prepayment Line Related Variables
1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;

Line 1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1433: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;

Line 1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1434: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;

Line 1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

1435: l_ppay_ln_amount_remaining NUMBER;
1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;

Line 1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;

1436: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:

Line 1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;

1437: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:
1445: -- Prepayment Payment Related Variables

Line 1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;

1438: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1439: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1440: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1441: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1442: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1443: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1444:
1445: -- Prepayment Payment Related Variables
1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;

Line 1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

1456: l_result BOOLEAN;
1457: l_calling_program VARCHAR2(1000);
1458:
1459: -- PREPAY LINE related variables
1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;

Line 1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1457: l_calling_program VARCHAR2(1000);
1458:
1459: -- PREPAY LINE related variables
1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

Line 1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1458:
1459: -- PREPAY LINE related variables
1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

Line 1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1459: -- PREPAY LINE related variables
1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

Line 1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;

1460: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:

Line 1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1461: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:
1469: -- PREPAY distributions related variables

Line 1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1462: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:
1469: -- PREPAY distributions related variables
1470: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;

Line 1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1463: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1464: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1465: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1466: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1467: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1468:
1469: -- PREPAY distributions related variables
1470: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1471: l_max_dist_number

Line 1484: l_inclusive_tax_amount ap_invoice_lines_all.included_tax_amount%TYPE;

1480:
1481: l_debug_info VARCHAR2(4000);
1482: l_current_calling_sequence VARCHAR2(2000);
1483:
1484: l_inclusive_tax_amount ap_invoice_lines_all.included_tax_amount%TYPE;
1485: l_apply_amount_no_tax_incl NUMBER;
1486: l_ppay_ln_amt_remaining_no_tax NUMBER;
1487: l_prepay_tax_diff_amt NUMBER;
1488:

Line 1489: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;

1485: l_apply_amount_no_tax_incl NUMBER;
1486: l_ppay_ln_amt_remaining_no_tax NUMBER;
1487: l_prepay_tax_diff_amt NUMBER;
1488:
1489: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1490:
1491: l_api_name VARCHAR2(50);
1492:
1493: tax_exception EXCEPTION;

Line 1985: FROM ap_invoice_lines_all

1981:
1982: BEGIN
1983: SELECT NVL(included_tax_amount, 0)
1984: INTO l_inclusive_tax_amount
1985: FROM ap_invoice_lines_all
1986: WHERE invoice_id = p_invoice_id
1987: AND line_number = l_prepay_ln_number;
1988:
1989: EXCEPTION

Line 2531: UPDATE ap_invoice_lines_all ail

2527: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2528: END IF;
2529:
2530: BEGIN
2531: UPDATE ap_invoice_lines_all ail
2532: SET amount = l_apply_amount,
2533: base_amount = l_prepay_ln_base_amount
2534: WHERE ail.invoice_id = p_invoice_id
2535: AND ail.line_number = l_prepay_ln_number;

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 4547: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;

4543: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4546: l_ppay_apply_amt_in_pay_curr NUMBER;
4547: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;
4548: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;
4549: l_debug_info VARCHAR2(100);
4550: l_current_calling_sequence VARCHAR2(2000);
4551: l_calling_program VARCHAR2(1000);