APPS.XLA_AAD_MERGE_PVT dependencies on XLA_JLT_ACCT_ATTRS

Line 944: DELETE FROM xla_jlt_acct_attrs w

940: p_level => C_LEVEL_STATEMENT);
941: END IF;
942:
943: FORALL i IN 1..l_codes.COUNT
944: DELETE FROM xla_jlt_acct_attrs w
945: WHERE application_id = g_application_id
946: AND amb_context_code = g_amb_context_code
947: AND event_class_code = l_event_class_codes(i)
948: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 952: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||SQL%ROWCOUNT,

948: AND accounting_line_type_code = C_OWNER_SYSTEM
949: AND accounting_line_code = l_codes(i);
950:
951: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
952: trace(p_msg => '# xla_jlt_acct_attrs deleted = '||SQL%ROWCOUNT,
953: p_module => l_log_module,
954: p_level => C_LEVEL_STATEMENT);
955: END IF;
956:

Line 2419: DELETE FROM xla_jlt_acct_attrs w

2415: p_module => l_log_module,
2416: p_level => C_LEVEL_STATEMENT);
2417: END IF;
2418:
2419: DELETE FROM xla_jlt_acct_attrs w
2420: WHERE application_id = g_application_id
2421: AND amb_context_code = g_amb_context_code
2422: AND EXISTS (SELECT 1
2423: FROM xla_jlt_acct_attrs s

Line 2423: FROM xla_jlt_acct_attrs s

2419: DELETE FROM xla_jlt_acct_attrs w
2420: WHERE application_id = g_application_id
2421: AND amb_context_code = g_amb_context_code
2422: AND EXISTS (SELECT 1
2423: FROM xla_jlt_acct_attrs s
2424: WHERE s.application_id = g_application_id
2425: AND s.amb_context_code = g_staging_context_code
2426: AND s.event_class_code = w.event_class_code
2427: AND s.accounting_line_type_code = w.accounting_line_type_code

Line 2431: trace(p_msg => '# xla_jlt_acct_attrs delete : '||SQL%ROWCOUNT,

2427: AND s.accounting_line_type_code = w.accounting_line_type_code
2428: AND s.accounting_line_code = w.accounting_line_code);
2429:
2430: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2431: trace(p_msg => '# xla_jlt_acct_attrs delete : '||SQL%ROWCOUNT,
2432: p_module => l_log_module,
2433: p_level => C_LEVEL_STATEMENT);
2434: END IF;
2435:

Line 2448: trace(p_msg => '# xla_jlt_acct_attrs delete : '||SQL%ROWCOUNT,

2444: AND s.accounting_line_type_code = w.accounting_line_type_code
2445: AND s.accounting_line_code = w.accounting_line_code);
2446:
2447: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2448: trace(p_msg => '# xla_jlt_acct_attrs delete : '||SQL%ROWCOUNT,
2449: p_module => l_log_module,
2450: p_level => C_LEVEL_STATEMENT);
2451: END IF;
2452:

Line 2506: UPDATE xla_jlt_acct_attrs

2502: p_module => l_log_module,
2503: p_level => C_LEVEL_STATEMENT);
2504: END IF;
2505:
2506: UPDATE xla_jlt_acct_attrs
2507: SET amb_context_code = g_amb_context_code
2508: WHERE application_id = g_application_id
2509: AND amb_context_code = g_staging_context_code;
2510:

Line 2512: trace(p_msg => '# xla_jlt_acct_attrs updated : '||SQL%ROWCOUNT,

2508: WHERE application_id = g_application_id
2509: AND amb_context_code = g_staging_context_code;
2510:
2511: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2512: trace(p_msg => '# xla_jlt_acct_attrs updated : '||SQL%ROWCOUNT,
2513: p_module => l_log_module,
2514: p_level => C_LEVEL_STATEMENT);
2515: END IF;
2516: