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 2006/03/09 22:54:30 hyu noship $*/
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 172: FROM ar_interest_lines

168: x_msg_data OUT NOCOPY VARCHAR2)
169: IS
170: CURSOR c IS
171: SELECT *
172: FROM ar_interest_lines
173: WHERE interest_line_id = P_INTEREST_line_ID
174: FOR UPDATE OF INTEREST_line_ID;
175: l_rec ar_interest_lines%ROWTYPE;
176: l_new_rec ar_interest_lines%ROWTYPE;

Line 175: l_rec ar_interest_lines%ROWTYPE;

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

Line 176: l_new_rec ar_interest_lines%ROWTYPE;

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

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

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

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

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

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

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

Line 230: UPDATE AR_INTEREST_LINES

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

Line 273: FROM ar_interest_lines

269: x_msg_data OUT NOCOPY VARCHAR2)
270: IS
271: CURSOR c IS
272: SELECT *
273: FROM ar_interest_lines
274: WHERE interest_line_id = P_INTEREST_line_ID
275: FOR UPDATE OF INTEREST_line_ID;
276: l_rec ar_interest_lines%ROWTYPE;
277: l_new_rec ar_interest_lines%ROWTYPE;

Line 276: l_rec ar_interest_lines%ROWTYPE;

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

Line 277: l_new_rec ar_interest_lines%ROWTYPE;

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

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

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

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

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

Line 324: DELETE FROM AR_INTEREST_LINES

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

Line 350: END AR_INTEREST_LINES_PKG;

346:
347: END Delete_line;
348:
349:
350: END AR_INTEREST_LINES_PKG;