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.XLA_CMP_DESCRIPTION_PKG dependencies on DBMS_SQL

Line 666: RETURN DBMS_SQL.VARCHAR2S

662: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
663: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
664: , p_IsCompiled IN OUT NOCOPY BOOLEAN
665: )
666: RETURN DBMS_SQL.VARCHAR2S
667: IS
668:
669: l_array_desc DBMS_SQL.VARCHAR2S;
670: l_null_array_desc DBMS_SQL.VARCHAR2S;

Line 669: l_array_desc DBMS_SQL.VARCHAR2S;

665: )
666: RETURN DBMS_SQL.VARCHAR2S
667: IS
668:
669: l_array_desc DBMS_SQL.VARCHAR2S;
670: l_null_array_desc DBMS_SQL.VARCHAR2S;
671: l_description CLOB;
672: l_description_code VARCHAR2(30);
673: l_array_desc_source_index xla_cmp_source_pkg.t_array_ByInt;

Line 670: l_null_array_desc DBMS_SQL.VARCHAR2S;

666: RETURN DBMS_SQL.VARCHAR2S
667: IS
668:
669: l_array_desc DBMS_SQL.VARCHAR2S;
670: l_null_array_desc DBMS_SQL.VARCHAR2S;
671: l_description CLOB;
672: l_description_code VARCHAR2(30);
673: l_array_desc_source_index xla_cmp_source_pkg.t_array_ByInt;
674: l_log_module VARCHAR2(240);

Line 792: RETURN DBMS_SQL.VARCHAR2S

788: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
789: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
790: , p_IsCompiled IN OUT NOCOPY BOOLEAN
791: )
792: RETURN DBMS_SQL.VARCHAR2S
793: IS
794:
795:
796: CURSOR description_cur

Line 1024: l_descriptions DBMS_SQL.VARCHAR2S;

1020: l_array_desc_code xla_cmp_source_pkg.t_array_VL30;
1021: l_array_desc_name xla_cmp_source_pkg.t_array_VL80;
1022: l_array_desc_owner xla_cmp_source_pkg.t_array_VL1;
1023:
1024: l_descriptions DBMS_SQL.VARCHAR2S;
1025: l_null_descriptions DBMS_SQL.VARCHAR2S;
1026:
1027: l_IsCompiled BOOLEAN;
1028: l_log_module VARCHAR2(240);

Line 1025: l_null_descriptions DBMS_SQL.VARCHAR2S;

1021: l_array_desc_name xla_cmp_source_pkg.t_array_VL80;
1022: l_array_desc_owner xla_cmp_source_pkg.t_array_VL1;
1023:
1024: l_descriptions DBMS_SQL.VARCHAR2S;
1025: l_null_descriptions DBMS_SQL.VARCHAR2S;
1026:
1027: l_IsCompiled BOOLEAN;
1028: l_log_module VARCHAR2(240);
1029: BEGIN

Line 1141: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

1137: , p_amb_context_code IN VARCHAR2
1138: , p_package_name IN VARCHAR2
1139: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1140: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1141: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
1142: )
1143: RETURN BOOLEAN
1144: IS
1145: l_descriptions DBMS_SQL.VARCHAR2S;

Line 1145: l_descriptions DBMS_SQL.VARCHAR2S;

1141: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
1142: )
1143: RETURN BOOLEAN
1144: IS
1145: l_descriptions DBMS_SQL.VARCHAR2S;
1146: l_null_descriptions DBMS_SQL.VARCHAR2S;
1147: l_IsCompiled BOOLEAN;
1148: p_IsCompiled BOOLEAN;
1149: l_log_module VARCHAR2(240);

Line 1146: l_null_descriptions DBMS_SQL.VARCHAR2S;

1142: )
1143: RETURN BOOLEAN
1144: IS
1145: l_descriptions DBMS_SQL.VARCHAR2S;
1146: l_null_descriptions DBMS_SQL.VARCHAR2S;
1147: l_IsCompiled BOOLEAN;
1148: p_IsCompiled BOOLEAN;
1149: l_log_module VARCHAR2(240);
1150: BEGIN