APPS.XLA_AAD_MERGE_PVT dependencies on XLA_LINE_DEFINITIONS_B

Line 527: FROM xla_line_definitions_b w

523: CURSOR c_all_comps IS
524: SELECT w.event_class_code
525: , w.event_type_code
526: , w.line_definition_code
527: FROM xla_line_definitions_b w
528: WHERE w.application_id = g_application_id
529: AND w.amb_context_code = g_amb_context_code
530: AND w.line_definition_owner_code = C_OWNER_SYSTEM
531: AND NOT EXISTS ( SELECT 1

Line 532: FROM xla_line_definitions_b s

528: WHERE w.application_id = g_application_id
529: AND w.amb_context_code = g_amb_context_code
530: AND w.line_definition_owner_code = C_OWNER_SYSTEM
531: AND NOT EXISTS ( SELECT 1
532: FROM xla_line_definitions_b s
533: WHERE s.application_id = g_application_id
534: AND s.amb_context_code = g_staging_context_code
535: AND s.event_class_code = w.event_class_code
536: AND s.event_type_code = w.event_type_code

Line 767: DELETE FROM xla_line_definitions_b w

763: p_level => C_LEVEL_STATEMENT);
764: END IF;
765:
766: FORALL i IN 1..l_codes.COUNT
767: DELETE FROM xla_line_definitions_b w
768: WHERE application_id = g_application_id
769: AND amb_context_code = g_amb_context_code
770: AND event_class_code = l_event_class_codes(i)
771: AND event_type_code = l_event_type_codes(i)

Line 776: trace(p_msg => '# xla_line_definitions_b deleted = '||SQL%ROWCOUNT,

772: AND line_definition_owner_code = C_OWNER_SYSTEM
773: AND line_definition_code = l_codes(i);
774:
775: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
776: trace(p_msg => '# xla_line_definitions_b deleted = '||SQL%ROWCOUNT,
777: p_module => l_log_module,
778: p_level => C_LEVEL_STATEMENT);
779: END IF;
780:

Line 1976: DELETE FROM xla_line_definitions_b w

1972: ELSE
1973:
1974: -- Delete the journal line definitions from the working area if it already
1975: -- exists in the staging area
1976: DELETE FROM xla_line_definitions_b w
1977: WHERE application_id = g_application_id
1978: AND amb_context_code = g_amb_context_code
1979: AND EXISTS (SELECT 1
1980: FROM xla_line_definitions_b s

Line 1980: FROM xla_line_definitions_b s

1976: DELETE FROM xla_line_definitions_b w
1977: WHERE application_id = g_application_id
1978: AND amb_context_code = g_amb_context_code
1979: AND EXISTS (SELECT 1
1980: FROM xla_line_definitions_b s
1981: WHERE s.application_id = g_application_id
1982: AND s.amb_context_code = g_staging_context_code
1983: AND s.event_class_code = w.event_class_code
1984: AND s.event_type_code = w.event_type_code

Line 1989: trace(p_msg => '# xla_line_definitions_b deleted : '||SQL%ROWCOUNT,

1985: AND s.line_definition_owner_code = w.line_definition_owner_code
1986: AND s.line_definition_code = w.line_definition_code);
1987:
1988: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1989: trace(p_msg => '# xla_line_definitions_b deleted : '||SQL%ROWCOUNT,
1990: p_module => l_log_module,
1991: p_level => C_LEVEL_STATEMENT);
1992: END IF;
1993:

Line 2200: UPDATE xla_line_definitions_b

2196:
2197: END IF;
2198:
2199: -- Move the journal line definitions from staging area to working area
2200: UPDATE xla_line_definitions_b
2201: SET amb_context_code = g_amb_context_code
2202: WHERE application_id = g_application_id
2203: AND amb_context_code = g_staging_context_code;
2204:

Line 2206: trace(p_msg => '# xla_line_definitions_b updated : '||SQL%ROWCOUNT,

2202: WHERE application_id = g_application_id
2203: AND amb_context_code = g_staging_context_code;
2204:
2205: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2206: trace(p_msg => '# xla_line_definitions_b updated : '||SQL%ROWCOUNT,
2207: p_module => l_log_module,
2208: p_level => C_LEVEL_STATEMENT);
2209: END IF;
2210: