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_API_USER_HOOKS dependencies on DBMS_DESCRIBE

Line 9: -- Error Exceptions which can be raised by dbms_describe.describe_procedure

5: --
6: type tbl_parameter_name is table of varchar2(30) index by binary_integer;
7: type tbl_parameter_datatype is table of number index by binary_integer;
8: --
9: -- Error Exceptions which can be raised by dbms_describe.describe_procedure
10: --
11: --
12: -- Package does not exist in the database
13: --

Line 680: l_overload dbms_describe.number_table;

676: --
677: -- Local variables to catch the values returned from
678: -- hr_general.describe_procedure
679: --
680: l_overload dbms_describe.number_table;
681: l_position dbms_describe.number_table;
682: l_level dbms_describe.number_table;
683: l_argument_name dbms_describe.varchar2_table;
684: l_datatype dbms_describe.number_table;

Line 681: l_position dbms_describe.number_table;

677: -- Local variables to catch the values returned from
678: -- hr_general.describe_procedure
679: --
680: l_overload dbms_describe.number_table;
681: l_position dbms_describe.number_table;
682: l_level dbms_describe.number_table;
683: l_argument_name dbms_describe.varchar2_table;
684: l_datatype dbms_describe.number_table;
685: l_default_value dbms_describe.number_table;

Line 682: l_level dbms_describe.number_table;

678: -- hr_general.describe_procedure
679: --
680: l_overload dbms_describe.number_table;
681: l_position dbms_describe.number_table;
682: l_level dbms_describe.number_table;
683: l_argument_name dbms_describe.varchar2_table;
684: l_datatype dbms_describe.number_table;
685: l_default_value dbms_describe.number_table;
686: l_in_out dbms_describe.number_table;

Line 683: l_argument_name dbms_describe.varchar2_table;

679: --
680: l_overload dbms_describe.number_table;
681: l_position dbms_describe.number_table;
682: l_level dbms_describe.number_table;
683: l_argument_name dbms_describe.varchar2_table;
684: l_datatype dbms_describe.number_table;
685: l_default_value dbms_describe.number_table;
686: l_in_out dbms_describe.number_table;
687: l_length dbms_describe.number_table;

Line 684: l_datatype dbms_describe.number_table;

680: l_overload dbms_describe.number_table;
681: l_position dbms_describe.number_table;
682: l_level dbms_describe.number_table;
683: l_argument_name dbms_describe.varchar2_table;
684: l_datatype dbms_describe.number_table;
685: l_default_value dbms_describe.number_table;
686: l_in_out dbms_describe.number_table;
687: l_length dbms_describe.number_table;
688: l_precision dbms_describe.number_table;

Line 685: l_default_value dbms_describe.number_table;

681: l_position dbms_describe.number_table;
682: l_level dbms_describe.number_table;
683: l_argument_name dbms_describe.varchar2_table;
684: l_datatype dbms_describe.number_table;
685: l_default_value dbms_describe.number_table;
686: l_in_out dbms_describe.number_table;
687: l_length dbms_describe.number_table;
688: l_precision dbms_describe.number_table;
689: l_scale dbms_describe.number_table;

Line 686: l_in_out dbms_describe.number_table;

682: l_level dbms_describe.number_table;
683: l_argument_name dbms_describe.varchar2_table;
684: l_datatype dbms_describe.number_table;
685: l_default_value dbms_describe.number_table;
686: l_in_out dbms_describe.number_table;
687: l_length dbms_describe.number_table;
688: l_precision dbms_describe.number_table;
689: l_scale dbms_describe.number_table;
690: l_radix dbms_describe.number_table;

Line 687: l_length dbms_describe.number_table;

683: l_argument_name dbms_describe.varchar2_table;
684: l_datatype dbms_describe.number_table;
685: l_default_value dbms_describe.number_table;
686: l_in_out dbms_describe.number_table;
687: l_length dbms_describe.number_table;
688: l_precision dbms_describe.number_table;
689: l_scale dbms_describe.number_table;
690: l_radix dbms_describe.number_table;
691: l_spare dbms_describe.number_table;

Line 688: l_precision dbms_describe.number_table;

684: l_datatype dbms_describe.number_table;
685: l_default_value dbms_describe.number_table;
686: l_in_out dbms_describe.number_table;
687: l_length dbms_describe.number_table;
688: l_precision dbms_describe.number_table;
689: l_scale dbms_describe.number_table;
690: l_radix dbms_describe.number_table;
691: l_spare dbms_describe.number_table;
692: --

Line 689: l_scale dbms_describe.number_table;

685: l_default_value dbms_describe.number_table;
686: l_in_out dbms_describe.number_table;
687: l_length dbms_describe.number_table;
688: l_precision dbms_describe.number_table;
689: l_scale dbms_describe.number_table;
690: l_radix dbms_describe.number_table;
691: l_spare dbms_describe.number_table;
692: --
693: -- Other local variables

Line 690: l_radix dbms_describe.number_table;

686: l_in_out dbms_describe.number_table;
687: l_length dbms_describe.number_table;
688: l_precision dbms_describe.number_table;
689: l_scale dbms_describe.number_table;
690: l_radix dbms_describe.number_table;
691: l_spare dbms_describe.number_table;
692: --
693: -- Other local variables
694: --

Line 691: l_spare dbms_describe.number_table;

687: l_length dbms_describe.number_table;
688: l_precision dbms_describe.number_table;
689: l_scale dbms_describe.number_table;
690: l_radix dbms_describe.number_table;
691: l_spare dbms_describe.number_table;
692: --
693: -- Other local variables
694: --
695: l_loop binary_integer; -- Loop counter.

Line 1001: l_overload dbms_describe.number_table;

997: --
998: -- Local variables to catch the values returned from
999: -- hr_general.describe_procedure
1000: --
1001: l_overload dbms_describe.number_table;
1002: l_position dbms_describe.number_table;
1003: l_level dbms_describe.number_table;
1004: l_argument_name dbms_describe.varchar2_table;
1005: l_datatype dbms_describe.number_table;

Line 1002: l_position dbms_describe.number_table;

998: -- Local variables to catch the values returned from
999: -- hr_general.describe_procedure
1000: --
1001: l_overload dbms_describe.number_table;
1002: l_position dbms_describe.number_table;
1003: l_level dbms_describe.number_table;
1004: l_argument_name dbms_describe.varchar2_table;
1005: l_datatype dbms_describe.number_table;
1006: l_default_value dbms_describe.number_table;

Line 1003: l_level dbms_describe.number_table;

999: -- hr_general.describe_procedure
1000: --
1001: l_overload dbms_describe.number_table;
1002: l_position dbms_describe.number_table;
1003: l_level dbms_describe.number_table;
1004: l_argument_name dbms_describe.varchar2_table;
1005: l_datatype dbms_describe.number_table;
1006: l_default_value dbms_describe.number_table;
1007: l_in_out dbms_describe.number_table;

Line 1004: l_argument_name dbms_describe.varchar2_table;

1000: --
1001: l_overload dbms_describe.number_table;
1002: l_position dbms_describe.number_table;
1003: l_level dbms_describe.number_table;
1004: l_argument_name dbms_describe.varchar2_table;
1005: l_datatype dbms_describe.number_table;
1006: l_default_value dbms_describe.number_table;
1007: l_in_out dbms_describe.number_table;
1008: l_length dbms_describe.number_table;

Line 1005: l_datatype dbms_describe.number_table;

1001: l_overload dbms_describe.number_table;
1002: l_position dbms_describe.number_table;
1003: l_level dbms_describe.number_table;
1004: l_argument_name dbms_describe.varchar2_table;
1005: l_datatype dbms_describe.number_table;
1006: l_default_value dbms_describe.number_table;
1007: l_in_out dbms_describe.number_table;
1008: l_length dbms_describe.number_table;
1009: l_precision dbms_describe.number_table;

Line 1006: l_default_value dbms_describe.number_table;

1002: l_position dbms_describe.number_table;
1003: l_level dbms_describe.number_table;
1004: l_argument_name dbms_describe.varchar2_table;
1005: l_datatype dbms_describe.number_table;
1006: l_default_value dbms_describe.number_table;
1007: l_in_out dbms_describe.number_table;
1008: l_length dbms_describe.number_table;
1009: l_precision dbms_describe.number_table;
1010: l_scale dbms_describe.number_table;

Line 1007: l_in_out dbms_describe.number_table;

1003: l_level dbms_describe.number_table;
1004: l_argument_name dbms_describe.varchar2_table;
1005: l_datatype dbms_describe.number_table;
1006: l_default_value dbms_describe.number_table;
1007: l_in_out dbms_describe.number_table;
1008: l_length dbms_describe.number_table;
1009: l_precision dbms_describe.number_table;
1010: l_scale dbms_describe.number_table;
1011: l_radix dbms_describe.number_table;

Line 1008: l_length dbms_describe.number_table;

1004: l_argument_name dbms_describe.varchar2_table;
1005: l_datatype dbms_describe.number_table;
1006: l_default_value dbms_describe.number_table;
1007: l_in_out dbms_describe.number_table;
1008: l_length dbms_describe.number_table;
1009: l_precision dbms_describe.number_table;
1010: l_scale dbms_describe.number_table;
1011: l_radix dbms_describe.number_table;
1012: l_spare dbms_describe.number_table;

Line 1009: l_precision dbms_describe.number_table;

1005: l_datatype dbms_describe.number_table;
1006: l_default_value dbms_describe.number_table;
1007: l_in_out dbms_describe.number_table;
1008: l_length dbms_describe.number_table;
1009: l_precision dbms_describe.number_table;
1010: l_scale dbms_describe.number_table;
1011: l_radix dbms_describe.number_table;
1012: l_spare dbms_describe.number_table;
1013: --

Line 1010: l_scale dbms_describe.number_table;

1006: l_default_value dbms_describe.number_table;
1007: l_in_out dbms_describe.number_table;
1008: l_length dbms_describe.number_table;
1009: l_precision dbms_describe.number_table;
1010: l_scale dbms_describe.number_table;
1011: l_radix dbms_describe.number_table;
1012: l_spare dbms_describe.number_table;
1013: --
1014: -- Other local variables

Line 1011: l_radix dbms_describe.number_table;

1007: l_in_out dbms_describe.number_table;
1008: l_length dbms_describe.number_table;
1009: l_precision dbms_describe.number_table;
1010: l_scale dbms_describe.number_table;
1011: l_radix dbms_describe.number_table;
1012: l_spare dbms_describe.number_table;
1013: --
1014: -- Other local variables
1015: --

Line 1012: l_spare dbms_describe.number_table;

1008: l_length dbms_describe.number_table;
1009: l_precision dbms_describe.number_table;
1010: l_scale dbms_describe.number_table;
1011: l_radix dbms_describe.number_table;
1012: l_spare dbms_describe.number_table;
1013: --
1014: -- Other local variables
1015: --
1016: l_loop number; -- Loop counter

Line 2477: l_overload dbms_describe.number_table;

2473: --
2474: -- Local variables to catch the values returned from
2475: -- hr_general.describe_procedure
2476: --
2477: l_overload dbms_describe.number_table;
2478: l_position dbms_describe.number_table;
2479: l_level dbms_describe.number_table;
2480: l_argument_name dbms_describe.varchar2_table;
2481: l_datatype dbms_describe.number_table;

Line 2478: l_position dbms_describe.number_table;

2474: -- Local variables to catch the values returned from
2475: -- hr_general.describe_procedure
2476: --
2477: l_overload dbms_describe.number_table;
2478: l_position dbms_describe.number_table;
2479: l_level dbms_describe.number_table;
2480: l_argument_name dbms_describe.varchar2_table;
2481: l_datatype dbms_describe.number_table;
2482: l_default_value dbms_describe.number_table;

Line 2479: l_level dbms_describe.number_table;

2475: -- hr_general.describe_procedure
2476: --
2477: l_overload dbms_describe.number_table;
2478: l_position dbms_describe.number_table;
2479: l_level dbms_describe.number_table;
2480: l_argument_name dbms_describe.varchar2_table;
2481: l_datatype dbms_describe.number_table;
2482: l_default_value dbms_describe.number_table;
2483: l_in_out dbms_describe.number_table;

Line 2480: l_argument_name dbms_describe.varchar2_table;

2476: --
2477: l_overload dbms_describe.number_table;
2478: l_position dbms_describe.number_table;
2479: l_level dbms_describe.number_table;
2480: l_argument_name dbms_describe.varchar2_table;
2481: l_datatype dbms_describe.number_table;
2482: l_default_value dbms_describe.number_table;
2483: l_in_out dbms_describe.number_table;
2484: l_length dbms_describe.number_table;

Line 2481: l_datatype dbms_describe.number_table;

2477: l_overload dbms_describe.number_table;
2478: l_position dbms_describe.number_table;
2479: l_level dbms_describe.number_table;
2480: l_argument_name dbms_describe.varchar2_table;
2481: l_datatype dbms_describe.number_table;
2482: l_default_value dbms_describe.number_table;
2483: l_in_out dbms_describe.number_table;
2484: l_length dbms_describe.number_table;
2485: l_precision dbms_describe.number_table;

Line 2482: l_default_value dbms_describe.number_table;

2478: l_position dbms_describe.number_table;
2479: l_level dbms_describe.number_table;
2480: l_argument_name dbms_describe.varchar2_table;
2481: l_datatype dbms_describe.number_table;
2482: l_default_value dbms_describe.number_table;
2483: l_in_out dbms_describe.number_table;
2484: l_length dbms_describe.number_table;
2485: l_precision dbms_describe.number_table;
2486: l_scale dbms_describe.number_table;

Line 2483: l_in_out dbms_describe.number_table;

2479: l_level dbms_describe.number_table;
2480: l_argument_name dbms_describe.varchar2_table;
2481: l_datatype dbms_describe.number_table;
2482: l_default_value dbms_describe.number_table;
2483: l_in_out dbms_describe.number_table;
2484: l_length dbms_describe.number_table;
2485: l_precision dbms_describe.number_table;
2486: l_scale dbms_describe.number_table;
2487: l_radix dbms_describe.number_table;

Line 2484: l_length dbms_describe.number_table;

2480: l_argument_name dbms_describe.varchar2_table;
2481: l_datatype dbms_describe.number_table;
2482: l_default_value dbms_describe.number_table;
2483: l_in_out dbms_describe.number_table;
2484: l_length dbms_describe.number_table;
2485: l_precision dbms_describe.number_table;
2486: l_scale dbms_describe.number_table;
2487: l_radix dbms_describe.number_table;
2488: l_spare dbms_describe.number_table;

Line 2485: l_precision dbms_describe.number_table;

2481: l_datatype dbms_describe.number_table;
2482: l_default_value dbms_describe.number_table;
2483: l_in_out dbms_describe.number_table;
2484: l_length dbms_describe.number_table;
2485: l_precision dbms_describe.number_table;
2486: l_scale dbms_describe.number_table;
2487: l_radix dbms_describe.number_table;
2488: l_spare dbms_describe.number_table;
2489: --

Line 2486: l_scale dbms_describe.number_table;

2482: l_default_value dbms_describe.number_table;
2483: l_in_out dbms_describe.number_table;
2484: l_length dbms_describe.number_table;
2485: l_precision dbms_describe.number_table;
2486: l_scale dbms_describe.number_table;
2487: l_radix dbms_describe.number_table;
2488: l_spare dbms_describe.number_table;
2489: --
2490: -- Other local variables

Line 2487: l_radix dbms_describe.number_table;

2483: l_in_out dbms_describe.number_table;
2484: l_length dbms_describe.number_table;
2485: l_precision dbms_describe.number_table;
2486: l_scale dbms_describe.number_table;
2487: l_radix dbms_describe.number_table;
2488: l_spare dbms_describe.number_table;
2489: --
2490: -- Other local variables
2491: --

Line 2488: l_spare dbms_describe.number_table;

2484: l_length dbms_describe.number_table;
2485: l_precision dbms_describe.number_table;
2486: l_scale dbms_describe.number_table;
2487: l_radix dbms_describe.number_table;
2488: l_spare dbms_describe.number_table;
2489: --
2490: -- Other local variables
2491: --
2492: l_loop binary_integer; -- Loop counter