APPS.XLA_AAD_MERGE_PVT dependencies on XLA_LINE_DEFINITIONS_TL

Line 752: DELETE FROM xla_line_definitions_tl w

748: p_level => C_LEVEL_STATEMENT);
749: END IF;
750:
751: FORALL i IN 1..l_codes.COUNT
752: DELETE FROM xla_line_definitions_tl w
753: WHERE application_id = g_application_id
754: AND amb_context_code = g_amb_context_code
755: AND event_class_code = l_event_class_codes(i)
756: AND event_type_code = l_event_type_codes(i)

Line 761: trace(p_msg => '# xla_line_definitions_tl deleted = '||SQL%ROWCOUNT,

757: AND line_definition_owner_code = C_OWNER_SYSTEM
758: AND line_definition_code = l_codes(i);
759:
760: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
761: trace(p_msg => '# xla_line_definitions_tl deleted = '||SQL%ROWCOUNT,
762: p_module => l_log_module,
763: p_level => C_LEVEL_STATEMENT);
764: END IF;
765:

Line 1994: DELETE FROM xla_line_definitions_tl w

1990: p_module => l_log_module,
1991: p_level => C_LEVEL_STATEMENT);
1992: END IF;
1993:
1994: DELETE FROM xla_line_definitions_tl w
1995: WHERE application_id = g_application_id
1996: AND amb_context_code = g_amb_context_code
1997: AND EXISTS (SELECT 1
1998: FROM xla_line_definitions_tl s

Line 1998: FROM xla_line_definitions_tl s

1994: DELETE FROM xla_line_definitions_tl w
1995: WHERE application_id = g_application_id
1996: AND amb_context_code = g_amb_context_code
1997: AND EXISTS (SELECT 1
1998: FROM xla_line_definitions_tl s
1999: WHERE s.application_id = g_application_id
2000: AND s.amb_context_code = g_staging_context_code
2001: AND s.event_class_code = w.event_class_code
2002: AND s.event_type_code = w.event_type_code

Line 2008: trace(p_msg => '# xla_line_definitions_tl deleted : '||SQL%ROWCOUNT,

2004: AND s.line_definition_code = w.line_definition_code
2005: AND s.language = w.language);
2006:
2007: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2008: trace(p_msg => '# xla_line_definitions_tl deleted : '||SQL%ROWCOUNT,
2009: p_module => l_log_module,
2010: p_level => C_LEVEL_STATEMENT);
2011: END IF;
2012:

Line 2211: UPDATE xla_line_definitions_tl w

2207: p_module => l_log_module,
2208: p_level => C_LEVEL_STATEMENT);
2209: END IF;
2210:
2211: UPDATE xla_line_definitions_tl w
2212: SET amb_context_code = g_amb_context_code
2213: WHERE application_id = g_application_id
2214: AND amb_context_code = g_staging_context_code
2215: AND NOT EXISTS (SELECT 1

Line 2216: FROM xla_line_definitions_tl s

2212: SET amb_context_code = g_amb_context_code
2213: WHERE application_id = g_application_id
2214: AND amb_context_code = g_staging_context_code
2215: AND NOT EXISTS (SELECT 1
2216: FROM xla_line_definitions_tl s
2217: WHERE s.application_id = g_application_id
2218: AND s.amb_context_code = g_amb_context_code
2219: AND s.event_class_code = w.event_class_code
2220: AND s.event_type_code = w.event_type_code

Line 2226: trace(p_msg => '# xla_line_definitions_tl 1 updated : '||SQL%ROWCOUNT,

2222: AND s.name = w.name
2223: AND s.language = w.language);
2224:
2225: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2226: trace(p_msg => '# xla_line_definitions_tl 1 updated : '||SQL%ROWCOUNT,
2227: p_module => l_log_module,
2228: p_level => C_LEVEL_STATEMENT);
2229: END IF;
2230:

Line 2231: UPDATE xla_line_definitions_tl w

2227: p_module => l_log_module,
2228: p_level => C_LEVEL_STATEMENT);
2229: END IF;
2230:
2231: UPDATE xla_line_definitions_tl w
2232: SET amb_context_code = g_amb_context_code
2233: , name = substr('('||line_definition_code||') '||name,1,80)
2234: WHERE application_id = g_application_id
2235: AND amb_context_code = g_staging_context_code

Line 2237: FROM xla_line_definitions_tl s

2233: , name = substr('('||line_definition_code||') '||name,1,80)
2234: WHERE application_id = g_application_id
2235: AND amb_context_code = g_staging_context_code
2236: AND EXISTS (SELECT 1
2237: FROM xla_line_definitions_tl s
2238: WHERE s.application_id = g_application_id
2239: AND s.amb_context_code = g_amb_context_code
2240: AND s.event_class_code = w.event_class_code
2241: AND s.event_type_code = w.event_type_code

Line 2247: trace(p_msg => '# xla_line_definitions_tl 2 updated : '||SQL%ROWCOUNT,

2243: AND s.name = w.name
2244: AND s.language = w.language);
2245:
2246: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2247: trace(p_msg => '# xla_line_definitions_tl 2 updated : '||SQL%ROWCOUNT,
2248: p_module => l_log_module,
2249: p_level => C_LEVEL_STATEMENT);
2250: END IF;
2251: