APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_SEG_RULES_TL

Line 581: DELETE FROM xla_seg_rules_tl

577: p_module => l_log_module,
578: p_level => C_LEVEL_STATEMENT);
579: END IF;
580:
581: DELETE FROM xla_seg_rules_tl
582: WHERE application_id = p_application_id
583: AND amb_context_code = p_amb_context_code;
584:
585: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

582: WHERE application_id = p_application_id
583: AND amb_context_code = p_amb_context_code;
584:
585: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
586: trace(p_msg => '# record deleted from xla_seg_rules_tl = '||SQL%ROWCOUNT,
587: p_module => l_log_module,
588: p_level => C_LEVEL_STATEMENT);
589: END IF;
590:

Line 919: FROM xla_seg_rules_tl

915: FOR UPDATE NOWAIT;
916:
917: CURSOR c_seg_rules_tl IS
918: SELECT *
919: FROM xla_seg_rules_tl
920: WHERE application_id = p_application_id
921: AND amb_context_code = p_amb_context_code
922: FOR UPDATE NOWAIT;
923:

Line 3665: DELETE FROM xla_seg_rules_tl

3661: p_module => l_log_module,
3662: p_level => C_LEVEL_PROCEDURE);
3663: END IF;
3664:
3665: DELETE FROM xla_seg_rules_tl
3666: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3667: AND application_id = p_application_id;
3668:
3669: -- Bug 16208537

Line 3676: p_encoded_message => '# delete (xla_seg_rules_tl) = '||SQL%ROWCOUNT,

3672: p_amb_context_code => p_amb_context_code,
3673: p_application_id => p_application_id,
3674: p_request_code => 'IMPORT' ,
3675: p_log_type_code => 'MERGE',
3676: p_encoded_message => '# delete (xla_seg_rules_tl) = '||SQL%ROWCOUNT,
3677: p_component_code => 'purge_aad');
3678:
3679:
3680: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 3681: trace(p_msg => '# xla_seg_rules_tl deleted = '||SQL%ROWCOUNT,

3677: p_component_code => 'purge_aad');
3678:
3679:
3680: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3681: trace(p_msg => '# xla_seg_rules_tl deleted = '||SQL%ROWCOUNT,
3682: p_module => l_log_module,
3683: p_level => C_LEVEL_PROCEDURE);
3684: END IF;
3685:

Line 3962: , xla_seg_rules_tl xst

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
3966: AND xld.segment_rule_appl_id <> p_application_id

Line 3986: , xla_seg_rules_tl xst

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
3990: AND xsd.value_segment_rule_appl_id <> p_application_id