APPS.XLA_AAD_MERGE_PVT dependencies on XLA_SEG_RULES_TL

Line 1364: DELETE FROM xla_seg_rules_tl w

1360: p_level => C_LEVEL_STATEMENT);
1361: END IF;
1362:
1363: FORALL i IN 1..l_codes.COUNT
1364: DELETE FROM xla_seg_rules_tl w
1365: WHERE application_id = g_application_id
1366: AND amb_context_code = g_amb_context_code
1367: AND segment_rule_type_code = C_OWNER_SYSTEM
1368: AND segment_rule_code = l_codes(i);

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

1367: AND segment_rule_type_code = C_OWNER_SYSTEM
1368: AND segment_rule_code = l_codes(i);
1369:
1370: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1371: trace(p_msg => '# xla_seg_rules_tl deleted = '||SQL%ROWCOUNT,
1372: p_module => l_log_module,
1373: p_level => C_LEVEL_STATEMENT);
1374: END IF;
1375:

Line 3225: DELETE FROM xla_seg_rules_tl w

3221: p_level => C_LEVEL_STATEMENT);
3222: END IF;
3223:
3224: FORALL i IN 1..l_adr_codes.COUNT
3225: DELETE FROM xla_seg_rules_tl w
3226: WHERE amb_context_code = g_amb_context_code
3227: AND application_id = g_application_id
3228: AND segment_rule_type_code = l_adr_type_codes(i)
3229: AND segment_rule_code = l_adr_codes(i);

Line 3232: trace(p_msg => '# xla_seg_rules_tl delete : '||SQL%ROWCOUNT,

3228: AND segment_rule_type_code = l_adr_type_codes(i)
3229: AND segment_rule_code = l_adr_codes(i);
3230:
3231: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3232: trace(p_msg => '# xla_seg_rules_tl delete : '||SQL%ROWCOUNT,
3233: p_module => l_log_module,
3234: p_level => C_LEVEL_STATEMENT);
3235: END IF;
3236:

Line 3266: UPDATE xla_seg_rules_tl w

3262: p_module => l_log_module,
3263: p_level => C_LEVEL_STATEMENT);
3264: END IF;
3265:
3266: UPDATE xla_seg_rules_tl w
3267: SET amb_context_code = g_amb_context_code
3268: WHERE amb_context_code = g_staging_context_code
3269: AND application_id = g_application_id
3270: AND NOT EXISTS (SELECT 1

Line 3271: FROM xla_seg_rules_tl s

3267: SET amb_context_code = g_amb_context_code
3268: WHERE amb_context_code = g_staging_context_code
3269: AND application_id = g_application_id
3270: AND NOT EXISTS (SELECT 1
3271: FROM xla_seg_rules_tl s
3272: WHERE s.amb_context_code = g_amb_context_code
3273: AND s.segment_rule_type_code = w.segment_rule_type_code
3274: AND s.name = w.name
3275: AND s.language = w.language);

Line 3278: trace(p_msg => '# xla_seg_rules_tl 1 updated : '||SQL%ROWCOUNT,

3274: AND s.name = w.name
3275: AND s.language = w.language);
3276:
3277: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3278: trace(p_msg => '# xla_seg_rules_tl 1 updated : '||SQL%ROWCOUNT,
3279: p_module => l_log_module,
3280: p_level => C_LEVEL_STATEMENT);
3281: END IF;
3282:

Line 3283: UPDATE xla_seg_rules_tl w

3279: p_module => l_log_module,
3280: p_level => C_LEVEL_STATEMENT);
3281: END IF;
3282:
3283: UPDATE xla_seg_rules_tl w
3284: SET amb_context_code = g_amb_context_code
3285: , name = substr('('||w.segment_rule_code||') '||name,1,80)
3286: WHERE amb_context_code = g_staging_context_code
3287: AND application_id = g_application_id

Line 3289: FROM xla_seg_rules_tl s

3285: , name = substr('('||w.segment_rule_code||') '||name,1,80)
3286: WHERE amb_context_code = g_staging_context_code
3287: AND application_id = g_application_id
3288: AND EXISTS (SELECT 1
3289: FROM xla_seg_rules_tl s
3290: WHERE s.amb_context_code = g_amb_context_code
3291: AND s.segment_rule_type_code = w.segment_rule_type_code
3292: AND s.name = w.name
3293: AND s.language = w.language);

Line 3296: trace(p_msg => '# xla_seg_rules_tl 1 updated : '||SQL%ROWCOUNT,

3292: AND s.name = w.name
3293: AND s.language = w.language);
3294:
3295: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3296: trace(p_msg => '# xla_seg_rules_tl 1 updated : '||SQL%ROWCOUNT,
3297: p_module => l_log_module,
3298: p_level => C_LEVEL_STATEMENT);
3299: END IF;
3300:

Line 3946: DELETE FROM xla_seg_rules_tl

3942: p_module => l_log_module,
3943: p_level => C_LEVEL_STATEMENT);
3944: END IF;
3945:
3946: DELETE FROM xla_seg_rules_tl
3947: WHERE amb_context_code = g_staging_context_code;
3948:
3949: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3950: trace(p_msg => '# xla_seg_rules_tl delete : '||SQL%ROWCOUNT,

Line 3950: trace(p_msg => '# xla_seg_rules_tl delete : '||SQL%ROWCOUNT,

3946: DELETE FROM xla_seg_rules_tl
3947: WHERE amb_context_code = g_staging_context_code;
3948:
3949: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3950: trace(p_msg => '# xla_seg_rules_tl delete : '||SQL%ROWCOUNT,
3951: p_module => l_log_module,
3952: p_level => C_LEVEL_STATEMENT);
3953: END IF;
3954: