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.AR_INTEREST_LINES_PKG dependencies on AR_INTEREST_LINES

Line 1: PACKAGE BODY AR_INTEREST_LINES_PKG AS

1: PACKAGE BODY AR_INTEREST_LINES_PKG AS
2: /*$Header: ARIILINEB.pls 120.1.12010000.3 2009/04/08 11:02:34 pbapna ship $*/
3:
4: PROCEDURE Lock_line
5: (P_INTEREST_LINE_ID IN NUMBER,

Line 42: FROM AR_INTEREST_LINES

38: x_msg_data OUT NOCOPY VARCHAR2)
39: IS
40: CURSOR C IS
41: SELECT *
42: FROM AR_INTEREST_LINES
43: WHERE interest_line_id = p_interest_line_id
44: FOR UPDATE of Interest_Line_Id NOWAIT;
45: Recinfo C%ROWTYPE;
46: BEGIN

Line 108: p_old_rec IN ar_interest_lines%ROWTYPE,

104: END Lock_line;
105:
106: PROCEDURE validate_line
107: (p_action IN VARCHAR2,
108: p_old_rec IN ar_interest_lines%ROWTYPE,
109: p_new_rec IN ar_interest_lines%ROWTYPE,
110: x_return_status IN OUT NOCOPY VARCHAR2)
111: IS
112: CURSOR c IS

Line 109: p_new_rec IN ar_interest_lines%ROWTYPE,

105:
106: PROCEDURE validate_line
107: (p_action IN VARCHAR2,
108: p_old_rec IN ar_interest_lines%ROWTYPE,
109: p_new_rec IN ar_interest_lines%ROWTYPE,
110: x_return_status IN OUT NOCOPY VARCHAR2)
111: IS
112: CURSOR c IS
113: SELECT process_status

Line 174: FROM ar_interest_lines

170: P_INTEREST_CHARGED IN NUMBER DEFAULT NULL )
171: IS
172: CURSOR c IS
173: SELECT *
174: FROM ar_interest_lines
175: WHERE interest_line_id = P_INTEREST_line_ID
176: FOR UPDATE OF INTEREST_line_ID;
177: l_rec ar_interest_lines%ROWTYPE;
178: l_new_rec ar_interest_lines%ROWTYPE;

Line 177: l_rec ar_interest_lines%ROWTYPE;

173: SELECT *
174: FROM ar_interest_lines
175: WHERE interest_line_id = P_INTEREST_line_ID
176: FOR UPDATE OF INTEREST_line_ID;
177: l_rec ar_interest_lines%ROWTYPE;
178: l_new_rec ar_interest_lines%ROWTYPE;
179: BEGIN
180: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line +');
181: arp_util.debug(' p_interest_line_id :' ||P_INTEREST_LINE_ID);

Line 178: l_new_rec ar_interest_lines%ROWTYPE;

174: FROM ar_interest_lines
175: WHERE interest_line_id = P_INTEREST_line_ID
176: FOR UPDATE OF INTEREST_line_ID;
177: l_rec ar_interest_lines%ROWTYPE;
178: l_new_rec ar_interest_lines%ROWTYPE;
179: BEGIN
180: arp_util.debug('AR_INTEREST_BATCHES_PKG.update_line +');
181: arp_util.debug(' p_interest_line_id :' ||P_INTEREST_LINE_ID);
182: SAVEPOINT Update_line;

Line 197: fnd_message.set_token('RECORD', 'ar_interest_lines');

193: CLOSE c;
194:
195: IF l_rec.INTEREST_line_ID IS NULL THEN
196: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
197: fnd_message.set_token('RECORD', 'ar_interest_lines');
198: fnd_message.set_token('VALUE',
199: NVL(TO_CHAR(P_INTEREST_line_ID), 'null'));
200: fnd_msg_pub.add;
201: RAISE fnd_api.g_exc_error;

Line 211: fnd_message.set_token('TABLE', 'ar_interest_lines');

207: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
208: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
209: THEN
210: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
211: fnd_message.set_token('TABLE', 'ar_interest_lines');
212: fnd_msg_pub.add;
213: RAISE fnd_api.g_exc_error;
214: END IF;
215:

Line 231: arp_util.debug(' updating ar_interest_lines');

227: END IF;
228:
229: x_object_version_number := NVL(x_object_version_number,1) + 1;
230:
231: arp_util.debug(' updating ar_interest_lines');
232: UPDATE AR_INTEREST_LINES
233: SET
234: LAST_UPDATE_DATE = SYSDATE,
235: LAST_UPDATED_BY = NVL(arp_global.last_updated_by,-1),

Line 232: UPDATE AR_INTEREST_LINES

228:
229: x_object_version_number := NVL(x_object_version_number,1) + 1;
230:
231: arp_util.debug(' updating ar_interest_lines');
232: UPDATE AR_INTEREST_LINES
233: SET
234: LAST_UPDATE_DATE = SYSDATE,
235: LAST_UPDATED_BY = NVL(arp_global.last_updated_by,-1),
236: LAST_UPDATE_LOGIN = NVL(arp_global.LAST_UPDATE_LOGIN,-1),

Line 277: FROM ar_interest_lines

273: x_msg_data OUT NOCOPY VARCHAR2)
274: IS
275: CURSOR c IS
276: SELECT *
277: FROM ar_interest_lines
278: WHERE interest_line_id = P_INTEREST_line_ID
279: FOR UPDATE OF INTEREST_line_ID;
280: l_rec ar_interest_lines%ROWTYPE;
281: l_new_rec ar_interest_lines%ROWTYPE;

Line 280: l_rec ar_interest_lines%ROWTYPE;

276: SELECT *
277: FROM ar_interest_lines
278: WHERE interest_line_id = P_INTEREST_line_ID
279: FOR UPDATE OF INTEREST_line_ID;
280: l_rec ar_interest_lines%ROWTYPE;
281: l_new_rec ar_interest_lines%ROWTYPE;
282: BEGIN
283: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line +');
284: SAVEPOINT Delete_line;

Line 281: l_new_rec ar_interest_lines%ROWTYPE;

277: FROM ar_interest_lines
278: WHERE interest_line_id = P_INTEREST_line_ID
279: FOR UPDATE OF INTEREST_line_ID;
280: l_rec ar_interest_lines%ROWTYPE;
281: l_new_rec ar_interest_lines%ROWTYPE;
282: BEGIN
283: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line +');
284: SAVEPOINT Delete_line;
285: x_return_status := fnd_api.g_ret_sts_success;

Line 299: fnd_message.set_token('RECORD', 'ar_interest_lines');

295: CLOSE c;
296:
297: IF l_rec.INTEREST_line_ID IS NULL THEN
298: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
299: fnd_message.set_token('RECORD', 'ar_interest_lines');
300: fnd_message.set_token('VALUE',
301: NVL(TO_CHAR(P_INTEREST_line_ID), 'null'));
302: fnd_msg_pub.add;
303: RAISE fnd_api.g_exc_error;

Line 313: fnd_message.set_token('TABLE', 'ar_interest_lines');

309: l_rec.OBJECT_VERSION_NUMBER IS NOT NULL AND
310: x_object_version_number = l_rec.OBJECT_VERSION_NUMBER))
311: THEN
312: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
313: fnd_message.set_token('TABLE', 'ar_interest_lines');
314: fnd_msg_pub.add;
315: RAISE fnd_api.g_exc_error;
316: END IF;
317:

Line 328: DELETE FROM AR_INTEREST_LINES

324: IF x_return_status <> fnd_api.g_ret_sts_success THEN
325: RAISE fnd_api.g_exc_error;
326: END IF;
327:
328: DELETE FROM AR_INTEREST_LINES
329: WHERE interest_line_id = p_interest_line_id;
330:
331: arp_util.debug('AR_INTEREST_BATCHES_PKG.delete_line -');
332: EXCEPTION

Line 354: END AR_INTEREST_LINES_PKG;

350:
351: END Delete_line;
352:
353:
354: END AR_INTEREST_LINES_PKG;