APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_SEG_RULE_DETAILS

Line 571: DELETE FROM xla_seg_rule_details

567: -- Delete account derivation rules
568: --
569: /* Bug 4367287 - the ADR is deleted on demand
570:
571: DELETE FROM xla_seg_rule_details
572: WHERE application_id = p_application_id
573: AND amb_context_code = p_amb_context_code;
574:
575: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 576: trace(p_msg => '# record deleted from xla_seg_rule_details = '||SQL%ROWCOUNT,

572: WHERE application_id = p_application_id
573: AND amb_context_code = p_amb_context_code;
574:
575: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
576: trace(p_msg => '# record deleted from xla_seg_rule_details = '||SQL%ROWCOUNT,
577: p_module => l_log_module,
578: p_level => C_LEVEL_STATEMENT);
579: END IF;
580:

Line 926: FROM xla_seg_rule_details

922: FOR UPDATE NOWAIT;
923:
924: CURSOR c_seg_rule_details IS
925: SELECT *
926: FROM xla_seg_rule_details
927: WHERE application_id = p_application_id
928: AND amb_context_code = p_amb_context_code
929: FOR UPDATE NOWAIT;
930:

Line 997: ,xla_seg_rule_details s

993: CURSOR c_mapping_sets IS
994: SELECT *
995: FROM xla_mapping_sets_b b
996: ,xla_mapping_sets_tl t
997: ,xla_seg_rule_details s
998: WHERE t.mapping_set_code = b.mapping_set_code
999: AND b.mapping_set_code = s.value_mapping_set_code
1000: AND s.application_id = p_application_id
1001: AND s.amb_context_code = p_amb_context_code

Line 1009: ,xla_seg_rule_details s

1005:
1006: CURSOR c_mapping_set_values IS
1007: SELECT *
1008: FROM xla_mapping_set_values b
1009: ,xla_seg_rule_details s
1010: WHERE b.mapping_set_code = s.value_mapping_set_code
1011: AND s.application_id = p_application_id
1012: AND s.amb_context_code = p_amb_context_code
1013: --FOR UPDATE NOWAIT;

Line 3645: DELETE FROM xla_seg_rule_details

3641: p_module => l_log_module,
3642: p_level => C_LEVEL_PROCEDURE);
3643: END IF;
3644:
3645: DELETE FROM xla_seg_rule_details
3646: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3647: AND application_id = p_application_id;
3648:
3649: -- Bug 16208537

Line 3656: p_encoded_message => '# delete (xla_seg_rule_details) = '||SQL%ROWCOUNT,

3652: p_amb_context_code => p_amb_context_code,
3653: p_application_id => p_application_id,
3654: p_request_code => 'IMPORT' ,
3655: p_log_type_code => 'MERGE',
3656: p_encoded_message => '# delete (xla_seg_rule_details) = '||SQL%ROWCOUNT,
3657: p_component_code => 'purge_aad');
3658:
3659: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3660: trace(p_msg => '# xla_seg_rule_details deleted = '||SQL%ROWCOUNT,

Line 3660: trace(p_msg => '# xla_seg_rule_details deleted = '||SQL%ROWCOUNT,

3656: p_encoded_message => '# delete (xla_seg_rule_details) = '||SQL%ROWCOUNT,
3657: p_component_code => 'purge_aad');
3658:
3659: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3660: trace(p_msg => '# xla_seg_rule_details deleted = '||SQL%ROWCOUNT,
3661: p_module => l_log_module,
3662: p_level => C_LEVEL_PROCEDURE);
3663: END IF;
3664:

Line 3984: FROM xla_seg_rule_details xsd

3980: SELECT app.application_name
3981: , xst.name segment_rule_name
3982: , lk1.meaning segment_rule_owner
3983: , xsd.value_adr_version_num
3984: FROM xla_seg_rule_details xsd
3985: , xla_seg_rules_b xsr
3986: , xla_seg_rules_tl xst
3987: , fnd_application_vl app
3988: , xla_lookups lk1