APPS.XLA_CMP_TAD_PKG dependencies on XLA_TAB_ACCT_DEFS_B

Line 3430: UPDATE xla_tab_acct_defs_b xtad

3426: ,p_msg => 'BEGIN ' || l_log_module
3427: ,p_level => C_LEVEL_PROCEDURE);
3428: END IF;
3429:
3430: UPDATE xla_tab_acct_defs_b xtad
3431: SET xtad.compile_status_code = p_compilation_status_code
3432: WHERE xtad.application_id = p_application_id
3433: AND xtad.account_definition_code = p_account_definition_code
3434: AND xtad.account_definition_type_code = p_account_definition_type_code

Line 3441: || ' row(s) updated in xla_tab_acct_defs_b'

3437: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3438: trace
3439: (p_module => l_log_module
3440: ,p_msg => SQL%ROWCOUNT
3441: || ' row(s) updated in xla_tab_acct_defs_b'
3442: ,p_level => C_LEVEL_STATEMENT);
3443: END IF;
3444:
3445: l_return_value := TRUE;

Line 6286: FROM xla_tab_acct_defs_b xtd

6282: ,xtd.chart_of_accounts_id
6283: INTO l_tad_hash_id
6284: ,l_tad_enabled_flag
6285: ,l_chart_of_accounts_id
6286: FROM xla_tab_acct_defs_b xtd
6287: WHERE xtd.application_id = g_application_info.application_id
6288: AND xtd.account_definition_code = p_account_definition_code
6289: AND xtd.account_definition_type_code = p_account_definition_type_code
6290: AND xtd.amb_context_code = p_amb_context_code;

Line 6328: SELECT xla_tab_acct_defs_b_s.NEXTVAL

6324: --If the hash_id is NULL
6325: IF l_tad_hash_id IS NULL
6326: THEN
6327: --Get a new one from the DB sequence
6328: SELECT xla_tab_acct_defs_b_s.NEXTVAL
6329: INTO l_tad_hash_id
6330: FROM DUAL;
6331:
6332: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 6340: UPDATE xla_tab_acct_defs_b xtd

6336: ,p_level => C_LEVEL_STATEMENT);
6337: END IF;
6338:
6339: --Update the TAD record with the hash id
6340: UPDATE xla_tab_acct_defs_b xtd
6341: SET xtd.hash_id = l_tad_hash_id
6342: WHERE xtd.application_id = g_application_info.application_id
6343: AND xtd.account_definition_code = p_account_definition_code
6344: AND xtd.account_definition_type_code = p_account_definition_type_code

Line 6351: || ' row(s) updated in xla_tab_acct_defs_b'

6347: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6348: trace
6349: (p_module => l_log_module
6350: ,p_msg => SQL%ROWCOUNT
6351: || ' row(s) updated in xla_tab_acct_defs_b'
6352: ,p_level => C_LEVEL_STATEMENT);
6353: END IF;
6354: END IF;
6355: