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 967: l_invoice_currency_code ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE; -- Bug 6394865

963: l_loop_counter BINARY_INTEGER := 1;
964: l_request_id NUMBER := p_request_id;
965: l_is_line_locked VARCHAR2(100);
966: l_lock_result BOOLEAN;
967: l_invoice_currency_code ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE; -- Bug 6394865
968: l_payment_currency_code ap_invoices_all.PAYMENT_CURRENCY_CODE%TYPE; -- Bug 6394865
969:
970: CURSOR C_INV_LEVEL_APPLY (cv_prepay_invoice_id IN NUMBER)
971: IS

Line 968: l_payment_currency_code ap_invoices_all.PAYMENT_CURRENCY_CODE%TYPE; -- Bug 6394865

964: l_request_id NUMBER := p_request_id;
965: l_is_line_locked VARCHAR2(100);
966: l_lock_result BOOLEAN;
967: l_invoice_currency_code ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE; -- Bug 6394865
968: l_payment_currency_code ap_invoices_all.PAYMENT_CURRENCY_CODE%TYPE; -- Bug 6394865
969:
970: CURSOR C_INV_LEVEL_APPLY (cv_prepay_invoice_id IN NUMBER)
971: IS
972: SELECT ai.invoice_id,

Line 977: FROM ap_invoices_all ai,

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

Line 992: cv_invoice_currency_code IN ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE,

988: -- The application is based only in ITEM lines. No TAX
989: -- lines should be included
990:
991: CURSOR C_VND_LEVEL_APPLY (cv_vendor_id IN NUMBER,
992: cv_invoice_currency_code IN ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE,
993: cv_payment_currency_code IN ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE)
994: -- Bug 6394865
995: IS
996: SELECT ai.invoice_id,

Line 993: cv_payment_currency_code IN ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE)

989: -- lines should be included
990:
991: CURSOR C_VND_LEVEL_APPLY (cv_vendor_id IN NUMBER,
992: cv_invoice_currency_code IN ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE,
993: cv_payment_currency_code IN ap_invoices_all.INVOICE_CURRENCY_CODE%TYPE)
994: -- Bug 6394865
995: IS
996: SELECT ai.invoice_id,
997: ail.line_number,

Line 1436: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;

1432:
1433: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1434:
1435: -- Standard Invoice Related Variables
1436: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1437: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1438: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

Line 1437: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

1433: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1434:
1435: -- Standard Invoice Related Variables
1436: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1437: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1438: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1441: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

Line 1438: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;

1434:
1435: -- Standard Invoice Related Variables
1436: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1437: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1438: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1441: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1442: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

Line 1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;

1435: -- Standard Invoice Related Variables
1436: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1437: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1438: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1441: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1442: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1443: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

Line 1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

1436: l_std_inv_batch_id ap_invoices_all.batch_id%TYPE;
1437: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1438: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1441: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1442: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1443: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1444:

Line 1441: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

1437: l_std_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1438: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1441: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1442: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1443: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1444:
1445: -- Prepayment Invoice Related Variables

Line 1442: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

1438: l_std_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1441: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1442: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1443: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1444:
1445: -- Prepayment Invoice Related Variables
1446: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

Line 1443: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

1439: l_std_inv_xdate ap_invoices_all.exchange_date%TYPE;
1440: l_std_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1441: l_std_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1442: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1443: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1444:
1445: -- Prepayment Invoice Related Variables
1446: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1447: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;

Line 1446: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

1442: l_std_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;
1443: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1444:
1445: -- Prepayment Invoice Related Variables
1446: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1447: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1448: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1450: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

Line 1447: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;

1443: l_std_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;
1444:
1445: -- Prepayment Invoice Related Variables
1446: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1447: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1448: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1450: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;
1451: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

Line 1448: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;

1444:
1445: -- Prepayment Invoice Related Variables
1446: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1447: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1448: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1450: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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;

Line 1449: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;

1445: -- Prepayment Invoice Related Variables
1446: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1447: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1448: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1450: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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:

Line 1450: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

1446: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
1447: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1448: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1450: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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

Line 1451: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

1447: l_ppay_inv_xrate ap_invoices_all.exchange_rate%TYPE;
1448: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1450: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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;

Line 1452: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

1448: l_ppay_inv_xdate ap_invoices_all.exchange_date%TYPE;
1449: l_ppay_inv_xrate_type ap_invoices_all.exchange_rate_type%TYPE;
1450: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%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;

Line 1470: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;

1466:
1467: -- Prepayment Payment Related Variables
1468: l_ppay_pay_curr_code ap_checks_all.currency_code%TYPE;
1469: l_ppay_pay_xrate ap_checks_all.exchange_rate%TYPE;
1470: l_ppay_pay_xdate ap_invoices_all.exchange_date%TYPE;
1471: l_ppay_pay_xrate_type ap_checks_all.exchange_rate_type%TYPE;
1472:
1473: -- Other Prepayment Application Related Variables
1474: l_apply_amount NUMBER := p_apply_amount;

Line 4459: ap_invoices_all ai

4455: (ai.invoice_amount - nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)) - aps.amount_remaining),/*Bug10012482*/
4456: aps.amount_remaining),
4457: ai.invoice_amount /*Bug10012482*/
4458: FROM ap_payment_schedules aps,
4459: ap_invoices_all ai
4460: WHERE ai.invoice_id = aps.invoice_id
4461: AND ai.invoice_id = p_invoice_id
4462: AND (aps.payment_status_flag||'' = 'P'
4463: OR aps.payment_status_flag||'' = DECODE(p_appl_type, 'UNAPPLICATION', 'Y', 'N'))

Line 4760: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;

4756: IS
4757:
4758: -- Prepayment Invoice Related Variables
4759:
4760: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
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;

Line 4761: l_ppay_inv_pay_curr_code ap_invoices_all.payment_currency_code%TYPE;

4757:
4758: -- Prepayment Invoice Related Variables
4759:
4760: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
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;

Line 4762: l_ppay_inv_pay_cross_rate_date ap_invoices_all.payment_cross_rate_date%TYPE;

4758: -- Prepayment Invoice Related Variables
4759:
4760: l_ppay_inv_curr_code ap_invoices_all.invoice_currency_code%TYPE;
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;

Line 4763: l_ppay_inv_pay_cross_rate_type ap_invoices_all.payment_cross_rate_type%TYPE;

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