DBA Data[Home] [Help]

APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_PRODUCT_RULES_TL

Line 85: ,xla_product_rules_tl t

81: CURSOR c_aad IS
82: SELECT t.name
83: FROM xla_product_rules_b w
84: ,xla_product_rules_b s
85: ,xla_product_rules_tl t
86: WHERE s.version_num < w.version_num
87: AND t.language = USERENV('LANG')
88: AND t.application_id = w.application_id
89: AND t.amb_context_code = w.amb_context_code

Line 1678: UPDATE xla_product_rules_tl

1674: p_module => l_log_module,
1675: p_level => C_LEVEL_STATEMENT);
1676: END IF;
1677:
1678: UPDATE xla_product_rules_tl
1679: SET amb_context_code = g_amb_context_code
1680: WHERE amb_context_code = g_staging_context_code;
1681:
1682: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1683: trace(p_msg => '# row moved in xla_product_rules_tl = '||SQL%ROWCOUNT,

1679: SET amb_context_code = g_amb_context_code
1680: WHERE amb_context_code = g_staging_context_code;
1681:
1682: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1683: trace(p_msg => '# row moved in xla_product_rules_tl = '||SQL%ROWCOUNT,
1684: p_module => l_log_module,
1685: p_level => C_LEVEL_STATEMENT);
1686: END IF;
1687: