APPS.XLA_CMP_TAB_PKG dependencies on XLA_TAB_ACCT_TYPES_B

Line 1666: UPDATE xla_tab_acct_types_b xtat

1662: l_return_value := FALSE;
1663: END IF;
1664:
1665: --Assign the new compile_status_code to the TATs
1666: UPDATE xla_tab_acct_types_b xtat
1667: SET xtat.compile_status_code =
1668: xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_COMPILED
1669: WHERE xtat.application_id = p_application_id
1670: AND xtat.enabled_flag = 'Y'

Line 2350: FROM xla_tab_acct_types_b xtat

2346: SELECT DISTINCT xsb.source_code
2347: ,xsb.source_type_code
2348: ,xsb.enabled_flag
2349: ,xsb.datatype_code
2350: FROM xla_tab_acct_types_b xtat
2351: ,xla_tab_acct_type_srcs xtsrc
2352: ,xla_sources_b xsb
2353: WHERE xtat.application_id = g_application_info.application_id
2354: AND NVL( xtat.object_name_affix

Line 3043: FROM xla_tab_acct_types_b xtat

3039: SELECT DISTINCT xsb.source_code
3040: ,xsb.source_type_code
3041: ,xsb.enabled_flag
3042: ,xsb.datatype_code
3043: FROM xla_tab_acct_types_b xtat
3044: ,xla_tab_acct_type_srcs xtsrc
3045: ,xla_sources_b xsb
3046: WHERE xtat.application_id = g_application_info.application_id
3047: AND NVL( xtat.object_name_affix

Line 3638: FROM xla_tab_acct_types_b xtat

3634: ,xsb.datatype_code
3635: BULK COLLECT
3636: INTO l_table_of_sources
3637: ,l_table_of_source_datatypes
3638: FROM xla_tab_acct_types_b xtat
3639: ,xla_tab_acct_type_srcs xtsrc
3640: ,xla_sources_b xsb
3641: WHERE xtat.application_id = g_application_info.application_id
3642: AND NVL( xtat.object_name_affix

Line 3782: FROM xla_tab_acct_types_b xtat

3778: SELECT DISTINCT xsb.source_code
3779: ,xsb.source_type_code
3780: ,xsb.enabled_flag
3781: ,xsb.datatype_code
3782: FROM xla_tab_acct_types_b xtat
3783: ,xla_tab_acct_type_srcs xtsrc
3784: ,xla_sources_b xsb
3785: WHERE xtat.application_id = g_application_info.application_id
3786: AND NVL( xtat.object_name_affix

Line 4157: FROM xla_tab_acct_types_b xtat

4153: --retrieve all the distinct object name affixes for enabled TATs
4154: SELECT DISTINCT xtat.object_name_affix
4155: BULK COLLECT
4156: INTO g_all_object_name_affixes
4157: FROM xla_tab_acct_types_b xtat
4158: WHERE xtat.application_id = g_application_info.application_id
4159: AND xtat.enabled_flag = 'Y'
4160: ORDER BY NVL(xtat.object_name_affix, ' ');
4161:

Line 4195: FROM xla_tab_acct_types_b xtat

4191: --Retrieve the compiled distinct object name affixes for enabled TATs
4192: SELECT DISTINCT xtat.object_name_affix
4193: BULK COLLECT
4194: INTO g_compiled_object_name_affixes
4195: FROM xla_tab_acct_types_b xtat
4196: WHERE xtat.application_id = g_application_info.application_id
4197: AND xtat.compile_status_code
4198: = xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_COMPILED
4199: ORDER BY NVL(xtat.object_name_affix, ' ');

Line 4271: FROM xla_tab_acct_types_b xtat

4267:
4268: --Remove Transaction Account Definitions deleted in the UI
4269: --for this application
4270: DELETE
4271: FROM xla_tab_acct_types_b xtat
4272: WHERE xtat.application_id = p_application_id
4273: AND xtat.compile_status_code =
4274: xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_DELETE;
4275:

Line 4281: || ' row(s) deleted from xla_tab_acct_types_b'

4277: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4278: trace
4279: (p_module => l_log_module
4280: ,p_msg => SQL%ROWCOUNT
4281: || ' row(s) deleted from xla_tab_acct_types_b'
4282: ,p_level => C_LEVEL_STATEMENT);
4283: END IF;
4284:
4285: l_return_value := TRUE;

Line 4371: FROM xla_tab_acct_types_b xtat

4367:
4368: --Get the object name affix for the specified TAT
4369: SELECT xtat.object_name_affix
4370: INTO l_object_name_affix
4371: FROM xla_tab_acct_types_b xtat
4372: WHERE xtat.application_id = g_application_info.application_id
4373: AND xtat.account_type_code = p_account_type_code
4374: AND xtat.enabled_flag = 'Y'
4375: ORDER BY NVL(xtat.object_name_affix, ' ');