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

2781:
2782: -- Local variables to catch the values returned from
2783: -- hr_general.describe_procedure
2784: --
2785: l_overload dbms_describe.number_table;
2786: l_position dbms_describe.number_table;
2787: l_level dbms_describe.number_table;
2788: l_argument_name dbms_describe.varchar2_table;
2789: l_datatype dbms_describe.number_table;

Line 2786: l_position dbms_describe.number_table;

2782: -- Local variables to catch the values returned from
2783: -- hr_general.describe_procedure
2784: --
2785: l_overload dbms_describe.number_table;
2786: l_position dbms_describe.number_table;
2787: l_level dbms_describe.number_table;
2788: l_argument_name dbms_describe.varchar2_table;
2789: l_datatype dbms_describe.number_table;
2790: l_default_value dbms_describe.number_table;

Line 2787: l_level dbms_describe.number_table;

2783: -- hr_general.describe_procedure
2784: --
2785: l_overload dbms_describe.number_table;
2786: l_position dbms_describe.number_table;
2787: l_level dbms_describe.number_table;
2788: l_argument_name dbms_describe.varchar2_table;
2789: l_datatype dbms_describe.number_table;
2790: l_default_value dbms_describe.number_table;
2791: l_in_out dbms_describe.number_table;

Line 2788: l_argument_name dbms_describe.varchar2_table;

2784: --
2785: l_overload dbms_describe.number_table;
2786: l_position dbms_describe.number_table;
2787: l_level dbms_describe.number_table;
2788: l_argument_name dbms_describe.varchar2_table;
2789: l_datatype dbms_describe.number_table;
2790: l_default_value dbms_describe.number_table;
2791: l_in_out dbms_describe.number_table;
2792: l_length dbms_describe.number_table;

Line 2789: l_datatype dbms_describe.number_table;

2785: l_overload dbms_describe.number_table;
2786: l_position dbms_describe.number_table;
2787: l_level dbms_describe.number_table;
2788: l_argument_name dbms_describe.varchar2_table;
2789: l_datatype dbms_describe.number_table;
2790: l_default_value dbms_describe.number_table;
2791: l_in_out dbms_describe.number_table;
2792: l_length dbms_describe.number_table;
2793: l_precision dbms_describe.number_table;

Line 2790: l_default_value dbms_describe.number_table;

2786: l_position dbms_describe.number_table;
2787: l_level dbms_describe.number_table;
2788: l_argument_name dbms_describe.varchar2_table;
2789: l_datatype dbms_describe.number_table;
2790: l_default_value dbms_describe.number_table;
2791: l_in_out dbms_describe.number_table;
2792: l_length dbms_describe.number_table;
2793: l_precision dbms_describe.number_table;
2794: l_scale dbms_describe.number_table;

Line 2791: l_in_out dbms_describe.number_table;

2787: l_level dbms_describe.number_table;
2788: l_argument_name dbms_describe.varchar2_table;
2789: l_datatype dbms_describe.number_table;
2790: l_default_value dbms_describe.number_table;
2791: l_in_out dbms_describe.number_table;
2792: l_length dbms_describe.number_table;
2793: l_precision dbms_describe.number_table;
2794: l_scale dbms_describe.number_table;
2795: l_radix dbms_describe.number_table;

Line 2792: l_length dbms_describe.number_table;

2788: l_argument_name dbms_describe.varchar2_table;
2789: l_datatype dbms_describe.number_table;
2790: l_default_value dbms_describe.number_table;
2791: l_in_out dbms_describe.number_table;
2792: l_length dbms_describe.number_table;
2793: l_precision dbms_describe.number_table;
2794: l_scale dbms_describe.number_table;
2795: l_radix dbms_describe.number_table;
2796: l_spare dbms_describe.number_table;

Line 2793: l_precision dbms_describe.number_table;

2789: l_datatype dbms_describe.number_table;
2790: l_default_value dbms_describe.number_table;
2791: l_in_out dbms_describe.number_table;
2792: l_length dbms_describe.number_table;
2793: l_precision dbms_describe.number_table;
2794: l_scale dbms_describe.number_table;
2795: l_radix dbms_describe.number_table;
2796: l_spare dbms_describe.number_table;
2797:

Line 2794: l_scale dbms_describe.number_table;

2790: l_default_value dbms_describe.number_table;
2791: l_in_out dbms_describe.number_table;
2792: l_length dbms_describe.number_table;
2793: l_precision dbms_describe.number_table;
2794: l_scale dbms_describe.number_table;
2795: l_radix dbms_describe.number_table;
2796: l_spare dbms_describe.number_table;
2797:
2798: l_datatype_str varchar2(20); -- String equivalent of

Line 2795: l_radix dbms_describe.number_table;

2791: l_in_out dbms_describe.number_table;
2792: l_length dbms_describe.number_table;
2793: l_precision dbms_describe.number_table;
2794: l_scale dbms_describe.number_table;
2795: l_radix dbms_describe.number_table;
2796: l_spare dbms_describe.number_table;
2797:
2798: l_datatype_str varchar2(20); -- String equivalent of
2799: -- l_datatype number.

Line 2796: l_spare dbms_describe.number_table;

2792: l_length dbms_describe.number_table;
2793: l_precision dbms_describe.number_table;
2794: l_scale dbms_describe.number_table;
2795: l_radix dbms_describe.number_table;
2796: l_spare dbms_describe.number_table;
2797:
2798: l_datatype_str varchar2(20); -- String equivalent of
2799: -- l_datatype number.
2800: -- Oracle Internal DataType, Parameter, Default Codes and New Line Constants