APPS.IGI_IAC_ADJUSTMENTS_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 1: PACKAGE BODY igi_iac_adjustments_pkg AS

1: PACKAGE BODY igi_iac_adjustments_pkg AS
2: -- $Header: igiiaadb.pls 120.8.12000000.2 2007/10/04 10:54:01 sharoy ship $
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER;

Line 48: FROM igi_iac_adjustments

44: /* This is commented out NOCOPY as the this table contains multiple rows for the same
45: adjustment id.
46: CURSOR c IS
47: SELECT rowid
48: FROM igi_iac_adjustments
49: WHERE adjustment_id = x_adjustment_id;
50: */
51:
52: x_last_update_date DATE;

Line 110: INSERT INTO igi_iac_adjustments (

106: END IF;
107: /* Bug 2454950 vgadde 10/07/2002 End */
108: /* Bug 2462546 ckappaga 16/07/2002 End */
109:
110: INSERT INTO igi_iac_adjustments (
111: adjustment_id,
112: book_type_code,
113: code_combination_id,
114: set_of_books_id,

Line 186: DELETE FROM igi_iac_adjustments

182: || (reverse chronological order - newest change first)
183: */
184: BEGIN
185:
186: DELETE FROM igi_iac_adjustments
187: WHERE adjustment_id = x_adjustment_id;
188:
189: IF (SQL%NOTFOUND) THEN
190: RAISE NO_DATA_FOUND;

Line 206: END igi_iac_adjustments_pkg;

202: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
203: g_path := 'IGI.PLSQL.igiiaadb.igi_arc_rxi.';
204: --===========================FND_LOG.END=====================================
205:
206: END igi_iac_adjustments_pkg;