3:
4: -- global variables
5: g_debug_mode BOOLEAN := FALSE;
6:
7: --===========================FND_LOG.START=====================================
8:
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
5: g_debug_mode BOOLEAN := FALSE;
6:
7: --===========================FND_LOG.START=====================================
8:
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
6:
7: --===========================FND_LOG.START=====================================
8:
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: --===========================FND_LOG.START=====================================
8:
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(100) := 'IGI.PLSQL.igiimxcb.igirx_c_imp_iac_rep.';
8:
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(100) := 'IGI.PLSQL.igiimxcb.igirx_c_imp_iac_rep.';
16:
9: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(100) := 'IGI.PLSQL.igiimxcb.igirx_c_imp_iac_rep.';
16:
17: --===========================FND_LOG.END=====================================
10: g_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
12: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(100) := 'IGI.PLSQL.igiimxcb.igirx_c_imp_iac_rep.';
16:
17: --===========================FND_LOG.END=====================================
18:
13: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
14: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
15: g_path VARCHAR2(100) := 'IGI.PLSQL.igiimxcb.igirx_c_imp_iac_rep.';
16:
17: --===========================FND_LOG.END=====================================
18:
19:
20: FUNCTION Trxns_In_Open_Period(p_dist_source_book in VARCHAR2,
21: p_book_type_code in VARCHAR2)