APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_MPA_HEADER_AC_ASSGNS

Line 379: DELETE FROM xla_mpa_header_ac_assgns

375: p_module => l_log_module,
376: p_level => C_LEVEL_STATEMENT);
377: END IF;
378:
379: DELETE FROM xla_mpa_header_ac_assgns
380: WHERE application_id = p_application_id
381: AND amb_context_code = p_amb_context_code;
382:
383: -- Bug : 16208537

Line 390: p_encoded_message => '# delete (xla_mpa_header_ac_assgns) = '||SQL%ROWCOUNT,

386: p_amb_context_code => p_amb_context_code,
387: p_application_id => p_application_id,
388: p_request_code => 'IMPORT' ,
389: p_log_type_code => 'MERGE',
390: p_encoded_message => '# delete (xla_mpa_header_ac_assgns) = '||SQL%ROWCOUNT,
391: p_component_code => 'purge');
392:
393: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
394: trace(p_msg => '# record deleted from xla_mpa_header_ac_assgns = '||SQL%ROWCOUNT,

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

390: p_encoded_message => '# delete (xla_mpa_header_ac_assgns) = '||SQL%ROWCOUNT,
391: p_component_code => 'purge');
392:
393: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
394: trace(p_msg => '# record deleted from xla_mpa_header_ac_assgns = '||SQL%ROWCOUNT,
395: p_module => l_log_module,
396: p_level => C_LEVEL_STATEMENT);
397: END IF;
398:

Line 842: FROM xla_mpa_header_ac_assgns

838: FOR UPDATE NOWAIT;
839:
840: CURSOR c_mpa_header_ac_assgns IS
841: SELECT *
842: FROM xla_mpa_header_ac_assgns
843: WHERE application_id = p_application_id
844: AND amb_context_code = p_amb_context_code
845: FOR UPDATE NOWAIT;
846:

Line 1042: FROM xla_mpa_header_ac_assgns xld

1038: AND xld.application_id = p_application_id
1039: AND xld.amb_context_code = p_amb_context_code
1040: UNION
1041: SELECT 1
1042: FROM xla_mpa_header_ac_assgns xld
1043: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1044: AND xld.analytical_criterion_code = b.analytical_criterion_code
1045: AND xld.amb_context_code = b.amb_context_code
1046: AND xld.application_id = p_application_id

Line 1083: FROM xla_mpa_header_ac_assgns xld

1079: AND xld.application_id = p_application_id
1080: AND xld.amb_context_code = p_amb_context_code
1081: UNION
1082: SELECT 1
1083: FROM xla_mpa_header_ac_assgns xld
1084: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1085: AND xld.analytical_criterion_code = b.analytical_criterion_code
1086: AND xld.amb_context_code = b.amb_context_code
1087: AND xld.application_id = p_application_id

Line 1120: FROM xla_mpa_header_ac_assgns xld

1116: AND xld.application_id = p_application_id
1117: AND xld.amb_context_code = p_amb_context_code
1118: UNION
1119: SELECT 1
1120: FROM xla_mpa_header_ac_assgns xld
1121: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1122: AND xld.analytical_criterion_code = b.analytical_criterion_code
1123: AND xld.amb_context_code = b.amb_context_code
1124: AND xld.application_id = p_application_id

Line 3221: DELETE FROM xla_mpa_header_ac_assgns

3217: p_module => l_log_module,
3218: p_level => C_LEVEL_PROCEDURE);
3219: END IF;
3220:
3221: DELETE FROM xla_mpa_header_ac_assgns
3222: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3223: AND application_id = p_application_id;
3224:
3225: -- Bug 16208537

Line 3232: p_encoded_message => '# delete (xla_mpa_header_ac_assgns) = '||SQL%ROWCOUNT,

3228: p_amb_context_code => p_amb_context_code,
3229: p_application_id => p_application_id,
3230: p_request_code => 'IMPORT' ,
3231: p_log_type_code => 'MERGE',
3232: p_encoded_message => '# delete (xla_mpa_header_ac_assgns) = '||SQL%ROWCOUNT,
3233: p_component_code => 'purge_aad');
3234:
3235: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3236: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,

Line 3236: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,

3232: p_encoded_message => '# delete (xla_mpa_header_ac_assgns) = '||SQL%ROWCOUNT,
3233: p_component_code => 'purge_aad');
3234:
3235: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3236: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,
3237: p_module => l_log_module,
3238: p_level => C_LEVEL_PROCEDURE);
3239: END IF;
3240: