272: --
273: -- Local variables to catch the values returned from
274: -- hr_general.describe_procedure
275: --
276: l_overload dbms_describe.number_table;
277: l_position dbms_describe.number_table;
278: l_level dbms_describe.number_table;
279: l_argument_name dbms_describe.varchar2_table;
280: l_datatype dbms_describe.number_table;
273: -- Local variables to catch the values returned from
274: -- hr_general.describe_procedure
275: --
276: l_overload dbms_describe.number_table;
277: l_position dbms_describe.number_table;
278: l_level dbms_describe.number_table;
279: l_argument_name dbms_describe.varchar2_table;
280: l_datatype dbms_describe.number_table;
281: l_default_value dbms_describe.number_table;
274: -- hr_general.describe_procedure
275: --
276: l_overload dbms_describe.number_table;
277: l_position dbms_describe.number_table;
278: l_level dbms_describe.number_table;
279: l_argument_name dbms_describe.varchar2_table;
280: l_datatype dbms_describe.number_table;
281: l_default_value dbms_describe.number_table;
282: l_in_out dbms_describe.number_table;
275: --
276: l_overload dbms_describe.number_table;
277: l_position dbms_describe.number_table;
278: l_level dbms_describe.number_table;
279: l_argument_name dbms_describe.varchar2_table;
280: l_datatype dbms_describe.number_table;
281: l_default_value dbms_describe.number_table;
282: l_in_out dbms_describe.number_table;
283: l_length dbms_describe.number_table;
276: l_overload dbms_describe.number_table;
277: l_position dbms_describe.number_table;
278: l_level dbms_describe.number_table;
279: l_argument_name dbms_describe.varchar2_table;
280: l_datatype dbms_describe.number_table;
281: l_default_value dbms_describe.number_table;
282: l_in_out dbms_describe.number_table;
283: l_length dbms_describe.number_table;
284: l_precision dbms_describe.number_table;
277: l_position dbms_describe.number_table;
278: l_level dbms_describe.number_table;
279: l_argument_name dbms_describe.varchar2_table;
280: l_datatype dbms_describe.number_table;
281: l_default_value dbms_describe.number_table;
282: l_in_out dbms_describe.number_table;
283: l_length dbms_describe.number_table;
284: l_precision dbms_describe.number_table;
285: l_scale dbms_describe.number_table;
278: l_level dbms_describe.number_table;
279: l_argument_name dbms_describe.varchar2_table;
280: l_datatype dbms_describe.number_table;
281: l_default_value dbms_describe.number_table;
282: l_in_out dbms_describe.number_table;
283: l_length dbms_describe.number_table;
284: l_precision dbms_describe.number_table;
285: l_scale dbms_describe.number_table;
286: l_radix dbms_describe.number_table;
279: l_argument_name dbms_describe.varchar2_table;
280: l_datatype dbms_describe.number_table;
281: l_default_value dbms_describe.number_table;
282: l_in_out dbms_describe.number_table;
283: l_length dbms_describe.number_table;
284: l_precision dbms_describe.number_table;
285: l_scale dbms_describe.number_table;
286: l_radix dbms_describe.number_table;
287: l_spare dbms_describe.number_table;
280: l_datatype dbms_describe.number_table;
281: l_default_value dbms_describe.number_table;
282: l_in_out dbms_describe.number_table;
283: l_length dbms_describe.number_table;
284: l_precision dbms_describe.number_table;
285: l_scale dbms_describe.number_table;
286: l_radix dbms_describe.number_table;
287: l_spare dbms_describe.number_table;
288: --
281: l_default_value dbms_describe.number_table;
282: l_in_out dbms_describe.number_table;
283: l_length dbms_describe.number_table;
284: l_precision dbms_describe.number_table;
285: l_scale dbms_describe.number_table;
286: l_radix dbms_describe.number_table;
287: l_spare dbms_describe.number_table;
288: --
289: -- Other Local variables
282: l_in_out dbms_describe.number_table;
283: l_length dbms_describe.number_table;
284: l_precision dbms_describe.number_table;
285: l_scale dbms_describe.number_table;
286: l_radix dbms_describe.number_table;
287: l_spare dbms_describe.number_table;
288: --
289: -- Other Local variables
290: --
283: l_length dbms_describe.number_table;
284: l_precision dbms_describe.number_table;
285: l_scale dbms_describe.number_table;
286: l_radix dbms_describe.number_table;
287: l_spare dbms_describe.number_table;
288: --
289: -- Other Local variables
290: --
291: l_param_details varchar2(80); -- Used to construct the user descriptions