APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_SEG_RULES_TL

Line 411: DELETE FROM xla_seg_rules_tl

407: p_module => l_log_module,
408: p_level => C_LEVEL_STATEMENT);
409: END IF;
410:
411: DELETE FROM xla_seg_rules_tl
412: WHERE application_id = p_application_id
413: AND amb_context_code = p_amb_context_code;
414:
415: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

412: WHERE application_id = p_application_id
413: AND amb_context_code = p_amb_context_code;
414:
415: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
416: trace(p_msg => '# record deleted from xla_seg_rules_tl = '||SQL%ROWCOUNT,
417: p_module => l_log_module,
418: p_level => C_LEVEL_STATEMENT);
419: END IF;
420:

Line 669: FROM xla_seg_rules_tl

665: FOR UPDATE NOWAIT;
666:
667: CURSOR c_seg_rules_tl IS
668: SELECT *
669: FROM xla_seg_rules_tl
670: WHERE application_id = p_application_id
671: AND amb_context_code = p_amb_context_code
672: FOR UPDATE NOWAIT;
673:

Line 2772: DELETE FROM xla_seg_rules_tl

2768: p_module => l_log_module,
2769: p_level => C_LEVEL_PROCEDURE);
2770: END IF;
2771:
2772: DELETE FROM xla_seg_rules_tl
2773: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2774: AND application_id = p_application_id;
2775:
2776: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

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

2773: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2774: AND application_id = p_application_id;
2775:
2776: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2777: trace(p_msg => '# xla_seg_rules_tl deleted = '||SQL%ROWCOUNT,
2778: p_module => l_log_module,
2779: p_level => C_LEVEL_PROCEDURE);
2780: END IF;
2781:

Line 2978: , xla_seg_rules_tl xst

2974: , lk1.meaning segment_rule_owner
2975: , xld.adr_version_num version_num
2976: FROM xla_line_defn_adr_assgns xld
2977: , xla_seg_rules_b xsr
2978: , xla_seg_rules_tl xst
2979: , fnd_application_vl app
2980: , xla_lookups lk1
2981: WHERE xld.amb_context_code = p_staging_context_code
2982: AND xld.segment_rule_appl_id <> p_application_id

Line 3002: , xla_seg_rules_tl xst

2998: , lk1.meaning segment_rule_owner
2999: , xsd.value_adr_version_num
3000: FROM xla_seg_rule_details xsd
3001: , xla_seg_rules_b xsr
3002: , xla_seg_rules_tl xst
3003: , fnd_application_vl app
3004: , xla_lookups lk1
3005: WHERE xsd.amb_context_code = p_staging_context_code
3006: AND xsd.value_segment_rule_appl_id <> p_application_id