APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_AAD_LOADER_LOGS

Line 318: INSERT INTO xla_aad_loader_logs

314: p_module => l_log_module,
315: p_level => C_LEVEL_PROCEDURE);
316: END IF;
317:
318: INSERT INTO xla_aad_loader_logs
319: (aad_loader_log_id
320: ,amb_context_code
321: ,application_id
322: ,request_code

Line 338: SELECT xla_aad_loader_logs_s.nextval

334: ,program_update_date
335: ,program_application_id
336: ,program_id
337: ,request_id)
338: SELECT xla_aad_loader_logs_s.nextval
339: ,g_amb_context_code
340: ,g_application_id
341: ,'IMPORT'
342: ,'OVERWRITTEN_AAD'

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

358: WHERE s.application_id = g_application_id
359: AND s.amb_context_code = g_staging_context_code;
360:
361: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
362: trace(p_msg => '# row inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT,
363: p_module => l_log_module,
364: p_level => C_LEVEL_STATEMENT);
365: END IF;
366:

Line 550: INSERT INTO xla_aad_loader_logs

546: p_level => C_LEVEL_EVENT);
547: END IF;
548:
549: IF (i > 0) THEN
550: INSERT INTO xla_aad_loader_logs
551: (aad_loader_log_id
552: ,amb_context_code
553: ,application_id
554: ,request_code

Line 571: SELECT xla_aad_loader_logs_s.nextval

567: ,program_update_date
568: ,program_application_id
569: ,program_id
570: ,request_id)
571: SELECT xla_aad_loader_logs_s.nextval
572: ,g_amb_context_code
573: ,g_application_id
574: ,'IMPORT'
575: ,'MERGED_SETUP'

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

594: AND d.application_id <> g_application_id
595: AND d.value_mapping_set_code = ms.component_code;
596:
597: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
598: trace(p_msg => '# row inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT,
599: p_module => l_log_module,
600: p_level => C_LEVEL_STATEMENT);
601: END IF;
602:

Line 746: INSERT INTO xla_aad_loader_logs

742:
743: IF (i>0) THEN
744: g_ac_updated := TRUE;
745:
746: INSERT INTO xla_aad_loader_logs
747: (aad_loader_log_id
748: ,amb_context_code
749: ,application_id
750: ,request_code

Line 768: SELECT xla_aad_loader_logs_s.nextval

764: ,program_update_date
765: ,program_application_id
766: ,program_id
767: ,request_id)
768: SELECT xla_aad_loader_logs_s.nextval
769: ,g_amb_context_code
770: ,g_application_id
771: ,'IMPORT'
772: ,'MERGED_SETUP'

Line 816: trace(p_msg => '# row insert into xla_aad_loader_logs = '||SQL%ROWCOUNT,

812: AND a.analytical_criterion_code = ac.component_code
813: AND ac.version_from IS NOT NULL);
814:
815: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
816: trace(p_msg => '# row insert into xla_aad_loader_logs = '||SQL%ROWCOUNT,
817: p_module => l_log_module,
818: p_level => C_LEVEL_STATEMENT);
819: END IF;
820:

Line 989: INSERT INTO xla_aad_loader_logs

985: p_level => C_LEVEL_EVENT);
986: END IF;
987:
988: IF (i>0) THEN
989: INSERT INTO xla_aad_loader_logs
990: (aad_loader_log_id
991: ,amb_context_code
992: ,application_id
993: ,request_code

Line 1011: SELECT xla_aad_loader_logs_s.nextval

1007: ,program_update_date
1008: ,program_application_id
1009: ,program_id
1010: ,request_id)
1011: SELECT xla_aad_loader_logs_s.nextval
1012: ,g_amb_context_code
1013: ,g_application_id
1014: ,'IMPORT'
1015: ,'MERGED_SETUP'

Line 1061: trace(p_msg => '# row insert into xla_aad_loader_logs = '||SQL%ROWCOUNT,

1057: AND a.value_segment_rule_code = adr.component_code
1058: AND adr.version_from IS NOT NULL);
1059:
1060: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1061: trace(p_msg => '# row insert into xla_aad_loader_logs = '||SQL%ROWCOUNT,
1062: p_module => l_log_module,
1063: p_level => C_LEVEL_STATEMENT);
1064: END IF;
1065:

Line 1163: INSERT INTO xla_aad_loader_logs

1159: p_module => l_log_module,
1160: p_level => C_LEVEL_PROCEDURE);
1161: END IF;
1162:
1163: INSERT INTO xla_aad_loader_logs
1164: (aad_loader_log_id
1165: ,amb_context_code
1166: ,application_id
1167: ,request_code

Line 1183: SELECT xla_aad_loader_logs_s.nextval

1179: ,program_update_date
1180: ,program_application_id
1181: ,program_id
1182: ,request_id)
1183: SELECT xla_aad_loader_logs_s.nextval
1184: ,g_amb_context_code
1185: ,g_application_id
1186: ,'IMPORT'
1187: ,'DELETED_SETUP'