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_INVOICES_ALL

Line 966: FROM ap_invoices_all ai,

962: ail.line_number,
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

Line 1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;

1410:
1411: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1412:
1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

Line 1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

1411: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1412:
1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

Line 1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;

1412:
1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

Line 1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;

1413: -- Standard Invoice Related Variables
1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

Line 1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

1414: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:

Line 1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

1415: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables

Line 1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

1416: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

Line 1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

1417: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1418: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1419: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;

Line 1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

1420: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

Line 1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;

1421: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

Line 1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;

1422:
1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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;

Line 1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

1423: -- Prepayment Invoice Related Variables
1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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:

Line 1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

1424: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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

Line 1429: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

1425: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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;

Line 1430: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

1426: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1427: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1428: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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;

Line 1448: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;

1444:
1445: -- Prepayment Payment Related Variables
1446: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1447: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1448: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1450:
1451: -- Other Prepayment Application Related Variables
1452: l_apply_amount NUMBER := p_apply_amount;

Line 4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

4538: IS
4539:
4540: -- Prepayment Invoice Related Variables
4541:
4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
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;

Line 4543: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

4539:
4540: -- Prepayment Invoice Related Variables
4541:
4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
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;

Line 4544: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

4540: -- Prepayment Invoice Related Variables
4541:
4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
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;

Line 4545: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

4541:
4542: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
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);