APPS.OE_PAYMENTS_UTIL dependencies on OE_PAYMENTS

Line 1: PACKAGE BODY oe_payments_Util AS

1: PACKAGE BODY oe_payments_Util AS
2: /* $Header: OEXULCMB.pls 120.0.12020000.3 2013/04/12 06:01:14 suthumma ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'oe_payments_Util';

2: /* $Header: OEXULCMB.pls 120.0.12020000.3 2013/04/12 06:01:14 suthumma ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'oe_payments_Util';
7:
8: -- Procedure Update_Row
9: PROCEDURE Update_Row
10: ( p_payment_types_rec IN OUT NOCOPY Payment_Types_Rec_Type

Line 30: UPDATE oe_payments

26: **/
27:
28: -- l_lock_control := l_lock_control + 1;
29:
30: UPDATE oe_payments
31: SET PAYMENT_TRX_ID = p_payment_types_rec.payment_trx_id
32: , COMMITMENT_APPLIED_AMOUNT = p_payment_types_rec.commitment_applied_amount
33: , COMMITMENT_INTERFACED_AMOUNT = p_payment_types_rec.commitment_interfaced_amount
34: /* START PREPAYMENT */

Line 54: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.UPDATE_ROW.' , 1 ) ;

50: ;
51:
52: -- p_payment_types_rec.lock_control := l_lock_control;
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.UPDATE_ROW.' , 1 ) ;
55: END IF;
56:
57: EXCEPTION
58:

Line 86: INSERT INTO oe_payments

82: --
83: BEGIN
84:
85:
86: INSERT INTO oe_payments
87: ( PAYMENT_TRX_ID
88: , COMMITMENT_APPLIED_AMOUNT
89: , COMMITMENT_INTERFACED_AMOUNT
90: /* START PREPAYMENT */

Line 175: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.INSERT_ROW.' , 1 ) ;

171: );
172:
173: -- p_payment_types_rec.lock_control := l_lock_control;
174: IF l_debug_level > 0 THEN
175: oe_debug_pub.add( 'EXITING OE_PAYMENTS_UTIL.INSERT_ROW.' , 1 ) ;
176: END IF;
177:
178: EXCEPTION
179: WHEN DUP_VAL_ON_INDEX Then

Line 230: DELETE FROM oe_payments

226: oe_debug_pub.add( 'ENTERING DELETING COMMITMENT FOR LINE: '||P_LINE_ID , 1 ) ;
227: END IF;
228:
229: IF p_payment_trx_id IS NOT NULL AND p_payment_trx_id <> FND_API.G_MISS_NUM THEN
230: DELETE FROM oe_payments
231: WHERE payment_trx_id = p_payment_trx_id;
232: END IF;
233:
234: IF p_line_id IS NOT NULL AND p_line_id <> FND_API.G_MISS_NUM

Line 236: DELETE FROM oe_payments

232: END IF;
233:
234: IF p_line_id IS NOT NULL AND p_line_id <> FND_API.G_MISS_NUM
235: AND p_header_id IS NOT NULL AND p_header_id <> FND_API.G_MISS_NUM THEN
236: DELETE FROM oe_payments
237: WHERE line_id = p_line_id
238: AND header_id = p_header_id
239: AND payment_type_code = 'COMMITMENT'; --Added for Bug# 16654431
240: END IF;

Line 339: FROM oe_payments

335: , ATTRIBUTE13
336: , ATTRIBUTE14
337: , ATTRIBUTE15
338: , PAYMENT_AMOUNT
339: FROM oe_payments
340: WHERE PAYMENT_TRX_ID = p_payment_trx_id
341: AND nvl(PAYMENT_TYPE_CODE, 'COMMITMENT') = 'COMMITMENT'
342: AND line_id = p_line_id
343: AND HEADER_ID = p_header_id

Line 386: FROM oe_payments

382: , ATTRIBUTE13
383: , ATTRIBUTE14
384: , ATTRIBUTE15
385: , PAYMENT_AMOUNT
386: FROM oe_payments
387: WHERE line_id = p_line_id
388: AND nvl(PAYMENT_TYPE_CODE, 'COMMITMENT') = 'COMMITMENT'
389: AND header_id = p_header_id
390: ;

Line 530: oe_debug_pub.add('ENTERING OE_PAYMENTS_UTIL.GET_UNINVOICED_COMMITMENT_BAL');

526: l_uninv_commitment_bal NUMBER := 0;
527: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
528: BEGIN
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add('ENTERING OE_PAYMENTS_UTIL.GET_UNINVOICED_COMMITMENT_BAL');
531: END IF;
532:
533: --14723264 IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
534:

Line 542: FROM oe_payments opt

538: SELECT
539: SUM(nvl(commitment_applied_amount, 0)
540: - nvl(commitment_interfaced_amount,0))
541: INTO l_uninv_commitment_bal
542: FROM oe_payments opt
543: WHERE opt.payment_trx_id = p_customer_trx_id;
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add('pviprana: l_uninv_commitment_bal is ' || l_uninv_commitment_bal);
546: oe_debug_pub.add('pviprana: p_customer_trx_id is ' || p_customer_trx_id);

Line 594: END oe_payments_Util;

590:
591: END Get_Uninvoiced_Commitment_Bal;
592:
593:
594: END oe_payments_Util;