46: ) return varchar2 is
47: l_spaces varchar2(100);
48: begin
49:
50: l_spaces := hr_dm_library.indent(p_indent_spaces => p_indent_spaces,
51: p_newline => p_newline);
52: return l_spaces;
53: exception
54: when others then
94: begin
95: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.populate_table', 5);
96: for csr_tab_rel_rec in csr_tab_rel loop
97: -- get the child_table details such as alias, name etc.
98: hr_dm_library.get_table_info (csr_tab_rel_rec.table_id,
99: l_child_table_info);
100:
101: -- get the child_table details such as alias, name etc.
102: hr_dm_library.get_table_info (csr_tab_rel_rec.parent_table_id,
98: hr_dm_library.get_table_info (csr_tab_rel_rec.table_id,
99: l_child_table_info);
100:
101: -- get the child_table details such as alias, name etc.
102: hr_dm_library.get_table_info (csr_tab_rel_rec.parent_table_id,
103: l_parent_table_info);
104:
105: -- child table name
106: g_hierarchy_info_tbl(l_index).table_name :=