eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DM_IMP_BG_WHERE dependencies on HR_DM_UTILITY

Line 55: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.indent',

51: p_newline => p_newline);
52: return l_spaces;
53: exception
54: when others then
55: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.indent',
56: '(p_indent_spaces - ' || p_indent_spaces ||
57: ')(p_newline - ' || p_newline || ')',
58: 'R');
59: end indent;

Line 95: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.populate_table', 5);

91: l_parent_table_info hr_dm_gen_main.t_table_info;
92:
93: l_index number := 1;
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);

Line 126: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.populate_table', 25);

122: g_hierarchy_info_tbl(l_index).parent_table_alias :=
123: l_parent_table_info.alias;
124: l_index := l_index +1;
125: end loop;
126: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.populate_table', 25);
127:
128:
129: exception
130: when others then

Line 131: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.populate_table',

127:
128:
129: exception
130: when others then
131: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.populate_table',
132: '(none)','R');
133: raise;
134: end populate_table;
135: ----------------------initialize_tables-------------------------

Line 144: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.initialize_tables', 5);

140: procedure initialize_tables is
141: l_index number := g_hierarchy_info_tbl.last;
142: begin
143:
144: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.initialize_tables', 5);
145: -- delete all the elements in hierarchy info table.
146: while l_index is not null loop
147: g_hierarchy_info_tbl.delete(l_index);
148: l_index := g_hierarchy_info_tbl.prior(l_index);

Line 157: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.initialize_tables', 25);

153: while l_index is not null loop
154: g_where_clause_tbl.delete(l_index);
155: l_index :=g_where_clause_tbl.prior(l_index);
156: end loop;
157: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.initialize_tables', 25);
158:
159:
160: exception
161: when others then

Line 162: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.initialize_tables',

158:
159:
160: exception
161: when others then
162: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.initialize_tables',
163: '(none)','R');
164: raise;
165: end initialize_tables;
166:

Line 174: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.clear_logical_deletes', 5);

170: ----------------------------------------------------------------
171: procedure clear_logical_deletes is
172: l_index number := g_hierarchy_info_tbl.last;
173: begin
174: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.clear_logical_deletes', 5);
175: while l_index is not null loop
176: if g_hierarchy_info_tbl(l_index).logical_delete = 'Y' then
177: g_hierarchy_info_tbl(l_index).logical_delete := 'N';
178: end if;

Line 181: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.clear_logical_deletes', 25);

177: g_hierarchy_info_tbl(l_index).logical_delete := 'N';
178: end if;
179: l_index := g_hierarchy_info_tbl.prior(l_index);
180: end loop;
181: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.clear_logical_deletes', 25);
182:
183:
184: exception
185: when others then

Line 186: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.clear_logical_deletes',

182:
183:
184: exception
185: when others then
186: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.clear_logical_deletes',
187: '(none)','R');
188: raise;
189: end clear_logical_deletes;
190:

Line 223: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.search_table_for_par_chld ', 5);

219:
220: l_index number := g_hierarchy_info_tbl.first;
221: l_original_row_index number := p_original_index ;
222: begin
223: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.search_table_for_par_chld ', 5);
224: hr_dm_utility.message('PARA','(p_parent_search_value - ' || p_parent_search_value ||
225: ')(p_child_search_value - ' || p_child_search_value || ')' ||
226: ')(p_original_index - ' || p_original_index ||
227: ')', 10);

Line 224: hr_dm_utility.message('PARA','(p_parent_search_value - ' || p_parent_search_value ||

220: l_index number := g_hierarchy_info_tbl.first;
221: l_original_row_index number := p_original_index ;
222: begin
223: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.search_table_for_par_chld ', 5);
224: hr_dm_utility.message('PARA','(p_parent_search_value - ' || p_parent_search_value ||
225: ')(p_child_search_value - ' || p_child_search_value || ')' ||
226: ')(p_original_index - ' || p_original_index ||
227: ')', 10);
228: while l_index is not null loop

Line 239: hr_dm_utility.message('PARA','(p_search_index - ' || p_search_index ||

235: end if;
236: l_index := g_hierarchy_info_tbl.next(l_index);
237: p_search_index := l_index;
238: end loop;
239: hr_dm_utility.message('PARA','(p_search_index - ' || p_search_index ||
240: ')', 20);
241:
242: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.search_table_for_par_chld', 25);
243:

Line 242: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.search_table_for_par_chld', 25);

238: end loop;
239: hr_dm_utility.message('PARA','(p_search_index - ' || p_search_index ||
240: ')', 20);
241:
242: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.search_table_for_par_chld', 25);
243:
244:
245: exception
246: when others then

Line 247: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.search_table_for_par_chld',

243:
244:
245: exception
246: when others then
247: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.search_table_for_par_chld',
248: '(p_parent_search_value - ' || p_parent_search_value ||
249: ')(p_child_search_value - ' || p_child_search_value || ')' ||
250: ')(p_original_index - ' || p_original_index ||
251: ')','R');

Line 276: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.search_table', 5);

272: p_search_index out nocopy number) is
273: l_index number := g_hierarchy_info_tbl.first;
274: begin
275:
276: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.search_table', 5);
277: hr_dm_utility.message('PARA','(p_search_type - ' || p_search_type ||
278: ')(p_table_name - ' || p_table_name || ')' ||
279: ')', 10);
280:

Line 277: hr_dm_utility.message('PARA','(p_search_type - ' || p_search_type ||

273: l_index number := g_hierarchy_info_tbl.first;
274: begin
275:
276: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.search_table', 5);
277: hr_dm_utility.message('PARA','(p_search_type - ' || p_search_type ||
278: ')(p_table_name - ' || p_table_name || ')' ||
279: ')', 10);
280:
281: while l_index is not null loop

Line 298: hr_dm_utility.message('PARA','(p_search_index - ' || p_search_index ||

294: end if;
295: l_index := g_hierarchy_info_tbl.next(l_index);
296: p_search_index := l_index;
297: end loop;
298: hr_dm_utility.message('PARA','(p_search_index - ' || p_search_index ||
299: ')', 20);
300:
301: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.search_table', 25);
302:

Line 301: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.search_table', 25);

297: end loop;
298: hr_dm_utility.message('PARA','(p_search_index - ' || p_search_index ||
299: ')', 20);
300:
301: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.search_table', 25);
302:
303:
304: exception
305: when others then

Line 306: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.search_table',

302:
303:
304: exception
305: when others then
306: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.search_table',
307: '(p_search_type - ' || p_search_type ||
308: ')(p_table_name - ' || p_table_name || ')' ||
309: ')','R');
310: raise;

Line 377: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.delete_table_rows', 5);

373: l_parent_table_index number;
374: l_child_table_index number;
375: l_child_table varchar2(30);
376: begin
377: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.delete_table_rows', 5);
378: hr_dm_utility.message('PARA','( p_child_table - ' || p_child_table ||
379: ')', 10);
380: -- get child table
381: l_child_table := p_child_table;

Line 378: hr_dm_utility.message('PARA','( p_child_table - ' || p_child_table ||

374: l_child_table_index number;
375: l_child_table varchar2(30);
376: begin
377: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.delete_table_rows', 5);
378: hr_dm_utility.message('PARA','( p_child_table - ' || p_child_table ||
379: ')', 10);
380: -- get child table
381: l_child_table := p_child_table;
382:

Line 422: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.delete_table_rows', 25);

418: end if; -- if l_parent_table_index is null then
419: end if; -- if l_child_table_index is not null then
420: end loop;
421:
422: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.delete_table_rows', 25);
423:
424: exception
425: when others then
426: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.delete_table_rows',

Line 426: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.delete_table_rows',

422: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.delete_table_rows', 25);
423:
424: exception
425: when others then
426: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.delete_table_rows',
427: '( p_child_table - ' || p_child_table ||
428: ')','R');
429: raise;
430: end delete_table_rows;

Line 477: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.prepare_where_clause_for_chain ', 5);

473: l_operand varchar2(30) := ' ';
474: l_indent number;
475: l_who_info_alias hr_dm_tables.table_alias%type;
476: begin
477: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.prepare_where_clause_for_chain ', 5);
478: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||
479: ')(p_query_type - ' || p_query_type || ')' ||
480: ')(p_table_index - ' || p_table_index || ')' ||
481: ')', 10);

Line 478: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||

474: l_indent number;
475: l_who_info_alias hr_dm_tables.table_alias%type;
476: begin
477: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.prepare_where_clause_for_chain ', 5);
478: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||
479: ')(p_query_type - ' || p_query_type || ')' ||
480: ')(p_table_index - ' || p_table_index || ')' ||
481: ')', 10);
482: --

Line 657: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.prepare_where_clause_for_chain',

653: '.business_group_id = p_business_group_id' ;
654: end if;
655:
656:
657: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.prepare_where_clause_for_chain',
658: 25);
659:
660:
661: exception

Line 663: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where. prepare_where_clause_for_chain',

659:
660:
661: exception
662: when others then
663: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where. prepare_where_clause_for_chain',
664: '(p_cursor_type - ' || p_cursor_type ||
665: ')(p_query_type - ' || p_query_type || ')' ||
666: ')(p_table_index - ' || p_table_index || ')' ||
667: ')','R');

Line 710: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.prepare_where_clause', 5);

706: l_where_clause varchar2(32767);
707: l_sub_from_clause varchar2(32767);
708: l_sub_where_clause varchar2(32767);
709: begin
710: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.prepare_where_clause', 5);
711: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||
712: ')(p_query_type - ' || p_query_type || ')' ||
713: ')', 10);
714:

Line 711: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||

707: l_sub_from_clause varchar2(32767);
708: l_sub_where_clause varchar2(32767);
709: begin
710: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.prepare_where_clause', 5);
711: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||
712: ')(p_query_type - ' || p_query_type || ')' ||
713: ')', 10);
714:
715: g_where_clause_index := 1;

Line 833: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.prepare_where_clause', 25);

829: p_where_clause := p_where_clause || ';';
830: end if;
831:
832: end if;
833: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.prepare_where_clause', 25);
834:
835: exception
836: when others then
837: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.prepare_where_clause',

Line 837: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.prepare_where_clause',

833: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.prepare_where_clause', 25);
834:
835: exception
836: when others then
837: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.prepare_where_clause',
838: '(p_cursor_type - ' || p_cursor_type ||
839: ')(p_query_type - ' || p_query_type || ')' ||
840: ')','R');
841: raise;

Line 879: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.main', 5);

875:
876: l_where_clause varchar2(32767);
877: begin
878:
879: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.main', 5);
880: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||
881: ')(p_query_type - ' || p_query_type || ')' ||
882: ')', 10);
883: initialize_tables;

Line 880: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||

876: l_where_clause varchar2(32767);
877: begin
878:
879: hr_dm_utility.message('ROUT','entry:hr_dm_imp_bg_where.main', 5);
880: hr_dm_utility.message('PARA','(p_cursor_type - ' || p_cursor_type ||
881: ')(p_query_type - ' || p_query_type || ')' ||
882: ')', 10);
883: initialize_tables;
884: populate_table (p_table_info);

Line 890: hr_dm_utility.message('PARA','( p_where_clause - ' || p_where_clause ||

886: p_cursor_type,
887: p_query_type,
888: p_where_clause);
889: l_where_clause := p_where_clause;
890: hr_dm_utility.message('PARA','( p_where_clause - ' || p_where_clause ||
891: ')', 20);
892: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.get_generator_version', 25);
893:
894: exception

Line 892: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.get_generator_version', 25);

888: p_where_clause);
889: l_where_clause := p_where_clause;
890: hr_dm_utility.message('PARA','( p_where_clause - ' || p_where_clause ||
891: ')', 20);
892: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.get_generator_version', 25);
893:
894: exception
895: when others then
896: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.main',

Line 896: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.main',

892: hr_dm_utility.message('ROUT','exit:hr_dm_imp_bg_where.get_generator_version', 25);
893:
894: exception
895: when others then
896: hr_dm_utility.error(SQLCODE,'hr_dm_imp_bg_where.main',
897: '(p_cursor_type - ' || p_cursor_type ||
898: ')(p_query_type - ' || p_query_type || ')' ||
899: ')','R');
900: raise;