APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_PROD_ACCT_HEADERS

Line 479: DELETE FROM xla_prod_acct_headers

475: p_module => l_log_module,
476: p_level => C_LEVEL_STATEMENT);
477: END IF;
478:
479: DELETE FROM xla_prod_acct_headers
480: WHERE application_id = p_application_id
481: AND amb_context_code = p_amb_context_code;
482:
483: -- Bug : 16208537

Line 490: p_encoded_message => '# delete (xla_prod_acct_headers) = '||SQL%ROWCOUNT,

486: p_amb_context_code => p_amb_context_code,
487: p_application_id => p_application_id,
488: p_request_code => 'IMPORT' ,
489: p_log_type_code => 'MERGE',
490: p_encoded_message => '# delete (xla_prod_acct_headers) = '||SQL%ROWCOUNT,
491: p_component_code => 'purge');
492:
493: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
494: trace(p_msg => '# record deleted from xla_prod_acct_headers = '||SQL%ROWCOUNT,

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

490: p_encoded_message => '# delete (xla_prod_acct_headers) = '||SQL%ROWCOUNT,
491: p_component_code => 'purge');
492:
493: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
494: trace(p_msg => '# record deleted from xla_prod_acct_headers = '||SQL%ROWCOUNT,
495: p_module => l_log_module,
496: p_level => C_LEVEL_STATEMENT);
497: END IF;
498:

Line 821: FROM xla_prod_acct_headers

817: FOR UPDATE NOWAIT;
818:
819: CURSOR c_prod_acct_headers IS
820: SELECT *
821: FROM xla_prod_acct_headers
822: WHERE application_id = p_application_id
823: AND amb_context_code = p_amb_context_code
824: FOR UPDATE NOWAIT;
825:

Line 3441: DELETE FROM xla_prod_acct_headers

3437: p_module => l_log_module,
3438: p_level => C_LEVEL_PROCEDURE);
3439: END IF;
3440:
3441: DELETE FROM xla_prod_acct_headers
3442: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3443: AND application_id = p_application_id;
3444:
3445: -- Bug 16208537

Line 3452: p_encoded_message => '# delete (xla_prod_acct_headers) = '||SQL%ROWCOUNT,

3448: p_amb_context_code => p_amb_context_code,
3449: p_application_id => p_application_id,
3450: p_request_code => 'IMPORT' ,
3451: p_log_type_code => 'MERGE',
3452: p_encoded_message => '# delete (xla_prod_acct_headers) = '||SQL%ROWCOUNT,
3453: p_component_code => 'purge_aad');
3454:
3455: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3456: trace(p_msg => '# xla_prod_acct_headers deleted = '||SQL%ROWCOUNT,

Line 3456: trace(p_msg => '# xla_prod_acct_headers deleted = '||SQL%ROWCOUNT,

3452: p_encoded_message => '# delete (xla_prod_acct_headers) = '||SQL%ROWCOUNT,
3453: p_component_code => 'purge_aad');
3454:
3455: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3456: trace(p_msg => '# xla_prod_acct_headers deleted = '||SQL%ROWCOUNT,
3457: p_module => l_log_module,
3458: p_level => C_LEVEL_PROCEDURE);
3459: END IF;
3460: