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

Line 11: -- Global Tables - the same structure as those returned by dbms_describe.

7: g_last NUMBER;
8: g_overload_ind NUMBER := -1;
9: --
10: --
11: -- Global Tables - the same structure as those returned by dbms_describe.
12: -- These will be used to store the results from dbms_describe, until all
13: -- entries have been processed.
14: --
15: g_overload dbms_describe.number_table;

Line 12: -- These will be used to store the results from dbms_describe, until all

8: g_overload_ind NUMBER := -1;
9: --
10: --
11: -- Global Tables - the same structure as those returned by dbms_describe.
12: -- These will be used to store the results from dbms_describe, until all
13: -- entries have been processed.
14: --
15: g_overload dbms_describe.number_table;
16: g_position dbms_describe.number_table;

Line 15: g_overload dbms_describe.number_table;

11: -- Global Tables - the same structure as those returned by dbms_describe.
12: -- These will be used to store the results from dbms_describe, until all
13: -- entries have been processed.
14: --
15: g_overload dbms_describe.number_table;
16: g_position dbms_describe.number_table;
17: g_level dbms_describe.number_table;
18: g_argument_name dbms_describe.varchar2_table;
19: g_datatype dbms_describe.number_table;

Line 16: g_position dbms_describe.number_table;

12: -- These will be used to store the results from dbms_describe, until all
13: -- entries have been processed.
14: --
15: g_overload dbms_describe.number_table;
16: g_position dbms_describe.number_table;
17: g_level dbms_describe.number_table;
18: g_argument_name dbms_describe.varchar2_table;
19: g_datatype dbms_describe.number_table;
20: g_default dbms_describe.number_table;

Line 17: g_level dbms_describe.number_table;

13: -- entries have been processed.
14: --
15: g_overload dbms_describe.number_table;
16: g_position dbms_describe.number_table;
17: g_level dbms_describe.number_table;
18: g_argument_name dbms_describe.varchar2_table;
19: g_datatype dbms_describe.number_table;
20: g_default dbms_describe.number_table;
21: g_in_out dbms_describe.number_table;

Line 18: g_argument_name dbms_describe.varchar2_table;

14: --
15: g_overload dbms_describe.number_table;
16: g_position dbms_describe.number_table;
17: g_level dbms_describe.number_table;
18: g_argument_name dbms_describe.varchar2_table;
19: g_datatype dbms_describe.number_table;
20: g_default dbms_describe.number_table;
21: g_in_out dbms_describe.number_table;
22: g_length dbms_describe.number_table;

Line 19: g_datatype dbms_describe.number_table;

15: g_overload dbms_describe.number_table;
16: g_position dbms_describe.number_table;
17: g_level dbms_describe.number_table;
18: g_argument_name dbms_describe.varchar2_table;
19: g_datatype dbms_describe.number_table;
20: g_default dbms_describe.number_table;
21: g_in_out dbms_describe.number_table;
22: g_length dbms_describe.number_table;
23: g_precision dbms_describe.number_table;

Line 20: g_default dbms_describe.number_table;

16: g_position dbms_describe.number_table;
17: g_level dbms_describe.number_table;
18: g_argument_name dbms_describe.varchar2_table;
19: g_datatype dbms_describe.number_table;
20: g_default dbms_describe.number_table;
21: g_in_out dbms_describe.number_table;
22: g_length dbms_describe.number_table;
23: g_precision dbms_describe.number_table;
24: g_scale dbms_describe.number_table;

Line 21: g_in_out dbms_describe.number_table;

17: g_level dbms_describe.number_table;
18: g_argument_name dbms_describe.varchar2_table;
19: g_datatype dbms_describe.number_table;
20: g_default dbms_describe.number_table;
21: g_in_out dbms_describe.number_table;
22: g_length dbms_describe.number_table;
23: g_precision dbms_describe.number_table;
24: g_scale dbms_describe.number_table;
25: g_radix dbms_describe.number_table;

Line 22: g_length dbms_describe.number_table;

18: g_argument_name dbms_describe.varchar2_table;
19: g_datatype dbms_describe.number_table;
20: g_default dbms_describe.number_table;
21: g_in_out dbms_describe.number_table;
22: g_length dbms_describe.number_table;
23: g_precision dbms_describe.number_table;
24: g_scale dbms_describe.number_table;
25: g_radix dbms_describe.number_table;
26: g_spare dbms_describe.number_table;

Line 23: g_precision dbms_describe.number_table;

19: g_datatype dbms_describe.number_table;
20: g_default dbms_describe.number_table;
21: g_in_out dbms_describe.number_table;
22: g_length dbms_describe.number_table;
23: g_precision dbms_describe.number_table;
24: g_scale dbms_describe.number_table;
25: g_radix dbms_describe.number_table;
26: g_spare dbms_describe.number_table;
27: --

Line 24: g_scale dbms_describe.number_table;

20: g_default dbms_describe.number_table;
21: g_in_out dbms_describe.number_table;
22: g_length dbms_describe.number_table;
23: g_precision dbms_describe.number_table;
24: g_scale dbms_describe.number_table;
25: g_radix dbms_describe.number_table;
26: g_spare dbms_describe.number_table;
27: --
28: --

Line 25: g_radix dbms_describe.number_table;

21: g_in_out dbms_describe.number_table;
22: g_length dbms_describe.number_table;
23: g_precision dbms_describe.number_table;
24: g_scale dbms_describe.number_table;
25: g_radix dbms_describe.number_table;
26: g_spare dbms_describe.number_table;
27: --
28: --
29: -- ---------------------------------------------------------------------------

Line 26: g_spare dbms_describe.number_table;

22: g_length dbms_describe.number_table;
23: g_precision dbms_describe.number_table;
24: g_scale dbms_describe.number_table;
25: g_radix dbms_describe.number_table;
26: g_spare dbms_describe.number_table;
27: --
28: --
29: -- ---------------------------------------------------------------------------
30: -- |-------------------------< set_up_param_info >---------------------------|

Line 35: -- Makes the call to the packaged procedure dbms_describe.describe_procedure,

31: -- ---------------------------------------------------------------------------
32: -- {Start of comments}
33: --
34: -- Description:
35: -- Makes the call to the packaged procedure dbms_describe.describe_procedure,
36: -- which will create tables holding the details of the given procedure from
37: -- the given package. This procedure takes this information, and stores it
38: -- globally, thus making it retrievable by the retrieve_param_details
39: -- procedure.

Line 99: -- Call the dbms_describe in order to populate the global tables.

95: g_last := 1; -- Initialise global parameter counter.
96:
97: BEGIN
98:
99: -- Call the dbms_describe in order to populate the global tables.
100: -- 14-DEC-00: below was changed to use the cover to the dbms_describe
101: -- procedure, provided by hr_general.
102: hr_general.describe_procedure
103: (object_name => p_pkg_name || '.' || p_proc_name

Line 100: -- 14-DEC-00: below was changed to use the cover to the dbms_describe

96:
97: BEGIN
98:
99: -- Call the dbms_describe in order to populate the global tables.
100: -- 14-DEC-00: below was changed to use the cover to the dbms_describe
101: -- procedure, provided by hr_general.
102: hr_general.describe_procedure
103: (object_name => p_pkg_name || '.' || p_proc_name
104: ,reserved1 => null