APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_SEG_RULE_DETAILS

Line 591: FROM xla_seg_rule_details d

587: ,sysdate
588: ,xla_environment_pkg.g_prog_appl_id
589: ,xla_environment_pkg.g_prog_id
590: ,xla_environment_pkg.g_req_Id
591: FROM xla_seg_rule_details d
592: ,TABLE(CAST(l_mapping_sets AS xla_component_tbl_type)) ms
593: WHERE d.amb_context_code = g_amb_context_code
594: AND d.application_id <> g_application_id
595: AND d.value_mapping_set_code = ms.component_code;

Line 1051: FROM xla_seg_rule_details a

1047: ,a.segment_rule_type_code
1048: ,a.segment_rule_code
1049: ,adr.version_from
1050: ,adr.version_to
1051: FROM xla_seg_rule_details a
1052: ,TABLE(CAST(l_adrs AS xla_component_tbl_type)) adr
1053: WHERE a.amb_context_code = g_amb_context_code
1054: AND a.application_id <> g_application_id
1055: AND a.value_segment_rule_appl_id = g_application_id

Line 1070: FROM xla_seg_rule_details

1066: FORALL i IN 1 .. l_adr_codes.COUNT
1067: DELETE FROM xla_conditions
1068: WHERE segment_rule_detail_id IN
1069: (SELECT segment_rule_detail_id
1070: FROM xla_seg_rule_details
1071: WHERE application_id = g_application_id
1072: AND amb_context_code = g_amb_context_code
1073: AND segment_rule_type_code = l_adr_type_codes(i)
1074: AND segment_rule_code = l_adr_codes(i));

Line 1083: DELETE FROM xla_seg_rule_details

1079: p_level => C_LEVEL_STATEMENT);
1080: END IF;
1081:
1082: FORALL i IN 1 .. l_adr_codes.COUNT
1083: DELETE FROM xla_seg_rule_details
1084: WHERE application_id = g_application_id
1085: AND amb_context_code = g_amb_context_code
1086: AND segment_rule_type_code = l_adr_type_codes(i)
1087: AND segment_rule_code = l_adr_codes(i);

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

1086: AND segment_rule_type_code = l_adr_type_codes(i)
1087: AND segment_rule_code = l_adr_codes(i);
1088:
1089: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1090: trace(p_msg => '# row deleted into xla_seg_rule_details = '||SQL%ROWCOUNT,
1091: p_module => l_log_module,
1092: p_level => C_LEVEL_STATEMENT);
1093: END IF;
1094:

Line 1383: UPDATE xla_seg_rule_details

1379: p_module => l_log_module,
1380: p_level => C_LEVEL_STATEMENT);
1381: END IF;
1382:
1383: UPDATE xla_seg_rule_details
1384: SET amb_context_code = g_amb_context_code
1385: WHERE amb_context_code = g_staging_context_code;
1386:
1387: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1388: trace(p_msg => '# row moved in xla_seg_rule_details = '||SQL%ROWCOUNT,

1384: SET amb_context_code = g_amb_context_code
1385: WHERE amb_context_code = g_staging_context_code;
1386:
1387: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1388: trace(p_msg => '# row moved in xla_seg_rule_details = '||SQL%ROWCOUNT,
1389: p_module => l_log_module,
1390: p_level => C_LEVEL_STATEMENT);
1391: END IF;
1392: