APPS.XLA_AAD_EXPORT_PVT dependencies on XLA_SEG_RULES_B

Line 211: ,xla_seg_rules_b b

207: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
208: CURSOR c_adr IS
209: SELECT distinct t.name
210: FROM xla_amb_components_h h
211: ,xla_seg_rules_b b
212: ,xla_seg_rules_tl t
213: WHERE t.amb_context_code = b.amb_context_code
214: AND t.application_id = b.application_id
215: AND t.segment_rule_type_code = b.segment_rule_type_code

Line 496: ,xla_seg_rules_b b

492: -- (h.version_num = b.version_num and leapfrog_flag = 'Y')
493: CURSOR c_adr IS
494: SELECT 1
495: FROM xla_amb_components_h h
496: ,xla_seg_rules_b b
497: WHERE h.component_type_code = 'AMB_ADR'
498: AND h.application_id = b.application_id
499: AND h.component_owner_code = b.segment_rule_type_code
500: AND h.component_code = b.segment_rule_code

Line 1847: FROM xla_seg_rules_b b

1843: SELECT b.segment_rule_type_code
1844: ,b.segment_rule_code
1845: ,b.version_num version_from
1846: ,MAX(NVL(h.version_num,0))+1 version_to
1847: FROM xla_seg_rules_b b
1848: ,xla_amb_components_h h
1849: WHERE h.application_id(+) = b.application_id
1850: AND h.component_owner_code(+) = b.segment_rule_type_code
1851: AND h.component_code(+) = b.segment_rule_code

Line 1947: UPDATE xla_seg_rules_b

1943: p_level => C_LEVEL_STATEMENT);
1944: END IF;
1945:
1946: FORALL i IN 1 .. l_adr_codes.COUNT
1947: UPDATE xla_seg_rules_b
1948: SET version_num = l_adr_version_to(i)
1949: ,updated_flag = 'N'
1950: ,creation_date = sysdate
1951: ,created_by = xla_environment_pkg.g_usr_id

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

1957: AND application_id = p_application_id
1958: AND amb_context_code = p_amb_context_code;
1959:
1960: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1961: trace(p_msg => '# row updated in xla_seg_rules_b = '||SQL%ROWCOUNT,
1962: p_module => l_log_module,
1963: p_level => C_LEVEL_STATEMENT);
1964: END IF;
1965: