DBA Data[Home] [Help]

APPS.BIL_OBI_GROUPS_DENORM_PKG dependencies on BIL_OBI_RS_GROUPS_DENORM

Line 18: p_table_name := 'BIL_OBI_RS_GROUPS_DENORM';

14: BEGIN
15:
16: g_pkg := 'bil.patch.115.sql.bil_obi_groups_denorm_pkg.';
17: l_proc := 'load';
18: p_table_name := 'BIL_OBI_RS_GROUPS_DENORM';
19:
20: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
21: bil_bi_util_collection_pkg.writeLog(
22: p_log_level => fnd_log.LEVEL_PROCEDURE,

Line 32: INSERT INTO BIL_OBI_RS_GROUPS_DENORM

28: l_stmt:='TRUNCATE TABLE '|| l_schema_name || '.' || p_table_name;
29:
30: EXECUTE IMMEDIATE l_stmt;
31:
32: INSERT INTO BIL_OBI_RS_GROUPS_DENORM
33: (DENORM_GRP_ID,
34: PARENT_GROUP_ID,
35: GROUP_ID,
36: CREATED_BY,

Line 95: p_msg => 'Inserted '||g_row_num||' into BIL_OBI_RS_GROUPS_DENORM table from JTF_RS_GROUPS_DENORM');

91: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
92: bil_bi_util_collection_pkg.writeLog(
93: p_log_level => fnd_log.LEVEL_EVENT,
94: p_module => g_pkg || l_proc ,
95: p_msg => 'Inserted '||g_row_num||' into BIL_OBI_RS_GROUPS_DENORM table from JTF_RS_GROUPS_DENORM');
96: END IF;
97:
98: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
99: bil_bi_util_collection_pkg.writeLog(