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

Line 127: -- dbms_describe values for different data types.

123: --------------------------
124: c_newline constant varchar(1) default '
125: ';
126: --
127: -- dbms_describe values for different data types.
128: --
129: c_dtype_undefined constant number default 0;
130: c_dtype_varchar2 constant number default 1;
131: c_dtype_number constant number default 2;

Line 137: -- dbms_describe values for different parameter passing modes.

133: c_dtype_long constant number default 8;
134: c_dtype_date constant number default 12;
135: c_dtype_boolean constant number default 252;
136: --
137: -- dbms_describe values for different parameter passing modes.
138: --
139: c_ptype_in constant number default 0;
140: c_ptype_out constant number default 1;
141: c_ptype_in_out constant number default 2;

Line 487: p_overload in out nocopy dbms_describe.number_table,

483: -- algorithm was agreed by Peter Attwood (HRMS API strategy).
484: -- ------------------------------------------------------------------------
485: procedure get_latest_api
486: (
487: p_overload in out nocopy dbms_describe.number_table,
488: p_position in out nocopy dbms_describe.number_table,
489: p_level in out nocopy dbms_describe.number_table,
490: p_argument_name in out nocopy dbms_describe.varchar2_table,
491: p_datatype in out nocopy dbms_describe.number_table,

Line 488: p_position in out nocopy dbms_describe.number_table,

484: -- ------------------------------------------------------------------------
485: procedure get_latest_api
486: (
487: p_overload in out nocopy dbms_describe.number_table,
488: p_position in out nocopy dbms_describe.number_table,
489: p_level in out nocopy dbms_describe.number_table,
490: p_argument_name in out nocopy dbms_describe.varchar2_table,
491: p_datatype in out nocopy dbms_describe.number_table,
492: p_default_value in out nocopy dbms_describe.number_table,

Line 489: p_level in out nocopy dbms_describe.number_table,

485: procedure get_latest_api
486: (
487: p_overload in out nocopy dbms_describe.number_table,
488: p_position in out nocopy dbms_describe.number_table,
489: p_level in out nocopy dbms_describe.number_table,
490: p_argument_name in out nocopy dbms_describe.varchar2_table,
491: p_datatype in out nocopy dbms_describe.number_table,
492: p_default_value in out nocopy dbms_describe.number_table,
493: p_in_out in out nocopy dbms_describe.number_table,

Line 490: p_argument_name in out nocopy dbms_describe.varchar2_table,

486: (
487: p_overload in out nocopy dbms_describe.number_table,
488: p_position in out nocopy dbms_describe.number_table,
489: p_level in out nocopy dbms_describe.number_table,
490: p_argument_name in out nocopy dbms_describe.varchar2_table,
491: p_datatype in out nocopy dbms_describe.number_table,
492: p_default_value in out nocopy dbms_describe.number_table,
493: p_in_out in out nocopy dbms_describe.number_table,
494: p_length in out nocopy dbms_describe.number_table,

Line 491: p_datatype in out nocopy dbms_describe.number_table,

487: p_overload in out nocopy dbms_describe.number_table,
488: p_position in out nocopy dbms_describe.number_table,
489: p_level in out nocopy dbms_describe.number_table,
490: p_argument_name in out nocopy dbms_describe.varchar2_table,
491: p_datatype in out nocopy dbms_describe.number_table,
492: p_default_value in out nocopy dbms_describe.number_table,
493: p_in_out in out nocopy dbms_describe.number_table,
494: p_length in out nocopy dbms_describe.number_table,
495: p_precision in out nocopy dbms_describe.number_table,

Line 492: p_default_value in out nocopy dbms_describe.number_table,

488: p_position in out nocopy dbms_describe.number_table,
489: p_level in out nocopy dbms_describe.number_table,
490: p_argument_name in out nocopy dbms_describe.varchar2_table,
491: p_datatype in out nocopy dbms_describe.number_table,
492: p_default_value in out nocopy dbms_describe.number_table,
493: p_in_out in out nocopy dbms_describe.number_table,
494: p_length in out nocopy dbms_describe.number_table,
495: p_precision in out nocopy dbms_describe.number_table,
496: p_scale in out nocopy dbms_describe.number_table,

Line 493: p_in_out in out nocopy dbms_describe.number_table,

489: p_level in out nocopy dbms_describe.number_table,
490: p_argument_name in out nocopy dbms_describe.varchar2_table,
491: p_datatype in out nocopy dbms_describe.number_table,
492: p_default_value in out nocopy dbms_describe.number_table,
493: p_in_out in out nocopy dbms_describe.number_table,
494: p_length in out nocopy dbms_describe.number_table,
495: p_precision in out nocopy dbms_describe.number_table,
496: p_scale in out nocopy dbms_describe.number_table,
497: p_radix in out nocopy dbms_describe.number_table,

Line 494: p_length in out nocopy dbms_describe.number_table,

490: p_argument_name in out nocopy dbms_describe.varchar2_table,
491: p_datatype in out nocopy dbms_describe.number_table,
492: p_default_value in out nocopy dbms_describe.number_table,
493: p_in_out in out nocopy dbms_describe.number_table,
494: p_length in out nocopy dbms_describe.number_table,
495: p_precision in out nocopy dbms_describe.number_table,
496: p_scale in out nocopy dbms_describe.number_table,
497: p_radix in out nocopy dbms_describe.number_table,
498: p_spare in out nocopy dbms_describe.number_table,

Line 495: p_precision in out nocopy dbms_describe.number_table,

491: p_datatype in out nocopy dbms_describe.number_table,
492: p_default_value in out nocopy dbms_describe.number_table,
493: p_in_out in out nocopy dbms_describe.number_table,
494: p_length in out nocopy dbms_describe.number_table,
495: p_precision in out nocopy dbms_describe.number_table,
496: p_scale in out nocopy dbms_describe.number_table,
497: p_radix in out nocopy dbms_describe.number_table,
498: p_spare in out nocopy dbms_describe.number_table,
499: p_apis out nocopy boolean,

Line 496: p_scale in out nocopy dbms_describe.number_table,

492: p_default_value in out nocopy dbms_describe.number_table,
493: p_in_out in out nocopy dbms_describe.number_table,
494: p_length in out nocopy dbms_describe.number_table,
495: p_precision in out nocopy dbms_describe.number_table,
496: p_scale in out nocopy dbms_describe.number_table,
497: p_radix in out nocopy dbms_describe.number_table,
498: p_spare in out nocopy dbms_describe.number_table,
499: p_apis out nocopy boolean,
500: p_parameters out nocopy boolean

Line 497: p_radix in out nocopy dbms_describe.number_table,

493: p_in_out in out nocopy dbms_describe.number_table,
494: p_length in out nocopy dbms_describe.number_table,
495: p_precision in out nocopy dbms_describe.number_table,
496: p_scale in out nocopy dbms_describe.number_table,
497: p_radix in out nocopy dbms_describe.number_table,
498: p_spare in out nocopy dbms_describe.number_table,
499: p_apis out nocopy boolean,
500: p_parameters out nocopy boolean
501: ) is

Line 498: p_spare in out nocopy dbms_describe.number_table,

494: p_length in out nocopy dbms_describe.number_table,
495: p_precision in out nocopy dbms_describe.number_table,
496: p_scale in out nocopy dbms_describe.number_table,
497: p_radix in out nocopy dbms_describe.number_table,
498: p_spare in out nocopy dbms_describe.number_table,
499: p_apis out nocopy boolean,
500: p_parameters out nocopy boolean
501: ) is
502: i binary_integer;

Line 506: l_distinct_overloads dbms_describe.number_table;

502: i binary_integer;
503: j binary_integer;
504: l_chosen_overload number;
505: l_max_mandatory_args number;
506: l_distinct_overloads dbms_describe.number_table;
507: begin
508: if g_debug then
509: hr_utility.trace('Entered get_latest_api.');
510: end if;

Line 680: -- dbms_describe parameters.

676: p_parameter_tbl out nocopy t_parameter_tbl,
677: p_parameter_counts out nocopy t_parameter_counts
678: )
679: is
680: -- dbms_describe parameters.
681: l_overload dbms_describe.number_table;
682: l_position dbms_describe.number_table;
683: l_level dbms_describe.number_table;
684: l_argument_name dbms_describe.varchar2_table;

Line 681: l_overload dbms_describe.number_table;

677: p_parameter_counts out nocopy t_parameter_counts
678: )
679: is
680: -- dbms_describe parameters.
681: l_overload dbms_describe.number_table;
682: l_position dbms_describe.number_table;
683: l_level dbms_describe.number_table;
684: l_argument_name dbms_describe.varchar2_table;
685: l_datatype dbms_describe.number_table;

Line 682: l_position dbms_describe.number_table;

678: )
679: is
680: -- dbms_describe parameters.
681: l_overload dbms_describe.number_table;
682: l_position dbms_describe.number_table;
683: l_level dbms_describe.number_table;
684: l_argument_name dbms_describe.varchar2_table;
685: l_datatype dbms_describe.number_table;
686: l_default_value dbms_describe.number_table;

Line 683: l_level dbms_describe.number_table;

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

Line 684: l_argument_name dbms_describe.varchar2_table;

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

Line 685: l_datatype dbms_describe.number_table;

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

Line 686: l_default_value dbms_describe.number_table;

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

Line 687: l_in_out dbms_describe.number_table;

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

Line 688: l_length dbms_describe.number_table;

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

Line 689: l_precision dbms_describe.number_table;

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

Line 690: l_scale dbms_describe.number_table;

686: l_default_value dbms_describe.number_table;
687: l_in_out dbms_describe.number_table;
688: l_length dbms_describe.number_table;
689: l_precision dbms_describe.number_table;
690: l_scale dbms_describe.number_table;
691: l_radix dbms_describe.number_table;
692: l_spare dbms_describe.number_table;
693: --
694: l_first number;

Line 691: l_radix dbms_describe.number_table;

687: l_in_out dbms_describe.number_table;
688: l_length dbms_describe.number_table;
689: l_precision dbms_describe.number_table;
690: l_scale dbms_describe.number_table;
691: l_radix dbms_describe.number_table;
692: l_spare dbms_describe.number_table;
693: --
694: l_first number;
695: l_last number;

Line 692: l_spare dbms_describe.number_table;

688: l_length dbms_describe.number_table;
689: l_precision dbms_describe.number_table;
690: l_scale dbms_describe.number_table;
691: l_radix dbms_describe.number_table;
692: l_spare dbms_describe.number_table;
693: --
694: l_first number;
695: l_last number;
696: l_seqno number; -- Sequence in dbms_describle list.

Line 742: hr_utility.trace('Successful dbms_describe.');

738: hr_utility.raise_error;
739: end;
740:
741: if g_debug then
742: hr_utility.trace('Successful dbms_describe.');
743: end if;
744:
745: --
746: -- Get the latest overloaded version of the API.

Line 1225: -- dbms_describe parameters.

1221: p_distinct_parameter_tbl in out nocopy t_function_parameter_tbl,
1222: p_parameter_counts in out nocopy t_parameter_counts
1223: )
1224: is
1225: -- dbms_describe parameters.
1226: l_overload dbms_describe.number_table;
1227: l_position dbms_describe.number_table;
1228: l_level dbms_describe.number_table;
1229: l_argument_name dbms_describe.varchar2_table;

Line 1226: l_overload dbms_describe.number_table;

1222: p_parameter_counts in out nocopy t_parameter_counts
1223: )
1224: is
1225: -- dbms_describe parameters.
1226: l_overload dbms_describe.number_table;
1227: l_position dbms_describe.number_table;
1228: l_level dbms_describe.number_table;
1229: l_argument_name dbms_describe.varchar2_table;
1230: l_datatype dbms_describe.number_table;

Line 1227: l_position dbms_describe.number_table;

1223: )
1224: is
1225: -- dbms_describe parameters.
1226: l_overload dbms_describe.number_table;
1227: l_position dbms_describe.number_table;
1228: l_level dbms_describe.number_table;
1229: l_argument_name dbms_describe.varchar2_table;
1230: l_datatype dbms_describe.number_table;
1231: l_default_value dbms_describe.number_table;

Line 1228: l_level dbms_describe.number_table;

1224: is
1225: -- dbms_describe parameters.
1226: l_overload dbms_describe.number_table;
1227: l_position dbms_describe.number_table;
1228: l_level dbms_describe.number_table;
1229: l_argument_name dbms_describe.varchar2_table;
1230: l_datatype dbms_describe.number_table;
1231: l_default_value dbms_describe.number_table;
1232: l_in_out dbms_describe.number_table;

Line 1229: l_argument_name dbms_describe.varchar2_table;

1225: -- dbms_describe parameters.
1226: l_overload dbms_describe.number_table;
1227: l_position dbms_describe.number_table;
1228: l_level dbms_describe.number_table;
1229: l_argument_name dbms_describe.varchar2_table;
1230: l_datatype dbms_describe.number_table;
1231: l_default_value dbms_describe.number_table;
1232: l_in_out dbms_describe.number_table;
1233: l_length dbms_describe.number_table;

Line 1230: l_datatype dbms_describe.number_table;

1226: l_overload dbms_describe.number_table;
1227: l_position dbms_describe.number_table;
1228: l_level dbms_describe.number_table;
1229: l_argument_name dbms_describe.varchar2_table;
1230: l_datatype dbms_describe.number_table;
1231: l_default_value dbms_describe.number_table;
1232: l_in_out dbms_describe.number_table;
1233: l_length dbms_describe.number_table;
1234: l_precision dbms_describe.number_table;

Line 1231: l_default_value dbms_describe.number_table;

1227: l_position dbms_describe.number_table;
1228: l_level dbms_describe.number_table;
1229: l_argument_name dbms_describe.varchar2_table;
1230: l_datatype dbms_describe.number_table;
1231: l_default_value dbms_describe.number_table;
1232: l_in_out dbms_describe.number_table;
1233: l_length dbms_describe.number_table;
1234: l_precision dbms_describe.number_table;
1235: l_scale dbms_describe.number_table;

Line 1232: l_in_out dbms_describe.number_table;

1228: l_level dbms_describe.number_table;
1229: l_argument_name dbms_describe.varchar2_table;
1230: l_datatype dbms_describe.number_table;
1231: l_default_value dbms_describe.number_table;
1232: l_in_out dbms_describe.number_table;
1233: l_length dbms_describe.number_table;
1234: l_precision dbms_describe.number_table;
1235: l_scale dbms_describe.number_table;
1236: l_radix dbms_describe.number_table;

Line 1233: l_length dbms_describe.number_table;

1229: l_argument_name dbms_describe.varchar2_table;
1230: l_datatype dbms_describe.number_table;
1231: l_default_value dbms_describe.number_table;
1232: l_in_out dbms_describe.number_table;
1233: l_length dbms_describe.number_table;
1234: l_precision dbms_describe.number_table;
1235: l_scale dbms_describe.number_table;
1236: l_radix dbms_describe.number_table;
1237: l_spare dbms_describe.number_table;

Line 1234: l_precision dbms_describe.number_table;

1230: l_datatype dbms_describe.number_table;
1231: l_default_value dbms_describe.number_table;
1232: l_in_out dbms_describe.number_table;
1233: l_length dbms_describe.number_table;
1234: l_precision dbms_describe.number_table;
1235: l_scale dbms_describe.number_table;
1236: l_radix dbms_describe.number_table;
1237: l_spare dbms_describe.number_table;
1238: --

Line 1235: l_scale dbms_describe.number_table;

1231: l_default_value dbms_describe.number_table;
1232: l_in_out dbms_describe.number_table;
1233: l_length dbms_describe.number_table;
1234: l_precision dbms_describe.number_table;
1235: l_scale dbms_describe.number_table;
1236: l_radix dbms_describe.number_table;
1237: l_spare dbms_describe.number_table;
1238: --
1239: l_first_overload binary_integer;

Line 1236: l_radix dbms_describe.number_table;

1232: l_in_out dbms_describe.number_table;
1233: l_length dbms_describe.number_table;
1234: l_precision dbms_describe.number_table;
1235: l_scale dbms_describe.number_table;
1236: l_radix dbms_describe.number_table;
1237: l_spare dbms_describe.number_table;
1238: --
1239: l_first_overload binary_integer;
1240: l_seqno binary_integer;

Line 1237: l_spare dbms_describe.number_table;

1233: l_length dbms_describe.number_table;
1234: l_precision dbms_describe.number_table;
1235: l_scale dbms_describe.number_table;
1236: l_radix dbms_describe.number_table;
1237: l_spare dbms_describe.number_table;
1238: --
1239: l_first_overload binary_integer;
1240: l_seqno binary_integer;
1241: l_currpos binary_integer;