DBA Data[Home] [Help]

APPS.XLA_CMP_ACCT_LINE_TYPE_PKG dependencies on DBMS_SQL

Line 3663: | result in DBMS_SQL.VARCHAR2S datatype |

3659: | |
3660: | GenerateOneAcctLineType |
3661: | |
3662: | Generates AcctLineType_xxx() procedure and returns the |
3663: | result in DBMS_SQL.VARCHAR2S datatype |
3664: | |
3665: +---------------------------------------------------------*/
3666:
3667: FUNCTION GenerateOneAcctLineType(

Line 3711: RETURN DBMS_SQL.VARCHAR2S

3707: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3708: --
3709: , p_IsCompiled OUT NOCOPY BOOLEAN
3710: )
3711: RETURN DBMS_SQL.VARCHAR2S
3712: IS
3713: --
3714:
3715: l_alt CLOB;

Line 3721: l_array_alt DBMS_SQL.VARCHAR2S;

3717: l_IsCompiled BOOLEAN;
3718: l_array_alt_source_index xla_cmp_source_pkg.t_array_ByInt;
3719: l_array_null_alt_source_idx xla_cmp_source_pkg.t_array_ByInt;
3720: --
3721: l_array_alt DBMS_SQL.VARCHAR2S;
3722: l_log_module VARCHAR2(240);
3723: --
3724: BEGIN
3725: IF g_log_enabled THEN

Line 3872: RETURN DBMS_SQL.VARCHAR2S

3868: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3869: --
3870: , p_IsCompiled IN OUT NOCOPY BOOLEAN
3871: )
3872: RETURN DBMS_SQL.VARCHAR2S
3873: IS
3874: --
3875: --
3876: CURSOR alt_cur

Line 3972: l_AcctlineTypes DBMS_SQL.VARCHAR2S;

3968: ORDER BY xldj.accounting_line_type_code, xldj.accounting_line_code
3969: ;
3970: --
3971: --
3972: l_AcctlineTypes DBMS_SQL.VARCHAR2S;
3973: l_array_alt DBMS_SQL.VARCHAR2S;
3974: --
3975: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;
3976: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;

Line 3973: l_array_alt DBMS_SQL.VARCHAR2S;

3969: ;
3970: --
3971: --
3972: l_AcctlineTypes DBMS_SQL.VARCHAR2S;
3973: l_array_alt DBMS_SQL.VARCHAR2S;
3974: --
3975: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;
3976: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;
3977: l_array_alt_name xla_cmp_source_pkg.t_array_VL80;

Line 4207: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

4203: , p_amb_context_code IN VARCHAR2
4204: , p_package_name IN VARCHAR2
4205: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
4206: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4207: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
4208: )
4209: RETURN BOOLEAN
4210: IS
4211: l_AcctLineTypes DBMS_SQL.VARCHAR2S;

Line 4211: l_AcctLineTypes DBMS_SQL.VARCHAR2S;

4207: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
4208: )
4209: RETURN BOOLEAN
4210: IS
4211: l_AcctLineTypes DBMS_SQL.VARCHAR2S;
4212: l_IsCompiled BOOLEAN;
4213: l_log_module VARCHAR2(240);
4214: BEGIN
4215: IF g_log_enabled THEN