3183: ,p_account_definition_type_code IN VARCHAR2
3184: ,p_amb_context_code IN VARCHAR2
3185: ,p_package_name IN VARCHAR2
3186: ,p_table_of_tad_details IN gt_table_of_tad_details
3187: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
3188: ,p_adr_specs_text IN CLOB
3189: )
3190: RETURN BOOLEAN;
3191:
3196: ,p_amb_context_code IN VARCHAR2
3197: ,p_package_name IN VARCHAR2
3198: ,p_tad_coa_id IN NUMBER
3199: ,p_table_of_tad_details IN gt_table_of_tad_details
3200: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
3201: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
3202: ,p_adr_bodies_text IN CLOB
3203: )
3204: RETURN BOOLEAN;
3197: ,p_package_name IN VARCHAR2
3198: ,p_tad_coa_id IN NUMBER
3199: ,p_table_of_tad_details IN gt_table_of_tad_details
3200: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
3201: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
3202: ,p_adr_bodies_text IN CLOB
3203: )
3204: RETURN BOOLEAN;
3205:
3209: ,p_account_definition_type_code IN VARCHAR2
3210: ,p_amb_context_code IN VARCHAR2
3211: ,p_package_name IN VARCHAR2
3212: ,p_table_of_tad_details IN gt_table_of_tad_details
3213: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
3214: ,p_adr_specs_text IN CLOB
3215: ,p_package_spec_text OUT NOCOPY CLOB
3216: )
3217: RETURN BOOLEAN;
3223: ,p_amb_context_code IN VARCHAR2
3224: ,p_package_name IN VARCHAR2
3225: ,p_tad_coa_id IN NUMBER
3226: ,p_table_of_tad_details IN gt_table_of_tad_details
3227: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
3228: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
3229: ,p_adr_bodies_text IN CLOB
3230: ,p_package_body_text OUT NOCOPY CLOB
3231: )
3224: ,p_package_name IN VARCHAR2
3225: ,p_tad_coa_id IN NUMBER
3226: ,p_table_of_tad_details IN gt_table_of_tad_details
3227: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
3228: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
3229: ,p_adr_bodies_text IN CLOB
3230: ,p_package_body_text OUT NOCOPY CLOB
3231: )
3232: RETURN BOOLEAN;
3239:
3240: FUNCTION build_batch_update_statements
3241: (
3242: p_table_of_tad_details IN gt_table_of_tad_details
3243: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
3244: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
3245: ,p_update_statements_text OUT NOCOPY CLOB
3246: )
3247: RETURN BOOLEAN;
3240: FUNCTION build_batch_update_statements
3241: (
3242: p_table_of_tad_details IN gt_table_of_tad_details
3243: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
3244: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
3245: ,p_update_statements_text OUT NOCOPY CLOB
3246: )
3247: RETURN BOOLEAN;
3248:
3717: l_tad_package_name VARCHAR2(30);
3718: l_tad_name VARCHAR2(80);
3719: l_tad_enabled_flag VARCHAR2(1);
3720: l_table_of_tad_details gt_table_of_tad_details;
3721: l_table_of_adrs xla_cmp_adr_pkg.gt_table_of_adrs_in;
3722: l_table_of_adrs_ext xla_cmp_adr_pkg.gt_table_of_adrs_out;
3723: l_adr_specs CLOB;
3724: l_adr_bodies CLOB;
3725: l_final_compile_status_code VARCHAR2(1);
3718: l_tad_name VARCHAR2(80);
3719: l_tad_enabled_flag VARCHAR2(1);
3720: l_table_of_tad_details gt_table_of_tad_details;
3721: l_table_of_adrs xla_cmp_adr_pkg.gt_table_of_adrs_in;
3722: l_table_of_adrs_ext xla_cmp_adr_pkg.gt_table_of_adrs_out;
3723: l_adr_specs CLOB;
3724: l_adr_bodies CLOB;
3725: l_final_compile_status_code VARCHAR2(1);
3726:
4043: END IF;
4044: END IF;
4045:
4046: --Build the specifications and the bodies of the adrs
4047: IF NOT xla_cmp_adr_pkg.build_adrs_for_tab
4048: (
4049: p_table_of_adrs_in => l_table_of_adrs
4050: ,x_table_of_adrs_out => l_table_of_adrs_ext
4051: ,x_adr_specs_text => l_adr_specs
4054: THEN
4055: IF (C_LEVEL_ERROR >= g_log_level) THEN
4056: trace
4057: (p_module => l_log_module
4058: ,p_msg => 'xla_cmp_adr_pkg.build_adrs_for_tad failed'
4059: ,p_level => C_LEVEL_ERROR);
4060: END IF;
4061: l_return_value := FALSE;
4062: RAISE ge_fatal_error;
4381: ,p_account_definition_type_code IN VARCHAR2
4382: ,p_amb_context_code IN VARCHAR2
4383: ,p_package_name IN VARCHAR2
4384: ,p_table_of_tad_details IN gt_table_of_tad_details
4385: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
4386: ,p_adr_specs_text IN CLOB
4387: )
4388: RETURN BOOLEAN
4389: IS
4507: ,p_account_definition_type_code IN VARCHAR2
4508: ,p_amb_context_code IN VARCHAR2
4509: ,p_package_name IN VARCHAR2
4510: ,p_table_of_tad_details IN gt_table_of_tad_details
4511: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
4512: ,p_adr_specs_text IN CLOB
4513: ,p_package_spec_text OUT NOCOPY CLOB
4514: )
4515: RETURN BOOLEAN
4749: ,p_amb_context_code IN VARCHAR2
4750: ,p_package_name IN VARCHAR2
4751: ,p_tad_coa_id IN NUMBER
4752: ,p_table_of_tad_details IN gt_table_of_tad_details
4753: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
4754: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
4755: ,p_adr_bodies_text IN CLOB
4756: )
4757: RETURN BOOLEAN
4750: ,p_package_name IN VARCHAR2
4751: ,p_tad_coa_id IN NUMBER
4752: ,p_table_of_tad_details IN gt_table_of_tad_details
4753: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
4754: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
4755: ,p_adr_bodies_text IN CLOB
4756: )
4757: RETURN BOOLEAN
4758: IS
4884: ,p_amb_context_code IN VARCHAR2
4885: ,p_package_name IN VARCHAR2
4886: ,p_tad_coa_id IN NUMBER
4887: ,p_table_of_tad_details IN gt_table_of_tad_details
4888: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
4889: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
4890: ,p_adr_bodies_text IN CLOB
4891: ,p_package_body_text OUT NOCOPY CLOB
4892: )
4885: ,p_package_name IN VARCHAR2
4886: ,p_tad_coa_id IN NUMBER
4887: ,p_table_of_tad_details IN gt_table_of_tad_details
4888: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
4889: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
4890: ,p_adr_bodies_text IN CLOB
4891: ,p_package_body_text OUT NOCOPY CLOB
4892: )
4893: RETURN BOOLEAN
5190: +======================================================================*/
5191: FUNCTION build_batch_update_statements
5192: (
5193: p_table_of_tad_details IN gt_table_of_tad_details
5194: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
5195: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
5196: ,p_update_statements_text OUT NOCOPY CLOB
5197: )
5198: RETURN BOOLEAN
5191: FUNCTION build_batch_update_statements
5192: (
5193: p_table_of_tad_details IN gt_table_of_tad_details
5194: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in
5195: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out
5196: ,p_update_statements_text OUT NOCOPY CLOB
5197: )
5198: RETURN BOOLEAN
5199: IS
5209: l_current_account_type_code VARCHAR2(30);
5210: l_current_temp_table_name VARCHAR2(30);
5211: l_dummy VARCHAR2(30);
5212: l_adr_function_name VARCHAR2(30);
5213: l_table_of_adr_sources xla_cmp_adr_pkg.gt_table_of_adr_sources;
5214: l_fatal_message_text VARCHAR2(2000);
5215: l_return_value BOOLEAN;
5216: l_log_module VARCHAR2 (2000);
5217: BEGIN