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;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
6: new_references igi_imp_iac_controls%ROWTYPE;
7:
8: --===========================FND_LOG.START=====================================
9:
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;
7:
8: --===========================FND_LOG.START=====================================
9:
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
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;
8: --===========================FND_LOG.START=====================================
9:
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
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.';
9:
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
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:
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
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=====================================
11: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
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:
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 (
21: p_action IN VARCHAR2,
22: x_rowid IN VARCHAR2 ,