APPS.XLA_AAD_EXPORT_PVT dependencies on XLA_PRODUCT_RULES_B

Line 186: ,xla_product_rules_b b

182: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
183: CURSOR c_aad IS
184: SELECT distinct t.name
185: FROM xla_aads_h h
186: ,xla_product_rules_b b
187: ,xla_product_rules_tl t
188: WHERE t.application_id = b.application_id
189: AND t.amb_context_code = b.amb_context_code
190: AND t.product_rule_type_code = b.product_rule_type_code

Line 478: ,xla_product_rules_b b

474: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
475: CURSOR c_aad IS
476: SELECT 1
477: FROM xla_aads_h h
478: ,xla_product_rules_b b
479: WHERE h.application_id = b.application_id
480: AND h.product_rule_type_code = b.product_rule_type_code
481: AND h.product_rule_code = b.product_rule_code
482: AND ((h.version_num > b.version_num AND

Line 795: FROM xla_product_rules_b b

791: b.product_rule_code
792: ,b.version_num
793: ,b.updated_flag
794: ,NVL(h.leapfrog_flag,'N') leapfrog_flag
795: FROM xla_product_rules_b b
796: JOIN xla_aads_h h
797: ON h.product_rule_code = b.product_rule_code
798: AND h.application_id = p_application_id
799: AND h.product_rule_type_code = p_owner_type

Line 816: FROM xla_product_rules_b b

812: b.product_rule_code
813: ,b.version_num
814: ,b.updated_flag
815: ,NVL(h.leapfrog_flag,'N') leapfrog_flag
816: FROM xla_product_rules_b b
817: LEFT OUTER JOIN xla_aads_h h
818: ON h.product_rule_code = b.product_rule_code
819: AND h.application_id = p_application_id
820: AND h.product_rule_type_code = p_owner_type

Line 1591: UPDATE xla_product_rules_b

1587: p_level => C_LEVEL_EVENT);
1588: END IF;
1589:
1590: FORALL i IN 1 .. l_aad_codes.COUNT
1591: UPDATE xla_product_rules_b
1592: SET version_num = l_versions_to(i)
1593: ,updated_flag = 'N'
1594: ,product_rule_version = p_user_version
1595: ,creation_date = sysdate

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

1602: AND product_rule_type_code = p_owner_type
1603: AND product_rule_code = l_aad_codes(i);
1604:
1605: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1606: trace(p_msg => '# row updated in xla_product_rules_b = '||SQL%ROWCOUNT,
1607: p_module => l_log_module,
1608: p_level => C_LEVEL_STATEMENT);
1609: END IF;
1610:

Line 2203: FROM xla_product_rules_b

2199: ,sysdate
2200: ,xla_environment_pkg.g_prog_appl_id
2201: ,xla_environment_pkg.g_prog_id
2202: ,xla_environment_pkg.g_req_Id
2203: FROM xla_product_rules_b
2204: WHERE application_id = p_application_id
2205: AND amb_context_code = p_amb_context_code;
2206:
2207: IF (C_LEVEL_STATEMENT >= g_log_level) THEN