APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFN_AC_ASSGNS

Line 239: DELETE FROM xla_line_defn_ac_assgns

235:
236: --
237: -- Delete application accounting definition assignments
238: --
239: DELETE FROM xla_line_defn_ac_assgns
240: WHERE application_id = p_application_id
241: AND amb_context_code = p_amb_context_code;
242:
243: -- Bug : 16208537

Line 250: p_encoded_message => '# delete (xla_line_defn_ac_assgns) = '||SQL%ROWCOUNT,

246: p_amb_context_code => p_amb_context_code,
247: p_application_id => p_application_id,
248: p_request_code => 'IMPORT' ,
249: p_log_type_code => 'MERGE',
250: p_encoded_message => '# delete (xla_line_defn_ac_assgns) = '||SQL%ROWCOUNT,
251: p_component_code => 'purge');
252:
253: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
254: trace(p_msg => '# record deleted from xla_line_defn_ac_assgns = '||SQL%ROWCOUNT,

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

250: p_encoded_message => '# delete (xla_line_defn_ac_assgns) = '||SQL%ROWCOUNT,
251: p_component_code => 'purge');
252:
253: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
254: trace(p_msg => '# record deleted from xla_line_defn_ac_assgns = '||SQL%ROWCOUNT,
255: p_module => l_log_module,
256: p_level => C_LEVEL_STATEMENT);
257: END IF;
258:

Line 905: FROM xla_line_defn_ac_assgns

901: FOR UPDATE NOWAIT;
902:
903: CURSOR c_line_defn_ac_assgns IS
904: SELECT *
905: FROM xla_line_defn_ac_assgns
906: WHERE application_id = p_application_id
907: AND amb_context_code = p_amb_context_code
908: FOR UPDATE NOWAIT;
909:

Line 1034: FROM xla_line_defn_ac_assgns xld

1030: AND xah.application_id = p_application_id
1031: AND xah.amb_context_code = p_amb_context_code
1032: UNION
1033: SELECT 1
1034: FROM xla_line_defn_ac_assgns xld
1035: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1036: AND xld.analytical_criterion_code = b.analytical_criterion_code
1037: AND xld.amb_context_code = b.amb_context_code
1038: AND xld.application_id = p_application_id

Line 1075: FROM xla_line_defn_ac_assgns xld

1071: AND xah.application_id = p_application_id
1072: AND xah.amb_context_code = p_amb_context_code
1073: UNION
1074: SELECT 1
1075: FROM xla_line_defn_ac_assgns xld
1076: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1077: AND xld.analytical_criterion_code = b.analytical_criterion_code
1078: AND xld.amb_context_code = b.amb_context_code
1079: AND xld.application_id = p_application_id

Line 1112: FROM xla_line_defn_ac_assgns xld

1108: AND xah.application_id = p_application_id
1109: AND xah.amb_context_code = p_amb_context_code
1110: UNION
1111: SELECT 1
1112: FROM xla_line_defn_ac_assgns xld
1113: WHERE xld.analytical_criterion_type_code = b.analytical_criterion_type_code
1114: AND xld.analytical_criterion_code = b.analytical_criterion_code
1115: AND xld.amb_context_code = b.amb_context_code
1116: AND xld.application_id = p_application_id

Line 3341: DELETE FROM xla_line_defn_ac_assgns

3337: p_module => l_log_module,
3338: p_level => C_LEVEL_PROCEDURE);
3339: END IF;
3340:
3341: DELETE FROM xla_line_defn_ac_assgns
3342: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3343: AND application_id = p_application_id;
3344:
3345: -- Bug 16208537

Line 3352: p_encoded_message => '# delete (xla_line_defn_ac_assgns) = '||SQL%ROWCOUNT,

3348: p_amb_context_code => p_amb_context_code,
3349: p_application_id => p_application_id,
3350: p_request_code => 'IMPORT' ,
3351: p_log_type_code => 'MERGE',
3352: p_encoded_message => '# delete (xla_line_defn_ac_assgns) = '||SQL%ROWCOUNT,
3353: p_component_code => 'purge_aad');
3354:
3355: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3356: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||SQL%ROWCOUNT,

Line 3356: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||SQL%ROWCOUNT,

3352: p_encoded_message => '# delete (xla_line_defn_ac_assgns) = '||SQL%ROWCOUNT,
3353: p_component_code => 'purge_aad');
3354:
3355: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3356: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||SQL%ROWCOUNT,
3357: p_module => l_log_module,
3358: p_level => C_LEVEL_PROCEDURE);
3359: END IF;
3360: