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_INDEX_CHECK dependencies on HR_INDEX_CHECK

Line 1: PACKAGE BODY hr_index_check AS

1: PACKAGE BODY hr_index_check AS
2: /*$Header: hrindchk.pkb 115.2 2004/02/13 04:36:24 mroberts ship $*/
3: --
4: -- Package variables
5: g_number number default 0;

Line 350: (p_db_list IN hr_index_check.IndList

346: -- ----------------------------------------------------------------------------
347: -- |------------------------< find_missing_indexes >--------------------------|
348: -- ----------------------------------------------------------------------------
349: PROCEDURE find_missing_indexes
350: (p_db_list IN hr_index_check.IndList
351: ,p_case_list IN hr_index_check.IndList
352: ) IS
353: --
354: l_db_index integer := 0;

Line 351: ,p_case_list IN hr_index_check.IndList

347: -- |------------------------< find_missing_indexes >--------------------------|
348: -- ----------------------------------------------------------------------------
349: PROCEDURE find_missing_indexes
350: (p_db_list IN hr_index_check.IndList
351: ,p_case_list IN hr_index_check.IndList
352: ) IS
353: --
354: l_db_index integer := 0;
355: l_case_index integer := 0;

Line 420: (p_case_list IN OUT NOCOPY hr_index_check.IndList

416: -- ----------------------------------------------------------------------------
417: -- |--------------------------< add_case_index >------------------------------|
418: -- ----------------------------------------------------------------------------
419: PROCEDURE add_case_index
420: (p_case_list IN OUT NOCOPY hr_index_check.IndList
421: ,p_index_name IN varchar2
422: ,p_table IN varchar2
423: ,p_index IN OUT NOCOPY integer) IS
424: --

Line 436: (p_cons_list IN OUT NOCOPY hr_index_check.IndList

432: -- ----------------------------------------------------------------------------
433: -- |------------------------< add_case_constraint >---------------------------|
434: -- ----------------------------------------------------------------------------
435: PROCEDURE add_case_constraint
436: (p_cons_list IN OUT NOCOPY hr_index_check.IndList
437: ,p_constraint_name IN varchar2
438: ,p_table IN varchar2
439: ,p_index IN OUT NOCOPY integer) IS
440: --

Line 467: l_proc varchar2(72) := 'hr_index_check.add_fk_header';

463: -- |--------------------------< add_fk_header >-------------------------------|
464: -- ----------------------------------------------------------------------------
465: PROCEDURE add_fk_header IS
466: --
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);

Line 507: ,p_list IN OUT NOCOPY hr_index_check.IndList) IS

503: -- ----------------------------------------------------------------------------
504: -- |---------------------------< build_fk_index_list >------------------------|
505: -- ----------------------------------------------------------------------------
506: PROCEDURE build_fk_index_list(p_prod IN varchar2
507: ,p_list IN OUT NOCOPY hr_index_check.IndList) IS
508: --
509: l_proc varchar2(72) := 'hr_index_check.build_fk_index_list';
510: l_prod varchar2(50);
511: l_list integer := 0;

Line 509: l_proc varchar2(72) := 'hr_index_check.build_fk_index_list';

505: -- ----------------------------------------------------------------------------
506: PROCEDURE build_fk_index_list(p_prod IN varchar2
507: ,p_list IN OUT NOCOPY hr_index_check.IndList) IS
508: --
509: l_proc varchar2(72) := 'hr_index_check.build_fk_index_list';
510: l_prod varchar2(50);
511: l_list integer := 0;
512: --
513: CURSOR csr_find_ben_indexes (c_per_owner in varchar2,

Line 657: (p_db_list IN hr_index_check.IndList

653: -- ----------------------------------------------------------------------------
654: -- |----------------------< find_missing_cons_indexes >-----------------------|
655: -- ----------------------------------------------------------------------------
656: PROCEDURE find_missing_cons_indexes
657: (p_db_list IN hr_index_check.IndList
658: ,p_case_list IN hr_index_check.IndList
659: ) IS
660: --
661: l_proc varchar2(72) := 'hr_index_check.find_missing_cons_indexes';

Line 658: ,p_case_list IN hr_index_check.IndList

654: -- |----------------------< find_missing_cons_indexes >-----------------------|
655: -- ----------------------------------------------------------------------------
656: PROCEDURE find_missing_cons_indexes
657: (p_db_list IN hr_index_check.IndList
658: ,p_case_list IN hr_index_check.IndList
659: ) IS
660: --
661: l_proc varchar2(72) := 'hr_index_check.find_missing_cons_indexes';
662: l_db_index integer := 0;

Line 661: l_proc varchar2(72) := 'hr_index_check.find_missing_cons_indexes';

657: (p_db_list IN hr_index_check.IndList
658: ,p_case_list IN hr_index_check.IndList
659: ) IS
660: --
661: l_proc varchar2(72) := 'hr_index_check.find_missing_cons_indexes';
662: l_db_index integer := 0;
663: l_case_index integer := 0;
664: --
665: BEGIN

Line 736: END hr_index_check;

732: ,p_db => 'Y');
733: --
734: END add_footer;
735: --
736: END hr_index_check;