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.IGI_RPI_AUDIT_ITEMS_ALL_PKG dependencies on IGI_RPI_AUDIT_ITEMS_ALL

Line 1: PACKAGE BODY igi_rpi_audit_items_all_pkg AS

1: PACKAGE BODY igi_rpi_audit_items_all_pkg AS
2: /* $Header: igiraiab.pls 120.4.12000000.1 2007/08/31 05:52:29 mbremkum noship $ */
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 14: old_references igi_rpi_audit_items_all%ROWTYPE;

10: l_error_level number:=FND_LOG.LEVEL_ERROR;
11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_rpi_audit_items_all%ROWTYPE;
15: new_references igi_rpi_audit_items_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,

Line 15: new_references igi_rpi_audit_items_all%ROWTYPE;

11: l_unexp_level number:=FND_LOG.LEVEL_UNEXPECTED;
12:
13: l_rowid VARCHAR2(25);
14: old_references igi_rpi_audit_items_all%ROWTYPE;
15: new_references igi_rpi_audit_items_all%ROWTYPE;
16:
17: PROCEDURE set_column_values (
18: p_action IN VARCHAR2,
19: x_rowid IN VARCHAR2,

Line 44: FROM IGI_RPI_AUDIT_ITEMS_ALL

40: */
41:
42: CURSOR cur_old_ref_values IS
43: SELECT *
44: FROM IGI_RPI_AUDIT_ITEMS_ALL
45: WHERE rowid = x_rowid;
46:
47: BEGIN
48:

Line 61: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.set_column_values.Msg1',FALSE);

57: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
58:
59: --Bug 3199481 (start)
60: If (l_unexp_level >= l_debug_level) then
61: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.set_column_values.Msg1',FALSE);
62: End if;
63: --Bug 3199481 (end)
64: app_exception.raise_exception;
65: RETURN;

Line 120: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.check_parent_existence.Msg1',FALSE);

116: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
117:
118: --Bug 3199481 (start)
119: If (l_unexp_level >= l_debug_level) then
120: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.check_parent_existence.Msg1',FALSE);
121: End if;
122: --Bug 3199481 (end)
123: app_exception.raise_exception;
124: END IF;

Line 208: FROM igi_rpi_audit_items_all

204: || (reverse chronological order - newest change first)
205: */
206: CURSOR c IS
207: SELECT rowid
208: FROM igi_rpi_audit_items_all
209: WHERE item_id=x_item_id and run_id=x_run_id;
210:
211: x_last_update_date DATE;
212: x_last_updated_by NUMBER;

Line 234: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.insert_row.Msg1',FALSE);

230: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
231:
232: --Bug 3199481 (start)
233: If (l_unexp_level >= l_debug_level) then
234: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.insert_row.Msg1',FALSE);
235: End if;
236: --Bug 3199481 (end)
237: app_exception.raise_exception;
238: END IF;

Line 256: INSERT INTO igi_rpi_audit_items_all (

252: x_last_update_date => x_last_update_date,
253: x_last_updated_by => x_last_updated_by,
254: x_last_update_login => x_last_update_login
255: );
256: INSERT INTO igi_rpi_audit_items_all (
257: item_id,
258: price,
259: effective_date,
260: revised_effective_date,

Line 323: FROM igi_rpi_audit_items_all

319: revised_effective_date,
320: revised_price,
321: run_id,
322: org_id
323: FROM igi_rpi_audit_items_all
324: WHERE rowid = x_rowid
325: FOR UPDATE NOWAIT;
326:
327: tlinfo c1%ROWTYPE;

Line 338: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.lock_row.Msg1',FALSE);

334: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
335:
336: --Bug 3199481 (start)
337: If (l_unexp_level >= l_debug_level) then
338: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.lock_row.Msg1',FALSE);
339: End if;
340: --Bug 3199481 (end)
341: null;
342: CLOSE c1;

Line 363: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.lock_row.Msg2',FALSE);

359: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
360:
361: --Bug 3199481 (start)
362: If (l_unexp_level >= l_debug_level) then
363: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.lock_row.Msg2',FALSE);
364: End if;
365: --Bug 3199481 (end)
366: app_exception.raise_exception;
367: END IF;

Line 417: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.update_row.Msg1',FALSE);

413: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
414:
415: --Bug 3199481 (start)
416: If (l_unexp_level >= l_debug_level) then
417: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_rpi_audit_items_all_pkg.update_row.Msg1',FALSE);
418: End if;
419: --Bug 3199481 (end)
420: app_exception.raise_exception;
421: END IF;

Line 440: UPDATE igi_rpi_audit_items_all

436: x_last_updated_by => x_last_updated_by,
437: x_last_update_login => x_last_update_login
438: );
439:
440: UPDATE igi_rpi_audit_items_all
441: SET
442: item_id = new_references.item_id,
443: price = new_references.price,
444: effective_date = new_references.effective_date,

Line 482: FROM igi_rpi_audit_items_all

478: || (reverse chronological order - newest change first)
479: */
480: CURSOR c1 IS
481: SELECT rowid
482: FROM igi_rpi_audit_items_all
483: WHERE item_id=x_item_id and run_id=x_run_id;
484:
485: BEGIN
486:

Line 541: DELETE FROM igi_rpi_audit_items_all

537: p_action => 'DELETE',
538: x_rowid => x_rowid
539: );
540:
541: DELETE FROM igi_rpi_audit_items_all
542: WHERE rowid = x_rowid;
543:
544: IF (SQL%NOTFOUND) THEN
545: RAISE NO_DATA_FOUND;

Line 551: END igi_rpi_audit_items_all_pkg;

547:
548: END delete_row;
549:
550:
551: END igi_rpi_audit_items_all_pkg;