APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_HEADER_AC_ASSGNS

Line 359: DELETE FROM xla_aad_header_ac_assgns

355: p_module => l_log_module,
356: p_level => C_LEVEL_STATEMENT);
357: END IF;
358:
359: DELETE FROM xla_aad_header_ac_assgns
360: WHERE application_id = p_application_id
361: AND amb_context_code = p_amb_context_code;
362:
363: -- Bug : 16208537

Line 370: p_encoded_message => '# delete (xla_aad_header_ac_assgns) = '||SQL%ROWCOUNT,

366: p_amb_context_code => p_amb_context_code,
367: p_application_id => p_application_id,
368: p_request_code => 'IMPORT' ,
369: p_log_type_code => 'MERGE',
370: p_encoded_message => '# delete (xla_aad_header_ac_assgns) = '||SQL%ROWCOUNT,
371: p_component_code => 'purge');
372:
373: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
374: trace(p_msg => '# record deleted from xla_aad_header_ac_assgns = '||SQL%ROWCOUNT,

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

370: p_encoded_message => '# delete (xla_aad_header_ac_assgns) = '||SQL%ROWCOUNT,
371: p_component_code => 'purge');
372:
373: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
374: trace(p_msg => '# record deleted from xla_aad_header_ac_assgns = '||SQL%ROWCOUNT,
375: p_module => l_log_module,
376: p_level => C_LEVEL_STATEMENT);
377: END IF;
378:

Line 835: FROM xla_aad_header_ac_assgns

831: FOR UPDATE NOWAIT;
832:
833: CURSOR c_aad_header_ac_assgns IS
834: SELECT *
835: FROM xla_aad_header_ac_assgns
836: WHERE application_id = p_application_id
837: AND amb_context_code = p_amb_context_code
838: FOR UPDATE NOWAIT;
839:

Line 1026: FROM xla_aad_header_ac_assgns xah

1022: AND t.analytical_criterion_code = b.analytical_criterion_code
1023: AND t.amb_context_code = b.amb_context_code
1024: AND b.amb_context_code = p_amb_context_code
1025: AND EXISTS (SELECT 1
1026: FROM xla_aad_header_ac_assgns xah
1027: WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
1028: AND xah.analytical_criterion_code = b.analytical_criterion_code
1029: AND xah.amb_context_code = b.amb_context_code
1030: AND xah.application_id = p_application_id

Line 1067: FROM xla_aad_header_ac_assgns xah

1063: AND t.analytical_criterion_code = b.analytical_criterion_code
1064: AND t.amb_context_code = b.amb_context_code
1065: AND b.amb_context_code = p_amb_context_code
1066: AND EXISTS (SELECT 1
1067: FROM xla_aad_header_ac_assgns xah
1068: WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
1069: AND xah.analytical_criterion_code = b.analytical_criterion_code
1070: AND xah.amb_context_code = b.amb_context_code
1071: AND xah.application_id = p_application_id

Line 1104: FROM xla_aad_header_ac_assgns xah

1100: SELECT *
1101: FROM xla_analytical_sources b
1102: WHERE b.amb_context_code = p_amb_context_code
1103: AND EXISTS (SELECT 1
1104: FROM xla_aad_header_ac_assgns xah
1105: WHERE xah.analytical_criterion_type_code = b.analytical_criterion_type_code
1106: AND xah.analytical_criterion_code = b.analytical_criterion_code
1107: AND xah.amb_context_code = b.amb_context_code
1108: AND xah.application_id = p_application_id

Line 3201: DELETE FROM xla_aad_header_ac_assgns

3197: p_module => l_log_module,
3198: p_level => C_LEVEL_PROCEDURE);
3199: END IF;
3200:
3201: DELETE FROM xla_aad_header_ac_assgns
3202: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3203: AND application_id = p_application_id;
3204:
3205: -- Bug 16208537

Line 3212: p_encoded_message => '# delete (xla_aad_header_ac_assgns) = '||SQL%ROWCOUNT,

3208: p_amb_context_code => p_amb_context_code,
3209: p_application_id => p_application_id,
3210: p_request_code => 'IMPORT' ,
3211: p_log_type_code => 'MERGE',
3212: p_encoded_message => '# delete (xla_aad_header_ac_assgns) = '||SQL%ROWCOUNT,
3213: p_component_code => 'purge_aad');
3214:
3215: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3216: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,

Line 3216: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,

3212: p_encoded_message => '# delete (xla_aad_header_ac_assgns) = '||SQL%ROWCOUNT,
3213: p_component_code => 'purge_aad');
3214:
3215: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3216: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,
3217: p_module => l_log_module,
3218: p_level => C_LEVEL_PROCEDURE);
3219: END IF;
3220: