APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_MPA_JLT_ASSGNS

Line 439: DELETE FROM xla_mpa_jlt_assgns

435: p_module => l_log_module,
436: p_level => C_LEVEL_STATEMENT);
437: END IF;
438:
439: DELETE FROM xla_mpa_jlt_assgns
440: WHERE application_id = p_application_id
441: AND amb_context_code = p_amb_context_code;
442:
443: -- Bug : 16208537

Line 450: p_encoded_message => '# delete (xla_mpa_jlt_assgns) = '||SQL%ROWCOUNT,

446: p_amb_context_code => p_amb_context_code,
447: p_application_id => p_application_id,
448: p_request_code => 'IMPORT' ,
449: p_log_type_code => 'MERGE',
450: p_encoded_message => '# delete (xla_mpa_jlt_assgns) = '||SQL%ROWCOUNT,
451: p_component_code => 'purge');
452:
453: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
454: trace(p_msg => '# record deleted from xla_mpa_jlt_assgns = '||SQL%ROWCOUNT,

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

450: p_encoded_message => '# delete (xla_mpa_jlt_assgns) = '||SQL%ROWCOUNT,
451: p_component_code => 'purge');
452:
453: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
454: trace(p_msg => '# record deleted from xla_mpa_jlt_assgns = '||SQL%ROWCOUNT,
455: p_module => l_log_module,
456: p_level => C_LEVEL_STATEMENT);
457: END IF;
458:

Line 863: FROM xla_mpa_jlt_assgns

859: FOR UPDATE NOWAIT;
860:
861: CURSOR c_mpa_jlt_assgns IS
862: SELECT *
863: FROM xla_mpa_jlt_assgns
864: WHERE application_id = p_application_id
865: AND amb_context_code = p_amb_context_code
866: FOR UPDATE NOWAIT;
867:

Line 3281: DELETE FROM xla_mpa_jlt_assgns

3277: p_module => l_log_module,
3278: p_level => C_LEVEL_PROCEDURE);
3279: END IF;
3280:
3281: DELETE FROM xla_mpa_jlt_assgns
3282: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3283: AND application_id = p_application_id;
3284:
3285: -- Bug 16208537

Line 3292: p_encoded_message => '# delete (xla_mpa_jlt_assgns) = '||SQL%ROWCOUNT,

3288: p_amb_context_code => p_amb_context_code,
3289: p_application_id => p_application_id,
3290: p_request_code => 'IMPORT' ,
3291: p_log_type_code => 'MERGE',
3292: p_encoded_message => '# delete (xla_mpa_jlt_assgns) = '||SQL%ROWCOUNT,
3293: p_component_code => 'purge_aad');
3294:
3295: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3296: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,

Line 3296: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,

3292: p_encoded_message => '# delete (xla_mpa_jlt_assgns) = '||SQL%ROWCOUNT,
3293: p_component_code => 'purge_aad');
3294:
3295: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3296: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||SQL%ROWCOUNT,
3297: p_module => l_log_module,
3298: p_level => C_LEVEL_PROCEDURE);
3299: END IF;
3300: