DBA Data[Home] [Help]

APPS.AR_INTEREST_BATCHES_PKG dependencies on AR_INTEREST_BATCHES_PKG

Line 1: PACKAGE BODY AR_INTEREST_BATCHES_PKG AS

1: PACKAGE BODY AR_INTEREST_BATCHES_PKG AS
2: /*$Header: ARIIBATB.pls 120.5 2006/04/07 21:47:35 hyu noship $*/
3:
4: g_not VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','N');
5: g_error VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','E');

Line 24: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount+');

20: AND ib.interest_batch_id = ii.interest_batch_id
21: AND ib.interest_batch_id = p_interest_batch_id;
22: l_batch_amount NUMBER := 0;
23: BEGIN
24: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount+');
25: arp_util.debug(' p_interest_batch_id :'||p_interest_batch_id);
26: OPEN c;
27: FETCH c INTO l_batch_amount;
28: IF c%NOTFOUND THEN

Line 33: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount-');

29: l_batch_amount := 0;
30: END IF;
31: CLOSE c;
32: arp_util.debug(' resultat :'||l_batch_amount);
33: arp_util.debug('AR_INTEREST_BATCHES_PKG.get_batch_amount-');
34: RETURN l_batch_amount;
35: END;
36:
37: PROCEDURE Lock_batch

Line 58: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch+');

54: FOR UPDATE OF Interest_Batch_Id NOWAIT;
55: Recinfo C%ROWTYPE;
56: l_continue VARCHAR2(1) := 'Y';
57: BEGIN
58: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch+');
59: arp_util.debug(' p_Interest_Batch_Id :'||p_Interest_Batch_Id);
60: x_return_status := fnd_api.g_ret_sts_success;
61: OPEN C;
62: FETCH C INTO Recinfo;

Line 92: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch-');

88: p_count => x_msg_count,
89: p_data => x_msg_data);
90: END IF;
91: END IF;
92: arp_util.debug('AR_INTEREST_BATCHES_PKG.Lock_batch-');
93: END Lock_batch;
94:
95:
96:

Line 500: END AR_INTEREST_BATCHES_PKG;

496: p_count => x_msg_count,
497: p_data => x_msg_data);
498: END;
499:
500: END AR_INTEREST_BATCHES_PKG;