DBA Data[Home] [Help]

APPS.XLA_AAD_MERGE_PVT dependencies on XLA_AAD_LOADER_LOGS

Line 334: INSERT INTO xla_aad_loader_logs

330: END IF;
331:
332: -- Insert log
333: FORALL i IN 1..l_codes.COUNT
334: INSERT INTO xla_aad_loader_logs
335: (aad_loader_log_id
336: ,amb_context_code
337: ,application_id
338: ,request_code

Line 355: (xla_aad_loader_logs_s.nextval

351: ,program_application_id
352: ,program_id
353: ,request_id)
354: VALUES
355: (xla_aad_loader_logs_s.nextval
356: ,g_amb_context_code
357: ,g_application_id
358: ,'IMPORT'
359: ,'DELETED_AAD'

Line 1240: INSERT INTO xla_aad_loader_logs

1236: -- Record if the deleted AAD is used by any other application
1237: IF (l_codes.COUNT > 0) THEN
1238:
1239: FORALL i IN 1..l_codes.COUNT
1240: INSERT INTO xla_aad_loader_logs
1241: (aad_loader_log_id
1242: ,amb_context_code
1243: ,application_id
1244: ,request_code

Line 1260: SELECT xla_aad_loader_logs_s.nextval

1256: ,program_update_date
1257: ,program_application_id
1258: ,program_id
1259: ,request_id)
1260: SELECT xla_aad_loader_logs_s.nextval
1261: ,g_amb_context_code
1262: ,g_application_id
1263: ,'IMPORT'
1264: ,'DELETED_SETUP'

Line 1304: trace(p_msg => '# xla_aad_loader_logs inserted = '||SQL%ROWCOUNT,

1300: AND segment_rule_type_code = C_OWNER_SYSTEM
1301: AND segment_rule_code = l_codes(i));
1302:
1303: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1304: trace(p_msg => '# xla_aad_loader_logs inserted = '||SQL%ROWCOUNT,
1305: p_module => l_log_module,
1306: p_level => C_LEVEL_STATEMENT);
1307: END IF;
1308:

Line 1678: INSERT INTO xla_aad_loader_logs

1674: IF (g_analyzed_flag = 'Y') THEN
1675: null;
1676: ELSE
1677: -- record log
1678: INSERT INTO xla_aad_loader_logs
1679: (aad_loader_log_id
1680: ,amb_context_code
1681: ,application_id
1682: ,request_code

Line 1699: SELECT xla_aad_loader_logs_s.nextval

1695: ,program_update_date
1696: ,program_application_id
1697: ,program_id
1698: ,request_id)
1699: SELECT xla_aad_loader_logs_s.nextval
1700: ,g_amb_context_code
1701: ,g_application_id
1702: ,'IMPORT'
1703: ,'MERGED_AAD'

Line 3615: INSERT INTO xla_aad_loader_logs

3611: AND xamr2.accounting_method_type_code = xamr.accounting_method_type_code
3612: AND xamr2.accounting_method_code = xamr.accounting_method_code
3613: AND xamr2.application_id = g_application_id);
3614:
3615: INSERT INTO xla_aad_loader_logs
3616: (aad_loader_log_id
3617: ,amb_context_code
3618: ,application_id
3619: ,request_code

Line 3636: SELECT xla_aad_loader_logs_s.nextval

3632: ,program_update_date
3633: ,program_application_id
3634: ,program_id
3635: ,request_id)
3636: SELECT xla_aad_loader_logs_s.nextval
3637: ,g_amb_context_code
3638: ,g_application_id
3639: ,'IMPORT'
3640: ,'UNMERGE_AAD_IN_SLAM'