APPS.XLA_AAD_MERGE_PVT dependencies on XLA_SEG_RULE_DETAILS

Line 1280: FROM xla_seg_rule_details s

1276: ,xla_environment_pkg.g_prog_appl_id
1277: ,xla_environment_pkg.g_prog_id
1278: ,xla_environment_pkg.g_req_Id
1279: FROM (SELECT application_id
1280: FROM xla_seg_rule_details s
1281: WHERE application_id <> g_application_id
1282: AND amb_context_code = g_amb_context_code
1283: AND value_segment_rule_appl_id = g_application_id
1284: AND value_segment_rule_type_code = C_OWNER_SYSTEM

Line 1311: DELETE FROM xla_seg_rule_details d

1307: END IF;
1308:
1309: -- Delete the reference to Oracle ADR to be deleted
1310: FORALL i IN 1..l_codes.COUNT
1311: DELETE FROM xla_seg_rule_details d
1312: WHERE amb_context_code = g_amb_context_code
1313: AND value_segment_rule_appl_id = g_application_id
1314: AND value_segment_rule_type_code = C_OWNER_SYSTEM
1315: AND value_segment_rule_code = l_codes(i);

Line 1351: DELETE FROM xla_seg_rule_details w

1347: END IF;
1348:
1349: -- Delete the ADR
1350: FORALL i IN 1..l_codes.COUNT
1351: DELETE FROM xla_seg_rule_details w
1352: WHERE application_id = g_application_id
1353: AND amb_context_code = g_amb_context_code
1354: AND segment_rule_type_code = C_OWNER_SYSTEM
1355: AND segment_rule_code = l_codes(i);

Line 1358: trace(p_msg => '# xla_seg_rule_details deleted = '||SQL%ROWCOUNT,

1354: AND segment_rule_type_code = C_OWNER_SYSTEM
1355: AND segment_rule_code = l_codes(i);
1356:
1357: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1358: trace(p_msg => '# xla_seg_rule_details deleted = '||SQL%ROWCOUNT,
1359: p_module => l_log_module,
1360: p_level => C_LEVEL_STATEMENT);
1361: END IF;
1362:

Line 3198: FROM xla_seg_rule_details w

3194: DELETE FROM xla_conditions c
3195: WHERE amb_context_code = g_amb_context_code
3196: AND application_id = g_application_id
3197: AND EXISTS (SELECT 1
3198: FROM xla_seg_rule_details w
3199: WHERE c.segment_rule_detail_id = w.segment_rule_detail_id
3200: AND w.application_id = g_application_id
3201: AND w.amb_context_code = g_amb_context_code
3202: AND w.segment_rule_type_code = l_adr_type_codes(i)

Line 3212: DELETE FROM xla_seg_rule_details w

3208: p_level => C_LEVEL_STATEMENT);
3209: END IF;
3210:
3211: FORALL i IN 1..l_adr_codes.COUNT
3212: DELETE FROM xla_seg_rule_details w
3213: WHERE amb_context_code = g_amb_context_code
3214: AND application_id = g_application_id
3215: AND segment_rule_type_code = l_adr_type_codes(i)
3216: AND segment_rule_code = l_adr_codes(i);

Line 3219: trace(p_msg => '# xla_seg_rule_details delete : '||SQL%ROWCOUNT,

3215: AND segment_rule_type_code = l_adr_type_codes(i)
3216: AND segment_rule_code = l_adr_codes(i);
3217:
3218: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3219: trace(p_msg => '# xla_seg_rule_details delete : '||SQL%ROWCOUNT,
3220: p_module => l_log_module,
3221: p_level => C_LEVEL_STATEMENT);
3222: END IF;
3223:

Line 3301: UPDATE xla_seg_rule_details

3297: p_module => l_log_module,
3298: p_level => C_LEVEL_STATEMENT);
3299: END IF;
3300:
3301: UPDATE xla_seg_rule_details
3302: SET amb_context_code = g_amb_context_code
3303: WHERE amb_context_code = g_staging_context_code
3304: AND application_id = g_application_id;
3305:

Line 3307: trace(p_msg => '# xla_seg_rule_details updated : '||SQL%ROWCOUNT,

3303: WHERE amb_context_code = g_staging_context_code
3304: AND application_id = g_application_id;
3305:
3306: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3307: trace(p_msg => '# xla_seg_rule_details updated : '||SQL%ROWCOUNT,
3308: p_module => l_log_module,
3309: p_level => C_LEVEL_STATEMENT);
3310: END IF;
3311:

Line 3937: DELETE FROM xla_seg_rule_details

3933: p_module => l_log_module,
3934: p_level => C_LEVEL_STATEMENT);
3935: END IF;
3936:
3937: DELETE FROM xla_seg_rule_details
3938: WHERE amb_context_code = g_staging_context_code;
3939:
3940: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3941: trace(p_msg => '# xla_seg_rules_details delete : '||SQL%ROWCOUNT,