APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_SEG_RULES_B

Line 591: DELETE FROM xla_seg_rules_b

587: p_module => l_log_module,
588: p_level => C_LEVEL_STATEMENT);
589: END IF;
590:
591: DELETE FROM xla_seg_rules_b
592: WHERE application_id = p_application_id
593: AND amb_context_code = p_amb_context_code;
594:
595: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

592: WHERE application_id = p_application_id
593: AND amb_context_code = p_amb_context_code;
594:
595: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
596: trace(p_msg => '# record deleted from xla_seg_rules_b = '||SQL%ROWCOUNT,
597: p_module => l_log_module,
598: p_level => C_LEVEL_STATEMENT);
599: END IF;
600: */

Line 912: FROM xla_seg_rules_b

908: FOR UPDATE NOWAIT;
909:
910: CURSOR c_seg_rules_b IS
911: SELECT *
912: FROM xla_seg_rules_b
913: WHERE application_id = p_application_id
914: AND amb_context_code = p_amb_context_code
915: FOR UPDATE NOWAIT;
916:

Line 3686: DELETE FROM xla_seg_rules_b

3682: p_module => l_log_module,
3683: p_level => C_LEVEL_PROCEDURE);
3684: END IF;
3685:
3686: DELETE FROM xla_seg_rules_b
3687: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3688: AND application_id = p_application_id;
3689:
3690: -- Bug 16208537

Line 3697: p_encoded_message => '# delete (xla_seg_rules_b) = '||SQL%ROWCOUNT,

3693: p_amb_context_code => p_amb_context_code,
3694: p_application_id => p_application_id,
3695: p_request_code => 'IMPORT' ,
3696: p_log_type_code => 'MERGE',
3697: p_encoded_message => '# delete (xla_seg_rules_b) = '||SQL%ROWCOUNT,
3698: p_component_code => 'purge_aad');
3699:
3700: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3701: trace(p_msg => '# xla_seg_rules_b deleted = '||SQL%ROWCOUNT,

Line 3701: trace(p_msg => '# xla_seg_rules_b deleted = '||SQL%ROWCOUNT,

3697: p_encoded_message => '# delete (xla_seg_rules_b) = '||SQL%ROWCOUNT,
3698: p_component_code => 'purge_aad');
3699:
3700: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3701: trace(p_msg => '# xla_seg_rules_b deleted = '||SQL%ROWCOUNT,
3702: p_module => l_log_module,
3703: p_level => C_LEVEL_PROCEDURE);
3704: END IF;
3705:

Line 3961: , xla_seg_rules_b xsr

3957: , xst.name segment_rule_name
3958: , lk1.meaning segment_rule_owner
3959: , xld.adr_version_num version_num
3960: FROM xla_line_defn_adr_assgns xld
3961: , xla_seg_rules_b xsr
3962: , xla_seg_rules_tl xst
3963: , fnd_application_vl app
3964: , xla_lookups lk1
3965: WHERE xld.amb_context_code = p_staging_context_code

Line 3985: , xla_seg_rules_b xsr

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
3989: WHERE xsd.amb_context_code = p_staging_context_code

Line 4130: UPDATE xla_seg_rules_b

4126: SET version_num = 0
4127: , updated_flag = 'Y'
4128: WHERE application_id = p_application_id;
4129:
4130: UPDATE xla_seg_rules_b
4131: SET version_num = 0
4132: , updated_flag = 'Y'
4133: WHERE application_id = p_application_id;
4134: