9: valid BOOLEAN);
10:
11: TYPE Instance_Tab IS TABLE OF Instance_Rec INDEX BY BINARY_INTEGER;
12:
13: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('EDW_DEBUG'), 'N');
14: g_rec Instance_Tab;
15: g_fii_schema VARCHAR2(30);
16: g_tablespace VARCHAR2(30);
17: g_start_date DATE;
923: l_stmt := ' ALTER SESSION SET global_names = false';
924: EXECUTE IMMEDIATE l_stmt;
925:
926: -- DEBUG
927: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
928: edw_log.g_debug := TRUE;
929: END IF;
930:
931: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
927: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
928: edw_log.g_debug := TRUE;
929: END IF;
930:
931: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
932: if l_dir is null then
933: l_dir:='/sqlcom/log';
934: end if;
935: if g_debug_flag = 'Y' then