DBA Data[Home] [Help]

APPS.XLA_CMP_TAD_PKG dependencies on XLA_CMP_ADR_PKG

Line 3187: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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:

Line 3200: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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;

Line 3201: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out

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:

Line 3213: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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;

Line 3227: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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: )

Line 3228: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out

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;

Line 3243: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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;

Line 3244: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out

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:

Line 3721: l_table_of_adrs xla_cmp_adr_pkg.gt_table_of_adrs_in;

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);

Line 3722: l_table_of_adrs_ext xla_cmp_adr_pkg.gt_table_of_adrs_out;

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:

Line 4047: IF NOT xla_cmp_adr_pkg.build_adrs_for_tab

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

Line 4058: ,p_msg => 'xla_cmp_adr_pkg.build_adrs_for_tad failed'

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;

Line 4385: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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

Line 4511: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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

Line 4753: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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

Line 4754: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out

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

Line 4888: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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: )

Line 4889: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out

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

Line 5194: ,p_table_of_adrs IN xla_cmp_adr_pkg.gt_table_of_adrs_in

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

Line 5195: ,p_table_of_adrs_ext IN xla_cmp_adr_pkg.gt_table_of_adrs_out

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

Line 5213: l_table_of_adr_sources xla_cmp_adr_pkg.gt_table_of_adr_sources;

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