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.

[Home] [Help]

APPS.AP_PREPAY_PKG dependencies on AP_INVOICES

Line 36: FROM ap_invoices ai

32: cv_vendor_id NUMBER)
33: IS
34: SELECT DECODE(COUNT(*),
35: 0, 'INCONSISTENT PREPAY SUPPL', NULL)
36: FROM ap_invoices ai
37: WHERE ai.invoice_num = cv_prepay_num
38: AND ai.vendor_id = cv_vendor_id;
39:
40: BEGIN

Line 81: FROM ap_invoices ai

77: cv_invoice_currency_code VARCHAR2,
78: cv_payment_currency_code VARCHAR2) IS
79: SELECT DECODE(COUNT(*),
80: 0, 'INCONSISTENT PREPAY CURR', NULL)
81: FROM ap_invoices ai
82: WHERE invoice_num = cv_prepay_num
83: AND vendor_id = cv_vendor_id
84: AND cv_base_currency_code =
85: (SELECT base_currency_code

Line 141: FROM ap_invoices ai

137: END IF;
138:
139: SELECT count(*)
140: INTO l_count
141: FROM ap_invoices ai
142: WHERE ai.invoice_num = p_prepay_num
143: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
144: AND ai.payment_status_flag = 'Y'
145: AND ai.vendor_id = p_vendor_id

Line 160: FROM ap_invoices

156:
157: IF l_reject_code IS NULL THEN
158: SELECT invoice_id
159: INTO p_prepay_invoice_id
160: FROM ap_invoices
161: WHERE invoice_num = p_prepay_num
162: AND vendor_id = p_vendor_id;
163: END IF;
164:

Line 192: FROM ap_invoices ai,

188: cv_vendor_id NUMBER)
189: IS
190: SELECT DECODE(COUNT(*),
191: 0, 'INVALID PREPAY LINE NUM', NULL)
192: FROM ap_invoices ai,
193: ap_invoice_lines ail
194: WHERE ai.invoice_num = cv_prepay_num
195: AND ail.line_number = cv_prepay_line_num
196: AND ail.invoice_id = ai.invoice_id

Line 337: FROM ap_invoices ai,

333: CURSOR C_Check_No_Apply_Vendor_Amount
334: (cv_vendor_id NUMBER)
335: IS
336: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
337: FROM ap_invoices ai,
338: ap_invoice_lines ail,
339: ap_invoice_distributions aid
340: WHERE ai.vendor_id = cv_vendor_id
341: AND ai.invoice_type_lookup_code = 'PREPAYMENT'

Line 902: FROM ap_invoices ai,

898: 'VND_PREPAY_APPL_WITHOUT_AMOUNT_EXP') THEN
899: -- Get the Prepay Amount Remaining
900: SELECT SUM(NVL(aid.prepay_amount_remaining, aid.total_dist_amount))
901: INTO l_prepay_amount_remaining
902: FROM ap_invoices ai,
903: ap_invoice_lines ail,
904: ap_invoice_distributions aid
905: WHERE ai.vendor_id = p_vendor_id
906: AND ai.invoice_type_lookup_code = 'PREPAYMENT'

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 1001: FROM ap_invoices ai,

997: ail.line_number,
998: AP_Prepay_Utils_PKG.Get_Line_Prepay_AMT_Remaining
999: (ail.invoice_id,
1000: ail.line_number)
1001: FROM ap_invoices ai,
1002: ap_invoice_lines ail
1003: WHERE ai.vendor_id = cv_vendor_id
1004: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
1005: AND ai.payment_status_flag = 'Y'

Line 1108: from ap_invoices where invoice_id = p_invoice_id; -- Bug 6394865

1104: 'VND_PREPAY_APPL_WITHOUT_AMOUNT') THEN
1105:
1106: select invoice_currency_code, payment_currency_code
1107: into l_invoice_currency_code, l_payment_currency_code
1108: from ap_invoices where invoice_id = p_invoice_id; -- Bug 6394865
1109:
1110: OPEN C_VND_LEVEL_APPLY (p_vendor_id, l_invoice_currency_code,
1111: l_payment_currency_code); -- Bug 6394865
1112: LOOP

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 1535: FROM AP_Invoices

1531: exchange_rate_type,
1532: payment_currency_code,
1533: payment_cross_rate_date,
1534: payment_cross_rate_type
1535: FROM AP_Invoices
1536: WHERE invoice_id = CV_Std_Invoice_ID;
1537:
1538: CURSOR C_PPAY_INVOICE_INFO (CV_PPay_Invoice_ID IN NUMBER) IS
1539: SELECT invoice_currency_code,

Line 1546: FROM AP_Invoices

1542: exchange_rate_type,
1543: payment_currency_code,
1544: payment_cross_rate_date,
1545: payment_cross_rate_type
1546: FROM AP_Invoices
1547: WHERE invoice_id = CV_PPay_Invoice_ID;
1548:
1549: CURSOR C_PPAY_LINE_INFO (CV_PPAY_Invoice_ID IN NUMBER,
1550: CV_PPAY_LINE_NUM IN NUMBER) IS

Line 4455: (ai.invoice_amount - nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)) - aps.amount_remaining),/Bug10012482/

4451:
4452: CURSOR Schedules IS
4453: SELECT aps.payment_num,
4454: DECODE(p_appl_type, 'UNAPPLICATION', ((aps.gross_amount / ai.invoice_amount ) *
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

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 4539: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0))), 'N',

4535: p_payment_currency_code),
4536: 0,'Y',
4537: /*Bug10012482:Taking AWT amounts into account*/
4538: ((gross_amount / l_total_gross_amount) * (l_total_gross_amount -
4539: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0))), 'N',
4540: 'P'),
4541: last_update_date = SYSDATE,
4542: last_updated_by = p_user_id,
4543: last_update_login = p_last_update_login

Line 4590: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0))), 'N',

4586: p_payment_currency_code),
4587: 0,'Y',
4588: /*Bug10012482:Taking AWT amounts into account*/
4589: ((gross_amount / l_total_gross_amount) * (l_total_gross_amount -
4590: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0))), 'N',
4591: 'P'),
4592: last_update_date = SYSDATE,
4593: last_updated_by = p_user_id,
4594: last_update_login = p_last_update_login

Line 4620: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)))),

4616: 'APPLICATION',0,
4617: /*Bug10012482:Taking AWT amounts into account*/
4618: ((gross_amount / l_total_gross_amount )
4619: * (l_total_gross_amount -
4620: nvl(ap_invoices_pkg.get_amount_withheld(p_invoice_id),0)))),
4621: payment_status_flag = DECODE(p_appl_type,
4622: 'APPLICATION','Y',
4623: 'N'),
4624: last_update_date = SYSDATE,

Line 4651: l_debug_info := 'Update ap_invoices to reflect the amount applied p_apply_amount, p_invoice_id '||p_apply_amount||','||p_invoice_id;

4647: -- After update the payment schedules, the payment status flag should
4648: -- be updated according to the payment_status_flag of ap_payment_schedules
4649: -- to reflect the prepayment application
4650: --------------------------------------------------------------------------
4651: l_debug_info := 'Update ap_invoices to reflect the amount applied p_apply_amount, p_invoice_id '||p_apply_amount||','||p_invoice_id;
4652: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4653: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
4654: END IF;
4655: --Bug8414549 : Update the amount_paid column for Recoupment

Line 4664: from ap_invoices

4660: Similar check is present for amount remaining update on payment schedule above.*/
4661:
4662: SELECT nvl(amount_paid,0)
4663: into l_amount_paid
4664: from ap_invoices
4665: where invoice_id=p_invoice_id;
4666:
4667: if sign((l_amount_paid + p_apply_amount)) = -1 and p_apply_amount <> 0 then /* bug 12595394 */
4668: l_amount_paid := 0;

Line 4674: UPDATE ap_invoices

4670: l_amount_paid := l_amount_paid + p_apply_amount;
4671: END if;
4672: /*Bug 9643901 end*/
4673:
4674: UPDATE ap_invoices
4675: SET amount_paid = l_amount_paid , /*Bug 9643901: replaced with local variable as set above*/
4676: payment_status_flag =
4677: AP_INVOICES_UTILITY_PKG.get_payment_status(p_invoice_id ),
4678: last_update_date = SYSDATE,

Line 4677: AP_INVOICES_UTILITY_PKG.get_payment_status(p_invoice_id ),

4673:
4674: UPDATE ap_invoices
4675: SET amount_paid = l_amount_paid , /*Bug 9643901: replaced with local variable as set above*/
4676: payment_status_flag =
4677: AP_INVOICES_UTILITY_PKG.get_payment_status(p_invoice_id ),
4678: last_update_date = SYSDATE,
4679: last_updated_by = P_user_id,
4680: last_update_login = p_last_update_login
4681: WHERE invoice_id = p_invoice_id;

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)

Line 4783: FROM AP_Invoices

4779: SELECT invoice_currency_code,
4780: payment_currency_code,
4781: payment_cross_rate_date,
4782: payment_cross_rate_type
4783: FROM AP_Invoices
4784: WHERE invoice_id = CV_PPay_Invoice_ID;
4785:
4786: CURSOR C_PPAY_LINE_REC (CV_INVOICE_ID IN NUMBER,
4787: CV_LINE_NUM IN NUMBER)

Line 5083: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;

5079: l_apply_amount_remaining NUMBER;
5080: l_cursor_amount_remaining NUMBER;
5081: l_prepay_gl_date DATE := p_prepay_gl_date;
5082: l_prepay_period_name VARCHAR2(15):= p_prepay_period_name;
5083: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
5084: l_result BOOLEAN;
5085: l_debug_info VARCHAR2(4000); --Changed length from 100 to 4000 (8534097)
5086: l_current_calling_sequence VARCHAR2(2000);
5087: l_calling_program VARCHAR2(1000);

Line 5095: FROM ap_invoices ai

5091: CURSOR c_get_prepay_id (
5092: cv_prepay_num VARCHAR2,
5093: cv_vendor_id NUMBER) IS
5094: SELECT ai.invoice_id
5095: FROM ap_invoices ai
5096: WHERE ai.vendor_id = cv_vendor_id
5097: AND ai.invoice_num = cv_prepay_num
5098: AND ai.invoice_type_lookup_code = 'PREPAYMENT'
5099: AND ai.payment_status_flag = 'Y'

Line 5108: FROM ap_invoices ai,

5104: ail.line_number,
5105: AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining
5106: (ail.invoice_id,
5107: ail.line_number)
5108: FROM ap_invoices ai,
5109: ap_invoice_lines ail
5110: WHERE ai.invoice_id = cv_prepay_invoice_id
5111: AND ail.invoice_id = ai.invoice_id
5112: AND AP_Prepay_Utils_PKG.get_line_prepay_amt_remaining