APPS.XLA_AAD_MERGE_PVT dependencies on XLA_CONDITIONS

Line 2436: DELETE FROM xla_conditions w

2432: p_module => l_log_module,
2433: p_level => C_LEVEL_STATEMENT);
2434: END IF;
2435:
2436: DELETE FROM xla_conditions w
2437: WHERE application_id = g_application_id
2438: AND amb_context_code = g_amb_context_code
2439: AND EXISTS (SELECT 1
2440: FROM xla_acct_line_types_b s

Line 2517: UPDATE xla_conditions

2513: p_module => l_log_module,
2514: p_level => C_LEVEL_STATEMENT);
2515: END IF;
2516:
2517: UPDATE xla_conditions
2518: SET amb_context_code = g_amb_context_code
2519: WHERE amb_context_code = g_staging_context_code
2520: AND application_id = g_application_id
2521: AND accounting_line_code IS NOT NULL;

Line 2524: trace(p_msg => '# xla_conditions updated : '||SQL%ROWCOUNT,

2520: AND application_id = g_application_id
2521: AND accounting_line_code IS NOT NULL;
2522:
2523: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2524: trace(p_msg => '# xla_conditions updated : '||SQL%ROWCOUNT,
2525: p_module => l_log_module,
2526: p_level => C_LEVEL_STATEMENT);
2527: END IF;
2528:

Line 2625: DELETE FROM xla_conditions

2621: p_module => l_log_module,
2622: p_level => C_LEVEL_STATEMENT);
2623: END IF;
2624:
2625: DELETE FROM xla_conditions
2626: WHERE description_prio_id IN
2627: (SELECT w.description_prio_id
2628: FROM xla_desc_priorities w
2629: , xla_desc_priorities s

Line 2638: trace(p_msg => '# xla_conditions delete : '||SQL%ROWCOUNT,

2634: AND w.description_type_code = s.description_type_code
2635: AND w.description_code = s.description_code);
2636:
2637: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2638: trace(p_msg => '# xla_conditions delete : '||SQL%ROWCOUNT,
2639: p_module => l_log_module,
2640: p_level => C_LEVEL_STATEMENT);
2641: END IF;
2642:

Line 2744: UPDATE xla_conditions

2740: p_module => l_log_module,
2741: p_level => C_LEVEL_STATEMENT);
2742: END IF;
2743:
2744: UPDATE xla_conditions
2745: SET amb_context_code = g_amb_context_code
2746: WHERE amb_context_code = g_staging_context_code
2747: AND application_id = g_application_id
2748: AND description_prio_id IS NOT NULL;

Line 2751: trace(p_msg => '# xla_conditions updated : '||SQL%ROWCOUNT,

2747: AND application_id = g_application_id
2748: AND description_prio_id IS NOT NULL;
2749:
2750: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2751: trace(p_msg => '# xla_conditions updated : '||SQL%ROWCOUNT,
2752: p_module => l_log_module,
2753: p_level => C_LEVEL_STATEMENT);
2754: END IF;
2755:

Line 3194: DELETE FROM xla_conditions c

3190:
3191: IF (l_adr_codes.COUNT > 0) THEN
3192: -- Delete the ADRs from the working area to be merged
3193: FORALL i IN 1..l_adr_codes.COUNT
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

Line 3206: trace(p_msg => '# xla_conditions delete : '||SQL%ROWCOUNT,

3202: AND w.segment_rule_type_code = l_adr_type_codes(i)
3203: AND w.segment_rule_code = l_adr_codes(i));
3204:
3205: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3206: trace(p_msg => '# xla_conditions delete : '||SQL%ROWCOUNT,
3207: p_module => l_log_module,
3208: p_level => C_LEVEL_STATEMENT);
3209: END IF;
3210:

Line 3312: UPDATE xla_conditions

3308: p_module => l_log_module,
3309: p_level => C_LEVEL_STATEMENT);
3310: END IF;
3311:
3312: UPDATE xla_conditions
3313: SET amb_context_code = g_amb_context_code
3314: WHERE amb_context_code = g_staging_context_code
3315: AND application_id = g_application_id
3316: AND segment_rule_detail_id IS NOT NULL;

Line 3319: trace(p_msg => '# xla_conditions updated : '||SQL%ROWCOUNT,

3315: AND application_id = g_application_id
3316: AND segment_rule_detail_id IS NOT NULL;
3317:
3318: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3319: trace(p_msg => '# xla_conditions updated : '||SQL%ROWCOUNT,
3320: p_module => l_log_module,
3321: p_level => C_LEVEL_STATEMENT);
3322: END IF;
3323:

Line 3927: DELETE FROM xla_conditions

3923: p_module => l_log_module,
3924: p_level => C_LEVEL_PROCEDURE);
3925: END IF;
3926:
3927: DELETE FROM xla_conditions
3928: WHERE amb_context_code = g_staging_context_code
3929: AND segment_rule_detail_id IS NOT NULl;
3930:
3931: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 3932: trace(p_msg => '# xla_conditions delete : '||SQL%ROWCOUNT,

3928: WHERE amb_context_code = g_staging_context_code
3929: AND segment_rule_detail_id IS NOT NULl;
3930:
3931: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3932: trace(p_msg => '# xla_conditions delete : '||SQL%ROWCOUNT,
3933: p_module => l_log_module,
3934: p_level => C_LEVEL_STATEMENT);
3935: END IF;
3936: