DBA Data[Home] [Help]

APPS.XLA_CMP_ACCT_LINE_TYPE_PKG dependencies on DBMS_SQL

Line 3693: | result in DBMS_SQL.VARCHAR2S datatype |

3689: | |
3690: | GenerateOneAcctLineType |
3691: | |
3692: | Generates AcctLineType_xxx() procedure and returns the |
3693: | result in DBMS_SQL.VARCHAR2S datatype |
3694: | |
3695: +---------------------------------------------------------*/
3696:
3697: FUNCTION GenerateOneAcctLineType(

Line 3741: RETURN DBMS_SQL.VARCHAR2S

3737: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3738: --
3739: , p_IsCompiled OUT NOCOPY BOOLEAN
3740: )
3741: RETURN DBMS_SQL.VARCHAR2S
3742: IS
3743: --
3744:
3745: l_alt CLOB;

Line 3751: l_array_alt DBMS_SQL.VARCHAR2S;

3747: l_IsCompiled BOOLEAN;
3748: l_array_alt_source_index xla_cmp_source_pkg.t_array_ByInt;
3749: l_array_null_alt_source_idx xla_cmp_source_pkg.t_array_ByInt;
3750: --
3751: l_array_alt DBMS_SQL.VARCHAR2S;
3752: l_log_module VARCHAR2(240);
3753: --
3754: BEGIN
3755: IF g_log_enabled THEN

Line 3902: RETURN DBMS_SQL.VARCHAR2S

3898: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3899: --
3900: , p_IsCompiled IN OUT NOCOPY BOOLEAN
3901: )
3902: RETURN DBMS_SQL.VARCHAR2S
3903: IS
3904: --
3905: --
3906: CURSOR alt_cur

Line 4002: l_AcctlineTypes DBMS_SQL.VARCHAR2S;

3998: ORDER BY xldj.accounting_line_type_code, xldj.accounting_line_code
3999: ;
4000: --
4001: --
4002: l_AcctlineTypes DBMS_SQL.VARCHAR2S;
4003: l_array_alt DBMS_SQL.VARCHAR2S;
4004: --
4005: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;
4006: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;

Line 4003: l_array_alt DBMS_SQL.VARCHAR2S;

3999: ;
4000: --
4001: --
4002: l_AcctlineTypes DBMS_SQL.VARCHAR2S;
4003: l_array_alt DBMS_SQL.VARCHAR2S;
4004: --
4005: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;
4006: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;
4007: l_array_alt_name xla_cmp_source_pkg.t_array_VL80;

Line 4237: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

4233: , p_amb_context_code IN VARCHAR2
4234: , p_package_name IN VARCHAR2
4235: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
4236: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4237: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
4238: )
4239: RETURN BOOLEAN
4240: IS
4241: l_AcctLineTypes DBMS_SQL.VARCHAR2S;

Line 4241: l_AcctLineTypes DBMS_SQL.VARCHAR2S;

4237: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
4238: )
4239: RETURN BOOLEAN
4240: IS
4241: l_AcctLineTypes DBMS_SQL.VARCHAR2S;
4242: l_IsCompiled BOOLEAN;
4243: l_log_module VARCHAR2(240);
4244: BEGIN
4245: IF g_log_enabled THEN