APPS.IGI_IMP_IAC_CONTROLS_PKG dependencies on IGI_IMP_IAC_CONTROLS

Line 1: PACKAGE BODY igi_imp_iac_controls_pkg AS

1: PACKAGE BODY igi_imp_iac_controls_pkg AS
2: /* $Header: igiimicb.pls 120.5.12000000.1 2007/08/01 16:21:12 npandya ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_imp_iac_controls%ROWTYPE;

Line 5: old_references igi_imp_iac_controls%ROWTYPE;

1: PACKAGE BODY igi_imp_iac_controls_pkg AS
2: /* $Header: igiimicb.pls 120.5.12000000.1 2007/08/01 16:21:12 npandya ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_imp_iac_controls%ROWTYPE;
6: new_references igi_imp_iac_controls%ROWTYPE;
7:
8: --===========================FND_LOG.START=====================================
9:

Line 6: new_references igi_imp_iac_controls%ROWTYPE;

2: /* $Header: igiimicb.pls 120.5.12000000.1 2007/08/01 16:21:12 npandya ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igi_imp_iac_controls%ROWTYPE;
6: new_references igi_imp_iac_controls%ROWTYPE;
7:
8: --===========================FND_LOG.START=====================================
9:
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 16: g_path VARCHAR2(100) := 'IGI.PLSQL.igiimicb.igi_imp_iac_controls_pkg.';

12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_path VARCHAR2(100) := 'IGI.PLSQL.igiimicb.igi_imp_iac_controls_pkg.';
17:
18: --===========================FND_LOG.END=====================================
19:
20: PROCEDURE set_column_values (

Line 48: FROM igi_imp_iac_controls

44: l_path_name VARCHAR2(150) := g_path||'set_column_values';
45:
46: CURSOR cur_old_ref_values IS
47: SELECT *
48: FROM igi_imp_iac_controls
49: WHERE rowid = x_rowid;
50:
51: BEGIN
52:

Line 107: FROM igi_imp_iac_controls

103: || (reverse chronological order - newest change first)
104: */
105: CURSOR cur_rowid IS
106: SELECT rowid
107: FROM igi_imp_iac_controls
108: WHERE book_type_code = x_book_type_code
109: FOR UPDATE NOWAIT;
110:
111: lv_rowid cur_rowid%RowType;

Line 222: FROM igi_imp_iac_controls

218: */
219:
220: CURSOR c IS
221: SELECT rowid
222: FROM igi_imp_iac_controls
223: WHERE book_type_code = x_book_type_code;
224:
225: x_last_update_date DATE;
226: x_last_updated_by NUMBER;

Line 253: /* SELECT igi_imp_iac_controls_s.NEXTVAL

249: p_remove_from_stack => FALSE);
250: app_exception.raise_exception;
251: END IF;
252:
253: /* SELECT igi_imp_iac_controls_s.NEXTVAL
254: INTO x_book_type_code
255: FROM dual;*/
256:
257: before_dml(

Line 274: INSERT INTO igi_imp_iac_controls (

270: x_last_update_login => x_last_update_login
271: );
272:
273:
274: INSERT INTO igi_imp_iac_controls (
275: book_type_code,
276: corp_book,
277: period_counter,
278: request_status,

Line 337: FROM igi_imp_iac_controls

333: period_counter,
334: request_status,
335: request_id,
336: request_date
337: FROM igi_imp_iac_controls
338: WHERE rowid = x_rowid
339: FOR UPDATE NOWAIT;
340:
341: tlinfo c1%ROWTYPE;

Line 443: UPDATE igi_imp_iac_controls

439: x_last_updated_by => x_last_updated_by,
440: x_last_update_login => x_last_update_login
441: );
442:
443: UPDATE igi_imp_iac_controls
444: SET
445: corp_book = new_references.corp_book,
446: period_counter = new_references.period_counter,
447: request_status = new_references.request_status,

Line 483: FROM igi_imp_iac_controls

479: || (reverse chronological order - newest change first)
480: */
481: CURSOR c1 IS
482: SELECT rowid
483: FROM igi_imp_iac_controls
484: WHERE book_type_code = x_book_type_code;
485:
486: BEGIN
487:

Line 540: DELETE FROM igi_imp_iac_controls

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

Line 550: END igi_imp_iac_controls_pkg;

546:
547: END delete_row;
548:
549:
550: END igi_imp_iac_controls_pkg;