eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AAD_MERGE_PVT dependencies on XLA_SEG_RULES_B

Line 1194: FROM xla_seg_rules_b work

1190: IS
1191: -- Retrieve the Oracle adr to be deleted
1192: CURSOR c_all_comps IS
1193: SELECT work.segment_rule_code
1194: FROM xla_seg_rules_b work
1195: WHERE work.application_id = g_application_id
1196: AND work.amb_context_code = g_amb_context_code
1197: AND work.segment_rule_type_code = C_OWNER_SYSTEM
1198: AND NOT EXISTS

Line 1200: FROM xla_seg_rules_b stage

1196: AND work.amb_context_code = g_amb_context_code
1197: AND work.segment_rule_type_code = C_OWNER_SYSTEM
1198: AND NOT EXISTS
1199: (SELECT 1
1200: FROM xla_seg_rules_b stage
1201: WHERE stage.application_id = g_application_id
1202: AND stage.amb_context_code = g_staging_context_code
1203: AND stage.segment_rule_type_code = C_OWNER_SYSTEM
1204: AND stage.segment_rule_code = work.segment_rule_code);

Line 1377: DELETE FROM xla_seg_rules_b w

1373: p_level => C_LEVEL_STATEMENT);
1374: END IF;
1375:
1376: FORALL i IN 1..l_codes.COUNT
1377: DELETE FROM xla_seg_rules_b w
1378: WHERE application_id = g_application_id
1379: AND amb_context_code = g_amb_context_code
1380: AND segment_rule_type_code = C_OWNER_SYSTEM
1381: AND segment_rule_code = l_codes(i);

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

1380: AND segment_rule_type_code = C_OWNER_SYSTEM
1381: AND segment_rule_code = l_codes(i);
1382:
1383: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1384: trace(p_msg => '#xla_seg_rules_b deleted = '||SQL%ROWCOUNT,
1385: p_module => l_log_module,
1386: p_level => C_LEVEL_STATEMENT);
1387: END IF;
1388:

Line 3159: FROM xla_seg_rules_b w

3155: PROCEDURE merge_adrs
3156: IS
3157: CURSOR c_adr IS
3158: SELECT s.segment_rule_type_code, s.segment_rule_code
3159: FROM xla_seg_rules_b w
3160: , xla_seg_rules_b s
3161: WHERE s.application_id = g_application_id
3162: AND s.amb_context_code = g_staging_context_code
3163: AND s.segment_rule_type_code = w.segment_rule_type_code

Line 3160: , xla_seg_rules_b s

3156: IS
3157: CURSOR c_adr IS
3158: SELECT s.segment_rule_type_code, s.segment_rule_code
3159: FROM xla_seg_rules_b w
3160: , xla_seg_rules_b s
3161: WHERE s.application_id = g_application_id
3162: AND s.amb_context_code = g_staging_context_code
3163: AND s.segment_rule_type_code = w.segment_rule_type_code
3164: AND s.segment_rule_code = w.segment_rule_code

Line 3238: DELETE FROM xla_seg_rules_b w

3234: p_level => C_LEVEL_STATEMENT);
3235: END IF;
3236:
3237: FORALL i IN 1..l_adr_codes.COUNT
3238: DELETE FROM xla_seg_rules_b w
3239: WHERE amb_context_code = g_amb_context_code
3240: AND application_id = g_application_id
3241: AND segment_rule_type_code = l_adr_type_codes(i)
3242: AND segment_rule_code = l_adr_codes(i);

Line 3245: trace(p_msg => '# xla_seg_rules_b delete : '||SQL%ROWCOUNT,

3241: AND segment_rule_type_code = l_adr_type_codes(i)
3242: AND segment_rule_code = l_adr_codes(i);
3243:
3244: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3245: trace(p_msg => '# xla_seg_rules_b delete : '||SQL%ROWCOUNT,
3246: p_module => l_log_module,
3247: p_level => C_LEVEL_STATEMENT);
3248: END IF;
3249:

Line 3255: UPDATE xla_seg_rules_b

3251:
3252: END IF;
3253:
3254: -- Move the ADRs from staging area to working area
3255: UPDATE xla_seg_rules_b
3256: SET amb_context_code = g_amb_context_code
3257: WHERE amb_context_code = g_staging_context_code
3258: AND application_id = g_application_id;
3259:

Line 3261: trace(p_msg => '# xla_seg_rules_b updated : '||SQL%ROWCOUNT,

3257: WHERE amb_context_code = g_staging_context_code
3258: AND application_id = g_application_id;
3259:
3260: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3261: trace(p_msg => '# xla_seg_rules_b updated : '||SQL%ROWCOUNT,
3262: p_module => l_log_module,
3263: p_level => C_LEVEL_STATEMENT);
3264: END IF;
3265:

Line 3955: DELETE FROM xla_seg_rules_b

3951: p_module => l_log_module,
3952: p_level => C_LEVEL_STATEMENT);
3953: END IF;
3954:
3955: DELETE FROM xla_seg_rules_b
3956: WHERE amb_context_code = g_staging_context_code;
3957:
3958: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3959: trace(p_msg => '# xla_seg_rules_b delete : '||SQL%ROWCOUNT,

Line 3959: trace(p_msg => '# xla_seg_rules_b delete : '||SQL%ROWCOUNT,

3955: DELETE FROM xla_seg_rules_b
3956: WHERE amb_context_code = g_staging_context_code;
3957:
3958: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3959: trace(p_msg => '# xla_seg_rules_b delete : '||SQL%ROWCOUNT,
3960: p_module => l_log_module,
3961: p_level => C_LEVEL_STATEMENT);
3962: END IF;
3963: