APPS.HR_INDEX_CHECK dependencies on HR_UTILITY

Line 270: hr_utility.set_location('Adding to hr_api_user_hook_reports',99);

266: l_text varchar2(80);
267: l_number integer;
268: --
269: BEGIN
270: hr_utility.set_location('Adding to hr_api_user_hook_reports',99);
271: --
272: hr_utility.set_location('Adding for line: '||to_char(g_number),1);
273: --
274: IF p_index = 'HEADER' and p_table = 'HEADER' THEN

Line 272: hr_utility.set_location('Adding for line: '||to_char(g_number),1);

268: --
269: BEGIN
270: hr_utility.set_location('Adding to hr_api_user_hook_reports',99);
271: --
272: hr_utility.set_location('Adding for line: '||to_char(g_number),1);
273: --
274: IF p_index = 'HEADER' and p_table = 'HEADER' THEN
275: insert_legend;
276: l_text :=

Line 471: hr_utility.set_location('Entering:'||l_proc,10);

467: l_proc varchar2(72) := 'hr_index_check.add_fk_header';
468: l_line varchar2(80);
469: --
470: BEGIN
471: hr_utility.set_location('Entering:'||l_proc,10);
472: --
473: l_line := rpad('TABLE',30) || ' ' || rpad('INDEX',30)
474: || ' ' || 'CODE STATUS';
475: --

Line 500: hr_utility.set_location('Leaving:'||l_proc,20);

496: l_line);
497: -- Increment line counter
498: g_number := g_number + 1;
499: --
500: hr_utility.set_location('Leaving:'||l_proc,20);
501: END add_fk_header;
502: --
503: -- ----------------------------------------------------------------------------
504: -- |---------------------------< build_fk_index_list >------------------------|

Line 568: hr_utility.set_location('Entering:'||l_proc,10);

564: l_owner varchar2(30);
565: l_per_owner varchar2(30);
566: --
567: BEGIN
568: hr_utility.set_location('Entering:'||l_proc,10);
569: l_per_owner := get_schema('PER');
570: --
571: IF p_prod = 'PER' THEN
572: -- PER is a special case - involves HR and PER tables

Line 650: hr_utility.set_location('Leaving:'||l_proc,20);

646: END IF;
647: --
648: p_list(l_list).index_name := null;
649: --
650: hr_utility.set_location('Leaving:'||l_proc,20);
651: END build_fk_index_list;
652: --
653: -- ----------------------------------------------------------------------------
654: -- |----------------------< find_missing_cons_indexes >-----------------------|

Line 666: hr_utility.set_location('Entering:'||l_proc,10);

662: l_db_index integer := 0;
663: l_case_index integer := 0;
664: --
665: BEGIN
666: hr_utility.set_location('Entering:'||l_proc,10);
667: --
668: WHILE ((p_db_list(l_db_index).index_name IS NOT NULL) or
669: (p_case_list(l_case_index).index_name IS NOT NULL)) LOOP
670: --