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 687: l_overload dbms_describe.number_table;

683: --
684: -- Local variables to catch the values returned from
685: -- hr_general.describe_procedure
686: --
687: l_overload dbms_describe.number_table;
688: l_position dbms_describe.number_table;
689: l_level dbms_describe.number_table;
690: l_argument_name dbms_describe.varchar2_table;
691: l_datatype dbms_describe.number_table;

Line 688: l_position dbms_describe.number_table;

684: -- Local variables to catch the values returned from
685: -- hr_general.describe_procedure
686: --
687: l_overload dbms_describe.number_table;
688: l_position dbms_describe.number_table;
689: l_level dbms_describe.number_table;
690: l_argument_name dbms_describe.varchar2_table;
691: l_datatype dbms_describe.number_table;
692: l_default_value dbms_describe.number_table;

Line 689: l_level dbms_describe.number_table;

685: -- hr_general.describe_procedure
686: --
687: l_overload dbms_describe.number_table;
688: l_position dbms_describe.number_table;
689: l_level dbms_describe.number_table;
690: l_argument_name dbms_describe.varchar2_table;
691: l_datatype dbms_describe.number_table;
692: l_default_value dbms_describe.number_table;
693: l_in_out dbms_describe.number_table;

Line 690: l_argument_name dbms_describe.varchar2_table;

686: --
687: l_overload dbms_describe.number_table;
688: l_position dbms_describe.number_table;
689: l_level dbms_describe.number_table;
690: l_argument_name dbms_describe.varchar2_table;
691: l_datatype dbms_describe.number_table;
692: l_default_value dbms_describe.number_table;
693: l_in_out dbms_describe.number_table;
694: l_length dbms_describe.number_table;

Line 691: l_datatype dbms_describe.number_table;

687: l_overload dbms_describe.number_table;
688: l_position dbms_describe.number_table;
689: l_level dbms_describe.number_table;
690: l_argument_name dbms_describe.varchar2_table;
691: l_datatype dbms_describe.number_table;
692: l_default_value dbms_describe.number_table;
693: l_in_out dbms_describe.number_table;
694: l_length dbms_describe.number_table;
695: l_precision dbms_describe.number_table;

Line 692: l_default_value dbms_describe.number_table;

688: l_position dbms_describe.number_table;
689: l_level dbms_describe.number_table;
690: l_argument_name dbms_describe.varchar2_table;
691: l_datatype dbms_describe.number_table;
692: l_default_value dbms_describe.number_table;
693: l_in_out dbms_describe.number_table;
694: l_length dbms_describe.number_table;
695: l_precision dbms_describe.number_table;
696: l_scale dbms_describe.number_table;

Line 693: l_in_out dbms_describe.number_table;

689: l_level dbms_describe.number_table;
690: l_argument_name dbms_describe.varchar2_table;
691: l_datatype dbms_describe.number_table;
692: l_default_value dbms_describe.number_table;
693: l_in_out dbms_describe.number_table;
694: l_length dbms_describe.number_table;
695: l_precision dbms_describe.number_table;
696: l_scale dbms_describe.number_table;
697: l_radix dbms_describe.number_table;

Line 694: l_length dbms_describe.number_table;

690: l_argument_name dbms_describe.varchar2_table;
691: l_datatype dbms_describe.number_table;
692: l_default_value dbms_describe.number_table;
693: l_in_out dbms_describe.number_table;
694: l_length dbms_describe.number_table;
695: l_precision dbms_describe.number_table;
696: l_scale dbms_describe.number_table;
697: l_radix dbms_describe.number_table;
698: l_spare dbms_describe.number_table;

Line 695: l_precision dbms_describe.number_table;

691: l_datatype dbms_describe.number_table;
692: l_default_value dbms_describe.number_table;
693: l_in_out dbms_describe.number_table;
694: l_length dbms_describe.number_table;
695: l_precision dbms_describe.number_table;
696: l_scale dbms_describe.number_table;
697: l_radix dbms_describe.number_table;
698: l_spare dbms_describe.number_table;
699: --

Line 696: l_scale dbms_describe.number_table;

692: l_default_value dbms_describe.number_table;
693: l_in_out dbms_describe.number_table;
694: l_length dbms_describe.number_table;
695: l_precision dbms_describe.number_table;
696: l_scale dbms_describe.number_table;
697: l_radix dbms_describe.number_table;
698: l_spare dbms_describe.number_table;
699: --
700: -- Other local variables

Line 697: l_radix dbms_describe.number_table;

693: l_in_out dbms_describe.number_table;
694: l_length dbms_describe.number_table;
695: l_precision dbms_describe.number_table;
696: l_scale dbms_describe.number_table;
697: l_radix dbms_describe.number_table;
698: l_spare dbms_describe.number_table;
699: --
700: -- Other local variables
701: --

Line 698: l_spare dbms_describe.number_table;

694: l_length dbms_describe.number_table;
695: l_precision dbms_describe.number_table;
696: l_scale dbms_describe.number_table;
697: l_radix dbms_describe.number_table;
698: l_spare dbms_describe.number_table;
699: --
700: -- Other local variables
701: --
702: l_loop binary_integer; -- Loop counter.

Line 1008: l_overload dbms_describe.number_table;

1004: --
1005: -- Local variables to catch the values returned from
1006: -- hr_general.describe_procedure
1007: --
1008: l_overload dbms_describe.number_table;
1009: l_position dbms_describe.number_table;
1010: l_level dbms_describe.number_table;
1011: l_argument_name dbms_describe.varchar2_table;
1012: l_datatype dbms_describe.number_table;

Line 1009: l_position dbms_describe.number_table;

1005: -- Local variables to catch the values returned from
1006: -- hr_general.describe_procedure
1007: --
1008: l_overload dbms_describe.number_table;
1009: l_position dbms_describe.number_table;
1010: l_level dbms_describe.number_table;
1011: l_argument_name dbms_describe.varchar2_table;
1012: l_datatype dbms_describe.number_table;
1013: l_default_value dbms_describe.number_table;

Line 1010: l_level dbms_describe.number_table;

1006: -- hr_general.describe_procedure
1007: --
1008: l_overload dbms_describe.number_table;
1009: l_position dbms_describe.number_table;
1010: l_level dbms_describe.number_table;
1011: l_argument_name dbms_describe.varchar2_table;
1012: l_datatype dbms_describe.number_table;
1013: l_default_value dbms_describe.number_table;
1014: l_in_out dbms_describe.number_table;

Line 1011: l_argument_name dbms_describe.varchar2_table;

1007: --
1008: l_overload dbms_describe.number_table;
1009: l_position dbms_describe.number_table;
1010: l_level dbms_describe.number_table;
1011: l_argument_name dbms_describe.varchar2_table;
1012: l_datatype dbms_describe.number_table;
1013: l_default_value dbms_describe.number_table;
1014: l_in_out dbms_describe.number_table;
1015: l_length dbms_describe.number_table;

Line 1012: l_datatype dbms_describe.number_table;

1008: l_overload dbms_describe.number_table;
1009: l_position dbms_describe.number_table;
1010: l_level dbms_describe.number_table;
1011: l_argument_name dbms_describe.varchar2_table;
1012: l_datatype dbms_describe.number_table;
1013: l_default_value dbms_describe.number_table;
1014: l_in_out dbms_describe.number_table;
1015: l_length dbms_describe.number_table;
1016: l_precision dbms_describe.number_table;

Line 1013: l_default_value dbms_describe.number_table;

1009: l_position dbms_describe.number_table;
1010: l_level dbms_describe.number_table;
1011: l_argument_name dbms_describe.varchar2_table;
1012: l_datatype dbms_describe.number_table;
1013: l_default_value dbms_describe.number_table;
1014: l_in_out dbms_describe.number_table;
1015: l_length dbms_describe.number_table;
1016: l_precision dbms_describe.number_table;
1017: l_scale dbms_describe.number_table;

Line 1014: l_in_out dbms_describe.number_table;

1010: l_level dbms_describe.number_table;
1011: l_argument_name dbms_describe.varchar2_table;
1012: l_datatype dbms_describe.number_table;
1013: l_default_value dbms_describe.number_table;
1014: l_in_out dbms_describe.number_table;
1015: l_length dbms_describe.number_table;
1016: l_precision dbms_describe.number_table;
1017: l_scale dbms_describe.number_table;
1018: l_radix dbms_describe.number_table;

Line 1015: l_length dbms_describe.number_table;

1011: l_argument_name dbms_describe.varchar2_table;
1012: l_datatype dbms_describe.number_table;
1013: l_default_value dbms_describe.number_table;
1014: l_in_out dbms_describe.number_table;
1015: l_length dbms_describe.number_table;
1016: l_precision dbms_describe.number_table;
1017: l_scale dbms_describe.number_table;
1018: l_radix dbms_describe.number_table;
1019: l_spare dbms_describe.number_table;

Line 1016: l_precision dbms_describe.number_table;

1012: l_datatype dbms_describe.number_table;
1013: l_default_value dbms_describe.number_table;
1014: l_in_out dbms_describe.number_table;
1015: l_length dbms_describe.number_table;
1016: l_precision dbms_describe.number_table;
1017: l_scale dbms_describe.number_table;
1018: l_radix dbms_describe.number_table;
1019: l_spare dbms_describe.number_table;
1020: --

Line 1017: l_scale dbms_describe.number_table;

1013: l_default_value dbms_describe.number_table;
1014: l_in_out dbms_describe.number_table;
1015: l_length dbms_describe.number_table;
1016: l_precision dbms_describe.number_table;
1017: l_scale dbms_describe.number_table;
1018: l_radix dbms_describe.number_table;
1019: l_spare dbms_describe.number_table;
1020: --
1021: -- Other local variables

Line 1018: l_radix dbms_describe.number_table;

1014: l_in_out dbms_describe.number_table;
1015: l_length dbms_describe.number_table;
1016: l_precision dbms_describe.number_table;
1017: l_scale dbms_describe.number_table;
1018: l_radix dbms_describe.number_table;
1019: l_spare dbms_describe.number_table;
1020: --
1021: -- Other local variables
1022: --

Line 1019: l_spare dbms_describe.number_table;

1015: l_length dbms_describe.number_table;
1016: l_precision dbms_describe.number_table;
1017: l_scale dbms_describe.number_table;
1018: l_radix dbms_describe.number_table;
1019: l_spare dbms_describe.number_table;
1020: --
1021: -- Other local variables
1022: --
1023: l_loop number; -- Loop counter

Line 2484: l_overload dbms_describe.number_table;

2480: --
2481: -- Local variables to catch the values returned from
2482: -- hr_general.describe_procedure
2483: --
2484: l_overload dbms_describe.number_table;
2485: l_position dbms_describe.number_table;
2486: l_level dbms_describe.number_table;
2487: l_argument_name dbms_describe.varchar2_table;
2488: l_datatype dbms_describe.number_table;

Line 2485: l_position dbms_describe.number_table;

2481: -- Local variables to catch the values returned from
2482: -- hr_general.describe_procedure
2483: --
2484: l_overload dbms_describe.number_table;
2485: l_position dbms_describe.number_table;
2486: l_level dbms_describe.number_table;
2487: l_argument_name dbms_describe.varchar2_table;
2488: l_datatype dbms_describe.number_table;
2489: l_default_value dbms_describe.number_table;

Line 2486: l_level dbms_describe.number_table;

2482: -- hr_general.describe_procedure
2483: --
2484: l_overload dbms_describe.number_table;
2485: l_position dbms_describe.number_table;
2486: l_level dbms_describe.number_table;
2487: l_argument_name dbms_describe.varchar2_table;
2488: l_datatype dbms_describe.number_table;
2489: l_default_value dbms_describe.number_table;
2490: l_in_out dbms_describe.number_table;

Line 2487: l_argument_name dbms_describe.varchar2_table;

2483: --
2484: l_overload dbms_describe.number_table;
2485: l_position dbms_describe.number_table;
2486: l_level dbms_describe.number_table;
2487: l_argument_name dbms_describe.varchar2_table;
2488: l_datatype dbms_describe.number_table;
2489: l_default_value dbms_describe.number_table;
2490: l_in_out dbms_describe.number_table;
2491: l_length dbms_describe.number_table;

Line 2488: l_datatype dbms_describe.number_table;

2484: l_overload dbms_describe.number_table;
2485: l_position dbms_describe.number_table;
2486: l_level dbms_describe.number_table;
2487: l_argument_name dbms_describe.varchar2_table;
2488: l_datatype dbms_describe.number_table;
2489: l_default_value dbms_describe.number_table;
2490: l_in_out dbms_describe.number_table;
2491: l_length dbms_describe.number_table;
2492: l_precision dbms_describe.number_table;

Line 2489: l_default_value dbms_describe.number_table;

2485: l_position dbms_describe.number_table;
2486: l_level dbms_describe.number_table;
2487: l_argument_name dbms_describe.varchar2_table;
2488: l_datatype dbms_describe.number_table;
2489: l_default_value dbms_describe.number_table;
2490: l_in_out dbms_describe.number_table;
2491: l_length dbms_describe.number_table;
2492: l_precision dbms_describe.number_table;
2493: l_scale dbms_describe.number_table;

Line 2490: l_in_out dbms_describe.number_table;

2486: l_level dbms_describe.number_table;
2487: l_argument_name dbms_describe.varchar2_table;
2488: l_datatype dbms_describe.number_table;
2489: l_default_value dbms_describe.number_table;
2490: l_in_out dbms_describe.number_table;
2491: l_length dbms_describe.number_table;
2492: l_precision dbms_describe.number_table;
2493: l_scale dbms_describe.number_table;
2494: l_radix dbms_describe.number_table;

Line 2491: l_length dbms_describe.number_table;

2487: l_argument_name dbms_describe.varchar2_table;
2488: l_datatype dbms_describe.number_table;
2489: l_default_value dbms_describe.number_table;
2490: l_in_out dbms_describe.number_table;
2491: l_length dbms_describe.number_table;
2492: l_precision dbms_describe.number_table;
2493: l_scale dbms_describe.number_table;
2494: l_radix dbms_describe.number_table;
2495: l_spare dbms_describe.number_table;

Line 2492: l_precision dbms_describe.number_table;

2488: l_datatype dbms_describe.number_table;
2489: l_default_value dbms_describe.number_table;
2490: l_in_out dbms_describe.number_table;
2491: l_length dbms_describe.number_table;
2492: l_precision dbms_describe.number_table;
2493: l_scale dbms_describe.number_table;
2494: l_radix dbms_describe.number_table;
2495: l_spare dbms_describe.number_table;
2496: --

Line 2493: l_scale dbms_describe.number_table;

2489: l_default_value dbms_describe.number_table;
2490: l_in_out dbms_describe.number_table;
2491: l_length dbms_describe.number_table;
2492: l_precision dbms_describe.number_table;
2493: l_scale dbms_describe.number_table;
2494: l_radix dbms_describe.number_table;
2495: l_spare dbms_describe.number_table;
2496: --
2497: -- Other local variables

Line 2494: l_radix dbms_describe.number_table;

2490: l_in_out dbms_describe.number_table;
2491: l_length dbms_describe.number_table;
2492: l_precision dbms_describe.number_table;
2493: l_scale dbms_describe.number_table;
2494: l_radix dbms_describe.number_table;
2495: l_spare dbms_describe.number_table;
2496: --
2497: -- Other local variables
2498: --

Line 2495: l_spare dbms_describe.number_table;

2491: l_length dbms_describe.number_table;
2492: l_precision dbms_describe.number_table;
2493: l_scale dbms_describe.number_table;
2494: l_radix dbms_describe.number_table;
2495: l_spare dbms_describe.number_table;
2496: --
2497: -- Other local variables
2498: --
2499: l_loop binary_integer; -- Loop counter