APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_MPA_JLT_AC_ASSGNS

Line 419: DELETE FROM xla_mpa_jlt_ac_assgns

415: p_module => l_log_module,
416: p_level => C_LEVEL_STATEMENT);
417: END IF;
418:
419: DELETE FROM xla_mpa_jlt_ac_assgns
420: WHERE application_id = p_application_id
421: AND amb_context_code = p_amb_context_code;
422:
423: -- Bug : 16208537

Line 430: p_encoded_message => '# delete (xla_mpa_jlt_ac_assgns) = '||SQL%ROWCOUNT,

426: p_amb_context_code => p_amb_context_code,
427: p_application_id => p_application_id,
428: p_request_code => 'IMPORT' ,
429: p_log_type_code => 'MERGE',
430: p_encoded_message => '# delete (xla_mpa_jlt_ac_assgns) = '||SQL%ROWCOUNT,
431: p_component_code => 'purge');
432:
433: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
434: trace(p_msg => '# record deleted from xla_mpa_jlt_ac_assgns = '||SQL%ROWCOUNT,

Line 434: trace(p_msg => '# record deleted from xla_mpa_jlt_ac_assgns = '||SQL%ROWCOUNT,

430: p_encoded_message => '# delete (xla_mpa_jlt_ac_assgns) = '||SQL%ROWCOUNT,
431: p_component_code => 'purge');
432:
433: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
434: trace(p_msg => '# record deleted from xla_mpa_jlt_ac_assgns = '||SQL%ROWCOUNT,
435: p_module => l_log_module,
436: p_level => C_LEVEL_STATEMENT);
437: END IF;
438:

Line 849: FROM xla_mpa_jlt_ac_assgns

845: FOR UPDATE NOWAIT;
846:
847: CURSOR c_mpa_jlt_ac_assgns IS
848: SELECT *
849: FROM xla_mpa_jlt_ac_assgns
850: WHERE application_id = p_application_id
851: AND amb_context_code = p_amb_context_code
852: FOR UPDATE NOWAIT;
853:

Line 1050: FROM xla_mpa_jlt_ac_assgns xld

1046: AND xld.application_id = p_application_id
1047: AND xld.amb_context_code = p_amb_context_code
1048: UNION
1049: SELECT 1
1050: FROM xla_mpa_jlt_ac_assgns xld
1051: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1052: AND xld.analytical_criterion_code = b.analytical_criterion_code
1053: AND xld.amb_context_code = b.amb_context_code
1054: AND xld.application_id = p_application_id

Line 1091: FROM xla_mpa_jlt_ac_assgns xld

1087: AND xld.application_id = p_application_id
1088: AND xld.amb_context_code = p_amb_context_code
1089: UNION
1090: SELECT 1
1091: FROM xla_mpa_jlt_ac_assgns xld
1092: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1093: AND xld.analytical_criterion_code = b.analytical_criterion_code
1094: AND xld.amb_context_code = b.amb_context_code
1095: AND xld.application_id = p_application_id

Line 1128: FROM xla_mpa_jlt_ac_assgns xld

1124: AND xld.application_id = p_application_id
1125: AND xld.amb_context_code = p_amb_context_code
1126: UNION
1127: SELECT 1
1128: FROM xla_mpa_jlt_ac_assgns xld
1129: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1130: AND xld.analytical_criterion_code = b.analytical_criterion_code
1131: AND xld.amb_context_code = b.amb_context_code
1132: AND xld.application_id = p_application_id

Line 3261: DELETE FROM xla_mpa_jlt_ac_assgns

3257: p_module => l_log_module,
3258: p_level => C_LEVEL_PROCEDURE);
3259: END IF;
3260:
3261: DELETE FROM xla_mpa_jlt_ac_assgns
3262: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3263: AND application_id = p_application_id;
3264:
3265: -- Bug 16208537

Line 3272: p_encoded_message => '# delete (xla_mpa_jlt_ac_assgns) = '||SQL%ROWCOUNT,

3268: p_amb_context_code => p_amb_context_code,
3269: p_application_id => p_application_id,
3270: p_request_code => 'IMPORT' ,
3271: p_log_type_code => 'MERGE',
3272: p_encoded_message => '# delete (xla_mpa_jlt_ac_assgns) = '||SQL%ROWCOUNT,
3273: p_component_code => 'purge_aad');
3274:
3275: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3276: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||SQL%ROWCOUNT,

Line 3276: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||SQL%ROWCOUNT,

3272: p_encoded_message => '# delete (xla_mpa_jlt_ac_assgns) = '||SQL%ROWCOUNT,
3273: p_component_code => 'purge_aad');
3274:
3275: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3276: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||SQL%ROWCOUNT,
3277: p_module => l_log_module,
3278: p_level => C_LEVEL_PROCEDURE);
3279: END IF;
3280: