APPS.IGI_IAC_TRANS_HEADERS_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 48: FROM igi_iac_transaction_headers

44: || (reverse chronological order - newest change first)
45: */
46: CURSOR c IS
47: SELECT rowid
48: FROM igi_iac_transaction_headers
49: WHERE adjustment_id = x_adjustment_id;
50:
51: CURSOR c1 IS
52: SELECT igi_iac_transaction_headers_s.NEXTVAL

Line 52: SELECT igi_iac_transaction_headers_s.NEXTVAL

48: FROM igi_iac_transaction_headers
49: WHERE adjustment_id = x_adjustment_id;
50:
51: CURSOR c1 IS
52: SELECT igi_iac_transaction_headers_s.NEXTVAL
53: FROM sys.dual;
54:
55: x_last_update_date DATE;
56: x_last_updated_by NUMBER;

Line 97: INSERT INTO igi_iac_transaction_headers (

93:
94:
95:
96:
97: INSERT INTO igi_iac_transaction_headers (
98: adjustment_id,
99: transaction_header_id,
100: adjustment_id_out,
101: transaction_type_code,

Line 179: FROM igi_iac_transaction_headers

175:
176: /*
177: CURSOR c IS
178: SELECT rowid
179: FROM igi_iac_transaction_headers
180: WHERE adjustment_id = x_prev_adjustment_id;
181: */
182:
183:

Line 220: UPDATE igi_iac_transaction_headers

216: CLOSE c;
217: */
218:
219:
220: UPDATE igi_iac_transaction_headers
221: SET
222: adjustment_id_out = x_adjustment_id,
223: last_update_date = x_last_update_date,
224: last_updated_by = x_last_updated_by,

Line 262: FROM igi_iac_transaction_headers

258: l_path_name VARCHAR2(150) := g_path||'update_row2';
259:
260: CURSOR c IS
261: SELECT rowid
262: FROM igi_iac_transaction_headers
263: WHERE adjustment_id = x_adjustment_id;
264:
265: BEGIN
266:

Line 301: UPDATE igi_iac_transaction_headers

297: END IF;
298: CLOSE c;
299: */
300:
301: UPDATE igi_iac_transaction_headers
302: SET
303: adjustment_status = x_adjustment_status,
304: last_update_date = x_last_update_date,
305: last_updated_by = x_last_updated_by,

Line 335: DELETE FROM igi_iac_transaction_headers

331: */
332: BEGIN
333:
334:
335: DELETE FROM igi_iac_transaction_headers
336: WHERE adjustment_id = x_adjustment_id;
337:
338: IF (SQL%NOTFOUND) THEN
339: RAISE NO_DATA_FOUND;