APPS.XLA_CMP_ADR_PKG dependencies on DBMS_SQL

Line 1996: | Generates AcctDerRule_XX() function in DBMS_SQL.VARCHAR2S |

1992: | Private function |
1993: | |
1994: | generate_one_adr_fct |
1995: | |
1996: | Generates AcctDerRule_XX() function in DBMS_SQL.VARCHAR2S |
1997: | |
1998: +-------------------------------------------------------------*/
1999:
2000: FUNCTION generate_one_adr_fct(

Line 2017: RETURN DBMS_SQL.VARCHAR2S

2013: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2014: --
2015: , p_IsCompiled OUT NOCOPY BOOLEAN
2016: )
2017: RETURN DBMS_SQL.VARCHAR2S
2018: IS
2019: --
2020: l_array_adr_source_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_null_adr_source_Idx xla_cmp_source_pkg.t_array_ByInt;

Line 2025: l_array_adr DBMS_SQL.VARCHAR2S;

2021: l_array_null_adr_source_Idx xla_cmp_source_pkg.t_array_ByInt;
2022: --
2023: l_adr_code VARCHAR2(30);
2024: l_Adr CLOB; -- 4697330
2025: l_array_adr DBMS_SQL.VARCHAR2S;
2026: l_log_module VARCHAR2(240);
2027: --
2028: BEGIN
2029: IF g_log_enabled THEN

Line 2087: -- create the PL/SQL DBMS_SQL.VARCHAR2S array

2083: );
2084: --
2085: l_Adr := xla_cmp_string_pkg.replace_token(l_Adr,'$package_name$',g_package_name);
2086: --
2087: -- create the PL/SQL DBMS_SQL.VARCHAR2S array
2088: --
2089: xla_cmp_string_pkg.CreateString(
2090: p_package_text => l_Adr
2091: ,p_array_string => l_array_adr

Line 2149: RETURN DBMS_SQL.VARCHAR2S

2145: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2146: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2147: , p_IsCompiled IN OUT NOCOPY BOOLEAN
2148: )
2149: RETURN DBMS_SQL.VARCHAR2S
2150: IS
2151: --
2152: --
2153: CURSOR adr_cur

Line 2287: l_null_array_string DBMS_SQL.VARCHAR2S;

2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;
2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;
2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;
2286: --
2287: l_null_array_string DBMS_SQL.VARCHAR2S;
2288: l_array_string DBMS_SQL.VARCHAR2S;
2289: l_Adrs DBMS_SQL.VARCHAR2S;
2290: --
2291: l_IsCompiled BOOLEAN;

Line 2288: l_array_string DBMS_SQL.VARCHAR2S;

2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;
2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;
2286: --
2287: l_null_array_string DBMS_SQL.VARCHAR2S;
2288: l_array_string DBMS_SQL.VARCHAR2S;
2289: l_Adrs DBMS_SQL.VARCHAR2S;
2290: --
2291: l_IsCompiled BOOLEAN;
2292: l_log_module VARCHAR2(240);

Line 2289: l_Adrs DBMS_SQL.VARCHAR2S;

2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;
2286: --
2287: l_null_array_string DBMS_SQL.VARCHAR2S;
2288: l_array_string DBMS_SQL.VARCHAR2S;
2289: l_Adrs DBMS_SQL.VARCHAR2S;
2290: --
2291: l_IsCompiled BOOLEAN;
2292: l_log_module VARCHAR2(240);
2293: --

Line 2421: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

2417: --
2418: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2419: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2420: --
2421: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
2422: )
2423: RETURN BOOLEAN
2424: IS
2425: l_Adrs DBMS_SQL.VARCHAR2S;

Line 2425: l_Adrs DBMS_SQL.VARCHAR2S;

2421: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
2422: )
2423: RETURN BOOLEAN
2424: IS
2425: l_Adrs DBMS_SQL.VARCHAR2S;
2426: l_IsCompiled BOOLEAN;
2427: l_log_module VARCHAR2(240);
2428: --
2429: BEGIN

Line 2726: l_array_adr DBMS_SQL.VARCHAR2S;

2722:
2723: l_adr_code VARCHAR2(30);
2724: l_adr_body VARCHAR2(32000);
2725: l_parms VARCHAR2(10000);
2726: l_array_adr DBMS_SQL.VARCHAR2S;
2727: l_IsCompiled BOOLEAN;
2728:
2729: l_fatal_error_message_text VARCHAR2(240);
2730: l_adr_function_name VARCHAR2(30);

Line 2955: l_array_string DBMS_SQL.VARCHAR2S;

2951: l_rec_aad_objects xla_cmp_source_pkg.t_rec_aad_objects ;
2952: l_rec_sources xla_cmp_source_pkg.t_rec_sources;
2953:
2954:
2955: l_array_string DBMS_SQL.VARCHAR2S;
2956:
2957: l_adr_spec CLOB;
2958: l_adr_body CLOB;
2959: