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.PAYWSDYG_PKG dependencies on DBMS_DESCRIBE

Line 935: l_overload Dbms_Describe.Number_Table;

931: p_usage IN VARCHAR2,
932: p_validate_only IN BOOLEAN DEFAULT FALSE
933: ) IS
934: --
935: l_overload Dbms_Describe.Number_Table;
936: l_position Dbms_Describe.Number_Table;
937: l_c_level Dbms_Describe.Number_Table;
938: l_arg_name Dbms_Describe.Varchar2_Table;
939: l_dty Dbms_Describe.Number_Table;

Line 936: l_position Dbms_Describe.Number_Table;

932: p_validate_only IN BOOLEAN DEFAULT FALSE
933: ) IS
934: --
935: l_overload Dbms_Describe.Number_Table;
936: l_position Dbms_Describe.Number_Table;
937: l_c_level Dbms_Describe.Number_Table;
938: l_arg_name Dbms_Describe.Varchar2_Table;
939: l_dty Dbms_Describe.Number_Table;
940: l_def_val Dbms_Describe.Number_Table;

Line 937: l_c_level Dbms_Describe.Number_Table;

933: ) IS
934: --
935: l_overload Dbms_Describe.Number_Table;
936: l_position Dbms_Describe.Number_Table;
937: l_c_level Dbms_Describe.Number_Table;
938: l_arg_name Dbms_Describe.Varchar2_Table;
939: l_dty Dbms_Describe.Number_Table;
940: l_def_val Dbms_Describe.Number_Table;
941: l_p_mode Dbms_Describe.Number_Table;

Line 938: l_arg_name Dbms_Describe.Varchar2_Table;

934: --
935: l_overload Dbms_Describe.Number_Table;
936: l_position Dbms_Describe.Number_Table;
937: l_c_level Dbms_Describe.Number_Table;
938: l_arg_name Dbms_Describe.Varchar2_Table;
939: l_dty Dbms_Describe.Number_Table;
940: l_def_val Dbms_Describe.Number_Table;
941: l_p_mode Dbms_Describe.Number_Table;
942: l_length Dbms_Describe.Number_Table;

Line 939: l_dty Dbms_Describe.Number_Table;

935: l_overload Dbms_Describe.Number_Table;
936: l_position Dbms_Describe.Number_Table;
937: l_c_level Dbms_Describe.Number_Table;
938: l_arg_name Dbms_Describe.Varchar2_Table;
939: l_dty Dbms_Describe.Number_Table;
940: l_def_val Dbms_Describe.Number_Table;
941: l_p_mode Dbms_Describe.Number_Table;
942: l_length Dbms_Describe.Number_Table;
943: l_precision Dbms_Describe.Number_Table;

Line 940: l_def_val Dbms_Describe.Number_Table;

936: l_position Dbms_Describe.Number_Table;
937: l_c_level Dbms_Describe.Number_Table;
938: l_arg_name Dbms_Describe.Varchar2_Table;
939: l_dty Dbms_Describe.Number_Table;
940: l_def_val Dbms_Describe.Number_Table;
941: l_p_mode Dbms_Describe.Number_Table;
942: l_length Dbms_Describe.Number_Table;
943: l_precision Dbms_Describe.Number_Table;
944: l_scale Dbms_Describe.Number_Table;

Line 941: l_p_mode Dbms_Describe.Number_Table;

937: l_c_level Dbms_Describe.Number_Table;
938: l_arg_name Dbms_Describe.Varchar2_Table;
939: l_dty Dbms_Describe.Number_Table;
940: l_def_val Dbms_Describe.Number_Table;
941: l_p_mode Dbms_Describe.Number_Table;
942: l_length Dbms_Describe.Number_Table;
943: l_precision Dbms_Describe.Number_Table;
944: l_scale Dbms_Describe.Number_Table;
945: l_radix Dbms_Describe.Number_Table;

Line 942: l_length Dbms_Describe.Number_Table;

938: l_arg_name Dbms_Describe.Varchar2_Table;
939: l_dty Dbms_Describe.Number_Table;
940: l_def_val Dbms_Describe.Number_Table;
941: l_p_mode Dbms_Describe.Number_Table;
942: l_length Dbms_Describe.Number_Table;
943: l_precision Dbms_Describe.Number_Table;
944: l_scale Dbms_Describe.Number_Table;
945: l_radix Dbms_Describe.Number_Table;
946: l_spare Dbms_Describe.Number_Table;

Line 943: l_precision Dbms_Describe.Number_Table;

939: l_dty Dbms_Describe.Number_Table;
940: l_def_val Dbms_Describe.Number_Table;
941: l_p_mode Dbms_Describe.Number_Table;
942: l_length Dbms_Describe.Number_Table;
943: l_precision Dbms_Describe.Number_Table;
944: l_scale Dbms_Describe.Number_Table;
945: l_radix Dbms_Describe.Number_Table;
946: l_spare Dbms_Describe.Number_Table;
947: --

Line 944: l_scale Dbms_Describe.Number_Table;

940: l_def_val Dbms_Describe.Number_Table;
941: l_p_mode Dbms_Describe.Number_Table;
942: l_length Dbms_Describe.Number_Table;
943: l_precision Dbms_Describe.Number_Table;
944: l_scale Dbms_Describe.Number_Table;
945: l_radix Dbms_Describe.Number_Table;
946: l_spare Dbms_Describe.Number_Table;
947: --
948: l_params INTEGER := 0;

Line 945: l_radix Dbms_Describe.Number_Table;

941: l_p_mode Dbms_Describe.Number_Table;
942: l_length Dbms_Describe.Number_Table;
943: l_precision Dbms_Describe.Number_Table;
944: l_scale Dbms_Describe.Number_Table;
945: l_radix Dbms_Describe.Number_Table;
946: l_spare Dbms_Describe.Number_Table;
947: --
948: l_params INTEGER := 0;
949: l_overloaded BOOLEAN := FALSE;

Line 946: l_spare Dbms_Describe.Number_Table;

942: l_length Dbms_Describe.Number_Table;
943: l_precision Dbms_Describe.Number_Table;
944: l_scale Dbms_Describe.Number_Table;
945: l_radix Dbms_Describe.Number_Table;
946: l_spare Dbms_Describe.Number_Table;
947: --
948: l_params INTEGER := 0;
949: l_overloaded BOOLEAN := FALSE;
950: l_weirdtype BOOLEAN := FALSE;

Line 962: Dbms_Describe.Describe_Procedure(

958: BEGIN
959: --
960: -- Lovely Oracle supplied package to describe a stored procedure
961: -- into the tables we declared earlier
962: Dbms_Describe.Describe_Procedure(
963: p_module,
964: null,
965: null,
966: l_overload,

Line 2748: l_overload dbms_describe.number_table;

2744:
2745: -- Local variables to catch the values returned from
2746: -- hr_general.describe_procedure
2747: --
2748: l_overload dbms_describe.number_table;
2749: l_position dbms_describe.number_table;
2750: l_level dbms_describe.number_table;
2751: l_argument_name dbms_describe.varchar2_table;
2752: l_datatype dbms_describe.number_table;

Line 2749: l_position dbms_describe.number_table;

2745: -- Local variables to catch the values returned from
2746: -- hr_general.describe_procedure
2747: --
2748: l_overload dbms_describe.number_table;
2749: l_position dbms_describe.number_table;
2750: l_level dbms_describe.number_table;
2751: l_argument_name dbms_describe.varchar2_table;
2752: l_datatype dbms_describe.number_table;
2753: l_default_value dbms_describe.number_table;

Line 2750: l_level dbms_describe.number_table;

2746: -- hr_general.describe_procedure
2747: --
2748: l_overload dbms_describe.number_table;
2749: l_position dbms_describe.number_table;
2750: l_level dbms_describe.number_table;
2751: l_argument_name dbms_describe.varchar2_table;
2752: l_datatype dbms_describe.number_table;
2753: l_default_value dbms_describe.number_table;
2754: l_in_out dbms_describe.number_table;

Line 2751: l_argument_name dbms_describe.varchar2_table;

2747: --
2748: l_overload dbms_describe.number_table;
2749: l_position dbms_describe.number_table;
2750: l_level dbms_describe.number_table;
2751: l_argument_name dbms_describe.varchar2_table;
2752: l_datatype dbms_describe.number_table;
2753: l_default_value dbms_describe.number_table;
2754: l_in_out dbms_describe.number_table;
2755: l_length dbms_describe.number_table;

Line 2752: l_datatype dbms_describe.number_table;

2748: l_overload dbms_describe.number_table;
2749: l_position dbms_describe.number_table;
2750: l_level dbms_describe.number_table;
2751: l_argument_name dbms_describe.varchar2_table;
2752: l_datatype dbms_describe.number_table;
2753: l_default_value dbms_describe.number_table;
2754: l_in_out dbms_describe.number_table;
2755: l_length dbms_describe.number_table;
2756: l_precision dbms_describe.number_table;

Line 2753: l_default_value dbms_describe.number_table;

2749: l_position dbms_describe.number_table;
2750: l_level dbms_describe.number_table;
2751: l_argument_name dbms_describe.varchar2_table;
2752: l_datatype dbms_describe.number_table;
2753: l_default_value dbms_describe.number_table;
2754: l_in_out dbms_describe.number_table;
2755: l_length dbms_describe.number_table;
2756: l_precision dbms_describe.number_table;
2757: l_scale dbms_describe.number_table;

Line 2754: l_in_out dbms_describe.number_table;

2750: l_level dbms_describe.number_table;
2751: l_argument_name dbms_describe.varchar2_table;
2752: l_datatype dbms_describe.number_table;
2753: l_default_value dbms_describe.number_table;
2754: l_in_out dbms_describe.number_table;
2755: l_length dbms_describe.number_table;
2756: l_precision dbms_describe.number_table;
2757: l_scale dbms_describe.number_table;
2758: l_radix dbms_describe.number_table;

Line 2755: l_length dbms_describe.number_table;

2751: l_argument_name dbms_describe.varchar2_table;
2752: l_datatype dbms_describe.number_table;
2753: l_default_value dbms_describe.number_table;
2754: l_in_out dbms_describe.number_table;
2755: l_length dbms_describe.number_table;
2756: l_precision dbms_describe.number_table;
2757: l_scale dbms_describe.number_table;
2758: l_radix dbms_describe.number_table;
2759: l_spare dbms_describe.number_table;

Line 2756: l_precision dbms_describe.number_table;

2752: l_datatype dbms_describe.number_table;
2753: l_default_value dbms_describe.number_table;
2754: l_in_out dbms_describe.number_table;
2755: l_length dbms_describe.number_table;
2756: l_precision dbms_describe.number_table;
2757: l_scale dbms_describe.number_table;
2758: l_radix dbms_describe.number_table;
2759: l_spare dbms_describe.number_table;
2760:

Line 2757: l_scale dbms_describe.number_table;

2753: l_default_value dbms_describe.number_table;
2754: l_in_out dbms_describe.number_table;
2755: l_length dbms_describe.number_table;
2756: l_precision dbms_describe.number_table;
2757: l_scale dbms_describe.number_table;
2758: l_radix dbms_describe.number_table;
2759: l_spare dbms_describe.number_table;
2760:
2761: l_datatype_str varchar2(20); -- String equivalent of

Line 2758: l_radix dbms_describe.number_table;

2754: l_in_out dbms_describe.number_table;
2755: l_length dbms_describe.number_table;
2756: l_precision dbms_describe.number_table;
2757: l_scale dbms_describe.number_table;
2758: l_radix dbms_describe.number_table;
2759: l_spare dbms_describe.number_table;
2760:
2761: l_datatype_str varchar2(20); -- String equivalent of
2762: -- l_datatype number.

Line 2759: l_spare dbms_describe.number_table;

2755: l_length dbms_describe.number_table;
2756: l_precision dbms_describe.number_table;
2757: l_scale dbms_describe.number_table;
2758: l_radix dbms_describe.number_table;
2759: l_spare dbms_describe.number_table;
2760:
2761: l_datatype_str varchar2(20); -- String equivalent of
2762: -- l_datatype number.
2763: -- Oracle Internal DataType, Parameter, Default Codes and New Line Constants