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 115.21 2004/06/03 23:49:12 lkxu 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 115.21 2004/06/03 23:49:12 lkxu 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: END IF;
240:

Line 338: FROM oe_payments

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

Line 385: FROM oe_payments

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

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

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

Line 541: FROM oe_payments opt

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

Line 591: END oe_payments_Util;

587:
588: END Get_Uninvoiced_Commitment_Bal;
589:
590:
591: END oe_payments_Util;