APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 279: DELETE FROM xla_line_defn_jlt_assgns

275: p_module => l_log_module,
276: p_level => C_LEVEL_STATEMENT);
277: END IF;
278:
279: DELETE FROM xla_line_defn_jlt_assgns
280: WHERE application_id = p_application_id
281: AND amb_context_code = p_amb_context_code;
282:
283: -- Bug : 16208537

Line 290: p_encoded_message => '# delete (xla_line_defn_jlt_assgns) = '||SQL%ROWCOUNT,

286: p_amb_context_code => p_amb_context_code,
287: p_application_id => p_application_id,
288: p_request_code => 'IMPORT' ,
289: p_log_type_code => 'MERGE',
290: p_encoded_message => '# delete (xla_line_defn_jlt_assgns) = '||SQL%ROWCOUNT,
291: p_component_code => 'purge');
292:
293: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
294: trace(p_msg => '# record deleted from xla_line_defn_jlt_assgns = '||SQL%ROWCOUNT,

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

290: p_encoded_message => '# delete (xla_line_defn_jlt_assgns) = '||SQL%ROWCOUNT,
291: p_component_code => 'purge');
292:
293: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
294: trace(p_msg => '# record deleted from xla_line_defn_jlt_assgns = '||SQL%ROWCOUNT,
295: p_module => l_log_module,
296: p_level => C_LEVEL_STATEMENT);
297: END IF;
298:

Line 891: FROM xla_line_defn_jlt_assgns

887: FOR UPDATE NOWAIT;
888:
889: CURSOR c_line_defn_jlt_assgns IS
890: SELECT *
891: FROM xla_line_defn_jlt_assgns
892: WHERE application_id = p_application_id
893: AND amb_context_code = p_amb_context_code
894: FOR UPDATE NOWAIT;
895:

Line 3381: DELETE FROM xla_line_defn_jlt_assgns

3377: p_module => l_log_module,
3378: p_level => C_LEVEL_PROCEDURE);
3379: END IF;
3380:
3381: DELETE FROM xla_line_defn_jlt_assgns
3382: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3383: AND application_id = p_application_id;
3384:
3385: -- Bug 16208537

Line 3392: p_encoded_message => '# delete (xla_line_defn_jlt_assgns) = '||SQL%ROWCOUNT,

3388: p_amb_context_code => p_amb_context_code,
3389: p_application_id => p_application_id,
3390: p_request_code => 'IMPORT' ,
3391: p_log_type_code => 'MERGE',
3392: p_encoded_message => '# delete (xla_line_defn_jlt_assgns) = '||SQL%ROWCOUNT,
3393: p_component_code => 'purge_aad');
3394:
3395: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3396: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,

Line 3396: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,

3392: p_encoded_message => '# delete (xla_line_defn_jlt_assgns) = '||SQL%ROWCOUNT,
3393: p_component_code => 'purge_aad');
3394:
3395: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3396: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,
3397: p_module => l_log_module,
3398: p_level => C_LEVEL_PROCEDURE);
3399: END IF;
3400: