APPS.XLA_AAD_MERGE_PVT dependencies on XLA_ACCT_LINE_TYPES_TL

Line 972: DELETE FROM xla_acct_line_types_tl w

968: p_level => C_LEVEL_STATEMENT);
969: END IF;
970:
971: FORALL i IN 1..l_codes.COUNT
972: DELETE FROM xla_acct_line_types_tl w
973: WHERE application_id = g_application_id
974: AND amb_context_code = g_amb_context_code
975: AND event_class_code = l_event_class_codes(i)
976: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 980: trace(p_msg => '# xla_acct_line_types_tl deleted = '||SQL%ROWCOUNT,

976: AND accounting_line_type_code = C_OWNER_SYSTEM
977: AND accounting_line_code = l_codes(i);
978:
979: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
980: trace(p_msg => '# xla_acct_line_types_tl deleted = '||SQL%ROWCOUNT,
981: p_module => l_log_module,
982: p_level => C_LEVEL_STATEMENT);
983: END IF;
984:

Line 2401: DELETE FROM xla_acct_line_types_tl w

2397: p_module => l_log_module,
2398: p_level => C_LEVEL_STATEMENT);
2399: END IF;
2400:
2401: DELETE FROM xla_acct_line_types_tl w
2402: WHERE application_id = g_application_id
2403: AND amb_context_code = g_amb_context_code
2404: AND EXISTS (SELECT 1
2405: FROM xla_acct_line_types_tl s

Line 2405: FROM xla_acct_line_types_tl s

2401: DELETE FROM xla_acct_line_types_tl w
2402: WHERE application_id = g_application_id
2403: AND amb_context_code = g_amb_context_code
2404: AND EXISTS (SELECT 1
2405: FROM xla_acct_line_types_tl s
2406: WHERE s.application_id = g_application_id
2407: AND s.amb_context_code = g_staging_context_code
2408: AND s.event_class_code = w.event_class_code
2409: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 2414: trace(p_msg => '# xla_acct_line_types_tl delete : '||SQL%ROWCOUNT,

2410: AND s.accounting_line_code = w.accounting_line_code
2411: AND s.language = w.language);
2412:
2413: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2414: trace(p_msg => '# xla_acct_line_types_tl delete : '||SQL%ROWCOUNT,
2415: p_module => l_log_module,
2416: p_level => C_LEVEL_STATEMENT);
2417: END IF;
2418:

Line 2467: UPDATE xla_acct_line_types_tl w

2463: p_module => l_log_module,
2464: p_level => C_LEVEL_STATEMENT);
2465: END IF;
2466:
2467: UPDATE xla_acct_line_types_tl w
2468: SET amb_context_code = g_amb_context_code
2469: WHERE application_id = g_application_id
2470: AND amb_context_code = g_staging_context_code
2471: AND NOT EXISTS (SELECT 1

Line 2472: FROM xla_acct_line_types_tl s

2468: SET amb_context_code = g_amb_context_code
2469: WHERE application_id = g_application_id
2470: AND amb_context_code = g_staging_context_code
2471: AND NOT EXISTS (SELECT 1
2472: FROM xla_acct_line_types_tl s
2473: WHERE s.application_id = g_application_id
2474: AND s.amb_context_code = g_amb_context_code
2475: AND s.event_class_code = w.event_class_code
2476: AND s.accounting_line_type_code = w.accounting_line_type_code

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

2477: AND s.name = w.name
2478: AND s.language = w.language);
2479:
2480: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2481: trace(p_msg => '# xla_acct_line_types_tl 1 updated : '||SQL%ROWCOUNT,
2482: p_module => l_log_module,
2483: p_level => C_LEVEL_STATEMENT);
2484: END IF;
2485:

Line 2486: UPDATE xla_acct_line_types_tl w

2482: p_module => l_log_module,
2483: p_level => C_LEVEL_STATEMENT);
2484: END IF;
2485:
2486: UPDATE xla_acct_line_types_tl w
2487: SET amb_context_code = g_amb_context_code
2488: , name = substr('('||w.accounting_line_code||') '||name,1,80)
2489: WHERE application_id = g_application_id
2490: AND amb_context_code = g_staging_context_code

Line 2492: FROM xla_acct_line_types_tl s

2488: , name = substr('('||w.accounting_line_code||') '||name,1,80)
2489: WHERE application_id = g_application_id
2490: AND amb_context_code = g_staging_context_code
2491: AND EXISTS (SELECT 1
2492: FROM xla_acct_line_types_tl s
2493: WHERE s.application_id = g_application_id
2494: AND s.amb_context_code = g_amb_context_code
2495: AND s.event_class_code = w.event_class_code
2496: AND s.accounting_line_type_code = w.accounting_line_type_code

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

2497: AND s.name = w.name
2498: AND s.language = w.language);
2499:
2500: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2501: trace(p_msg => '# xla_acct_line_types_tl 2 updated : '||SQL%ROWCOUNT,
2502: p_module => l_log_module,
2503: p_level => C_LEVEL_STATEMENT);
2504: END IF;
2505: