APPS.XLA_AAD_MERGE_PVT dependencies on XLA_AAD_LOADER_LOGS

Line 335: INSERT INTO xla_aad_loader_logs

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

Line 356: (xla_aad_loader_logs_s.nextval

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

Line 1550: INSERT INTO xla_aad_loader_logs

1546: -- Record if the deleted AAD is used by any other application
1547: IF (l_codes.COUNT > 0) THEN
1548:
1549: FORALL i IN 1..l_codes.COUNT
1550: INSERT INTO xla_aad_loader_logs
1551: (aad_loader_log_id
1552: ,amb_context_code
1553: ,application_id
1554: ,request_code

Line 1570: SELECT xla_aad_loader_logs_s.nextval

1566: ,program_update_date
1567: ,program_application_id
1568: ,program_id
1569: ,request_id)
1570: SELECT xla_aad_loader_logs_s.nextval
1571: ,g_amb_context_code
1572: ,g_application_id
1573: ,'IMPORT'
1574: ,'DELETED_SETUP'

Line 1614: trace(p_msg => '# xla_aad_loader_logs inserted = '||l_num_rows,

1610: AND segment_rule_type_code = C_OWNER_SYSTEM
1611: AND segment_rule_code = l_codes(i));
1612: l_num_rows := SQL%ROWCOUNT;
1613: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1614: trace(p_msg => '# xla_aad_loader_logs inserted = '||l_num_rows,
1615: p_module => l_log_module,
1616: p_level => C_LEVEL_STATEMENT);
1617: END IF;
1618: -- Bug : 9923803

Line 1625: p_encoded_message =>'# xla_aad_loader_logs inserted = '||l_num_rows,

1621: p_amb_context_code => g_amb_context_code,
1622: p_application_id => g_application_id,
1623: p_request_code => 'IMPORT' ,
1624: p_log_type_code => 'MERGE',
1625: p_encoded_message =>'# xla_aad_loader_logs inserted = '||l_num_rows,
1626: p_component_code => 'clean_oracle_adrs');
1627:
1628: -- Delete the reference to Oracle ADR to be deleted
1629: FORALL i IN 1..l_codes.COUNT

Line 2116: INSERT INTO xla_aad_loader_logs

2112: IF (g_analyzed_flag = 'Y') THEN
2113: null;
2114: ELSE
2115: -- record log
2116: INSERT INTO xla_aad_loader_logs
2117: (aad_loader_log_id
2118: ,amb_context_code
2119: ,application_id
2120: ,request_code

Line 2137: SELECT xla_aad_loader_logs_s.nextval

2133: ,program_update_date
2134: ,program_application_id
2135: ,program_id
2136: ,request_id)
2137: SELECT xla_aad_loader_logs_s.nextval
2138: ,g_amb_context_code
2139: ,g_application_id
2140: ,'IMPORT'
2141: ,'MERGED_AAD'

Line 6295: INSERT INTO xla_aad_loader_logs

6291: AND xamr2.accounting_method_code = xamr.accounting_method_code
6292: AND xamr2.application_id = g_application_id);
6293: l_num_rows := SQL%ROWCOUNT;
6294:
6295: INSERT INTO xla_aad_loader_logs
6296: (aad_loader_log_id
6297: ,amb_context_code
6298: ,application_id
6299: ,request_code

Line 6317: SELECT xla_aad_loader_logs_s.nextval

6313: ,program_update_date
6314: ,program_application_id
6315: ,program_id
6316: ,request_id)
6317: SELECT xla_aad_loader_logs_s.nextval
6318: ,g_amb_context_code
6319: ,g_application_id
6320: ,'IMPORT'
6321: ,'UNMERGE_AAD_IN_SLAM'