APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_PRODUCT_RULES_B

Line 83: FROM xla_product_rules_b w

79: RETURN VARCHAR2
80: IS
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')

Line 84: ,xla_product_rules_b s

80: IS
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

Line 357: FROM xla_product_rules_b s

353: ,sysdate
354: ,xla_environment_pkg.g_prog_appl_id
355: ,xla_environment_pkg.g_prog_id
356: ,xla_environment_pkg.g_req_Id
357: FROM xla_product_rules_b s
358: WHERE s.application_id = g_application_id
359: AND s.amb_context_code = g_staging_context_code;
360:
361: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1668: UPDATE xla_product_rules_b

1664: p_level => C_LEVEL_PROCEDURE);
1665: END IF;
1666:
1667: -- Move accounting definitions
1668: UPDATE xla_product_rules_b
1669: SET amb_context_code = g_amb_context_code
1670: WHERE amb_context_code = g_staging_context_code;
1671:
1672: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

1669: SET amb_context_code = g_amb_context_code
1670: WHERE amb_context_code = g_staging_context_code;
1671:
1672: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1673: trace(p_msg => '# row moved in xla_product_rules_b = '||SQL%ROWCOUNT,
1674: p_module => l_log_module,
1675: p_level => C_LEVEL_STATEMENT);
1676: END IF;
1677: