APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_SEG_RULES_B

Line 421: DELETE FROM xla_seg_rules_b

417: p_module => l_log_module,
418: p_level => C_LEVEL_STATEMENT);
419: END IF;
420:
421: DELETE FROM xla_seg_rules_b
422: WHERE application_id = p_application_id
423: AND amb_context_code = p_amb_context_code;
424:
425: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

422: WHERE application_id = p_application_id
423: AND amb_context_code = p_amb_context_code;
424:
425: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
426: trace(p_msg => '# record deleted from xla_seg_rules_b = '||SQL%ROWCOUNT,
427: p_module => l_log_module,
428: p_level => C_LEVEL_STATEMENT);
429: END IF;
430: */

Line 662: FROM xla_seg_rules_b

658: FOR UPDATE NOWAIT;
659:
660: CURSOR c_seg_rules_b IS
661: SELECT *
662: FROM xla_seg_rules_b
663: WHERE application_id = p_application_id
664: AND amb_context_code = p_amb_context_code
665: FOR UPDATE NOWAIT;
666:

Line 2782: DELETE FROM xla_seg_rules_b

2778: p_module => l_log_module,
2779: p_level => C_LEVEL_PROCEDURE);
2780: END IF;
2781:
2782: DELETE FROM xla_seg_rules_b
2783: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2784: AND application_id = p_application_id;
2785:
2786: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

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

2783: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2784: AND application_id = p_application_id;
2785:
2786: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2787: trace(p_msg => '# xla_seg_rules_b deleted = '||SQL%ROWCOUNT,
2788: p_module => l_log_module,
2789: p_level => C_LEVEL_PROCEDURE);
2790: END IF;
2791:

Line 2977: , xla_seg_rules_b xsr

2973: , xst.name segment_rule_name
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

Line 3001: , xla_seg_rules_b xsr

2997: , xst.name segment_rule_name
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

Line 3146: UPDATE xla_seg_rules_b

3142: SET version_num = 0
3143: , updated_flag = 'Y'
3144: WHERE application_id = p_application_id;
3145:
3146: UPDATE xla_seg_rules_b
3147: SET version_num = 0
3148: , updated_flag = 'Y'
3149: WHERE application_id = p_application_id;
3150: