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_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 794: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail

790:
791: /* Start of fix for bug8692604 */
792: /* SELECT SUM(NVL(aid.amount,0))
793: INTO l_invoice_amount_remaining
794: FROM ap_invoice_distributions_all aid, ap_invoice_lines_all ail
795: WHERE ail.invoice_id = p_invoice_id
796: AND ail.invoice_id = aid.invoice_id
797: AND ail.line_number = aid.invoice_line_number
798: --Contract Payments: Although Recoupment is modelled as 'PREPAY' dists

Line 813: from ap_invoice_lines_all

809: ); */
810:
811: select sum(nvl(amount,0))
812: into l_invoice_amount_remaining
813: from ap_invoice_lines_all
814: where invoice_id = p_invoice_id
815: and line_type_lookup_code <> 'PREPAY';
816: /* End of fix for bug8692604 */
817:

Line 827: FROM ap_invoice_lines_all ail,

823:
824: -- Get the Prepay Amount Remaining
825: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
826: INTO l_prepay_amount_remaining
827: FROM ap_invoice_lines_all ail,
828: ap_invoice_distributions_all aid
829: WHERE ail.invoice_id = p_prepay_invoice_id
830: AND ail.line_number = p_prepay_line_num
831: AND ail.line_type_lookup_code = 'ITEM'

Line 865: FROM ap_invoice_lines_all ail,

861:
862: -- Get the Prepay Amount Remaining
863: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
864: INTO l_prepay_amount_remaining
865: FROM ap_invoice_lines_all ail,
866: ap_invoice_distributions_all aid
867: WHERE ail.invoice_id = p_prepay_invoice_id
868: AND ail.line_type_lookup_code = 'ITEM'
869: AND NVL(ail.discarded_flag,'N') <> 'Y'

Line 978: ap_invoice_lines_all ail

974: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
975: (ail.invoice_id,
976: ail.line_number)
977: FROM ap_invoices_all ai,
978: ap_invoice_lines_all ail
979: WHERE ai.invoice_id = cv_prepay_invoice_id
980: AND ail.invoice_id = ai.invoice_id
981: AND AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
982: (ail.invoice_id,

Line 1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;

1451: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1452: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1453:
1454: -- Prepayment Line Related Variables
1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

Line 1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

1452: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1453:
1454: -- Prepayment Line Related Variables
1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

Line 1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1454: -- Prepayment Line Related Variables
1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;

Line 1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1455: l_ppay_ln_amount ap_invoice_lines_all.amount%TYPE;
1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;

Line 1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1456: l_ppay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;

Line 1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;

1457: l_ppay_ln_amount_remaining NUMBER;
1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;

Line 1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;

1458: l_ppay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:

Line 1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;

1459: l_ppay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:
1467: -- Prepayment Payment Related Variables

Line 1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;

1460: l_ppay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1461: l_ppay_ln_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
1462: l_ppay_ln_po_distribution_id ap_invoice_lines_all.po_distribution_id%TYPE;
1463: l_ppay_ln_rcv_transaction_id ap_invoice_lines_all.rcv_transaction_id%TYPE;
1464: l_ppay_ln_uom ap_invoice_lines_all.unit_meas_lookup_code%TYPE;
1465: l_ppay_ln_match_basis po_line_types.matching_basis%TYPE;
1466:
1467: -- Prepayment Payment Related Variables
1468: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;

Line 1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;

1478: l_result BOOLEAN;
1479: l_calling_program VARCHAR2(1000);
1480:
1481: -- PREPAY LINE related variables
1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;

Line 1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1479: l_calling_program VARCHAR2(1000);
1480:
1481: -- PREPAY LINE related variables
1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

Line 1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1480:
1481: -- PREPAY LINE related variables
1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

Line 1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1481: -- PREPAY LINE related variables
1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

Line 1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;

1482: l_prepay_ln_base_amount ap_invoice_lines_all.base_amount%TYPE;
1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1490:

Line 1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;

1483: l_prepay_ln_quantity_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1490:
1491: -- PREPAY distributions related variables

Line 1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;

1484: l_prepay_ln_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1490:
1491: -- PREPAY distributions related variables
1492: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;

Line 1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;

1485: l_prepay_ln_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1486: l_prepay_ln_number ap_invoice_lines_all.line_number%TYPE;
1487: l_prepay_ln_s_quant_invoiced ap_invoice_lines_all.quantity_invoiced%TYPE;
1488: l_prepay_ln_s_pa_quantity ap_invoice_lines_all.pa_quantity%TYPE;
1489: l_prepay_ln_s_stat_amount ap_invoice_lines_all.stat_amount%TYPE;
1490:
1491: -- PREPAY distributions related variables
1492: l_prepay_dist_info AP_PREPAY_PKG.PREPAY_DIST_TAB_TYPE;
1493: l_max_dist_number

Line 1506: l_inclusive_tax_amount ap_invoice_lines_all.included_tax_amount%TYPE;

1502:
1503: l_debug_info VARCHAR2(4000);
1504: l_current_calling_sequence VARCHAR2(2000);
1505:
1506: l_inclusive_tax_amount ap_invoice_lines_all.included_tax_amount%TYPE;
1507: l_apply_amount_no_tax_incl NUMBER;
1508: l_ppay_ln_amt_remaining_no_tax NUMBER;
1509: l_prepay_tax_diff_amt NUMBER;
1510:

Line 1511: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;

1507: l_apply_amount_no_tax_incl NUMBER;
1508: l_ppay_ln_amt_remaining_no_tax NUMBER;
1509: l_prepay_tax_diff_amt NUMBER;
1510:
1511: l_invoice_line_number ap_invoice_lines_all.line_number%TYPE;
1512:
1513: l_api_name VARCHAR2(50);
1514:
1515: tax_exception EXCEPTION;

Line 2065: FROM ap_invoice_lines_all

2061:
2062: BEGIN
2063: SELECT NVL(included_tax_amount, 0)
2064: INTO l_inclusive_tax_amount
2065: FROM ap_invoice_lines_all
2066: WHERE invoice_id = p_invoice_id
2067: AND line_number = l_prepay_ln_number;
2068:
2069: EXCEPTION

Line 2794: UPDATE ap_invoice_lines_all ail

2790: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2791: END IF;
2792:
2793: BEGIN
2794: UPDATE ap_invoice_lines_all ail
2795: SET amount = l_apply_amount,
2796: base_amount = l_prepay_ln_base_amount
2797: WHERE ail.invoice_id = p_invoice_id
2798: AND ail.line_number = l_prepay_ln_number;

Line 2892: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid

2888: -- ==========================================================
2889: --Bug5224883
2890: -- Get the exculusive tax amount for the prepay appln line.
2891: SELECT sum(aid.amount) into l_prepay_excl_tax_amt
2892: FROM ap_invoice_lines_all ail,ap_invoice_distributions_all aid
2893: WHERE ail.line_type_lookup_code='TAX'
2894: AND ail.invoice_id=p_invoice_id
2895: and aid.invoice_id=ail.invoice_id
2896: AND aid.invoice_line_number=ail.line_number

Line 4765: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;

4761: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
4762: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
4763: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
4764: l_ppay_apply_amt_in_pay_curr NUMBER;
4765: l_prepay_line_rec ap_invoice_lines_all%ROWTYPE;
4766: l_prepay_dist_info AP_PREPAY_PKG.prepay_dist_tab_type;
4767: l_debug_info VARCHAR2(4000); --Changed length from 100 to 4000 (8534097)
4768: l_current_calling_sequence VARCHAR2(2000);
4769: l_calling_program VARCHAR2(1000);