APPS.XLA_CMP_MPA_JLT_PKG dependencies on DBMS_SQL

Line 507: RETURN DBMS_SQL.VARCHAR2S

503: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
504: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
505: , p_IsCompiled OUT NOCOPY BOOLEAN
506: )
507: RETURN DBMS_SQL.VARCHAR2S
508: IS
509: --
510: l_parameters VARCHAR2(32000);
511:

Line 514: l_array_jlt DBMS_SQL.VARCHAR2S;

510: l_parameters VARCHAR2(32000);
511:
512: l_jlt CLOB;
513: l_ObjectIndex BINARY_INTEGER;
514: l_array_jlt DBMS_SQL.VARCHAR2S;
515:
516: l_array_mpa_jlt_source_index xla_cmp_source_pkg.t_array_ByInt;
517: l_array_null_mpa_jlt_src_idx xla_cmp_source_pkg.t_array_ByInt;
518: l_log_module VARCHAR2(240);

Line 736: RETURN DBMS_SQL.VARCHAR2S

732: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
733: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
734: , p_IsCompiled OUT NOCOPY BOOLEAN
735: )
736: RETURN DBMS_SQL.VARCHAR2S
737: IS
738: --
739: -- Retrieve all recognition JLT
740: --

Line 845: l_body DBMS_SQL.VARCHAR2S;

841: xmja.mpa_accounting_line_type_code, xmja.mpa_accounting_line_code
842: ;
843: --
844: --
845: l_body DBMS_SQL.VARCHAR2S;
846: l_jlt DBMS_SQL.VARCHAR2S;
847: --
848: l_array_mpa_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
849: l_array_mpa_jlt_code xla_cmp_source_pkg.t_array_VL30;

Line 846: l_jlt DBMS_SQL.VARCHAR2S;

842: ;
843: --
844: --
845: l_body DBMS_SQL.VARCHAR2S;
846: l_jlt DBMS_SQL.VARCHAR2S;
847: --
848: l_array_mpa_jlt_type_code xla_cmp_source_pkg.t_array_VL1;
849: l_array_mpa_jlt_code xla_cmp_source_pkg.t_array_VL30;
850: l_array_mpa_jlt_name xla_cmp_source_pkg.t_array_VL80;

Line 1021: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

1017: , p_amb_context_code IN VARCHAR2
1018: , p_package_name IN VARCHAR2
1019: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1020: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1021: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
1022: )
1023: RETURN BOOLEAN
1024: IS
1025:

Line 1027: l_body DBMS_SQL.VARCHAR2S;

1023: RETURN BOOLEAN
1024: IS
1025:
1026: l_IsCompiled BOOLEAN;
1027: l_body DBMS_SQL.VARCHAR2S;
1028: l_log_module VARCHAR2(240);
1029:
1030: BEGIN
1031: IF g_log_enabled THEN