DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_HDR_ACCT_ATTRS

Line 459: DELETE FROM xla_aad_hdr_acct_attrs

455: p_module => l_log_module,
456: p_level => C_LEVEL_STATEMENT);
457: END IF;
458:
459: DELETE FROM xla_aad_hdr_acct_attrs
460: WHERE application_id = p_application_id
461: AND amb_context_code = p_amb_context_code;
462:
463: -- Bug : 16208537

Line 470: p_encoded_message => '# delete (xla_aad_hdr_acct_attrs) = '||SQL%ROWCOUNT,

466: p_amb_context_code => p_amb_context_code,
467: p_application_id => p_application_id,
468: p_request_code => 'IMPORT' ,
469: p_log_type_code => 'MERGE',
470: p_encoded_message => '# delete (xla_aad_hdr_acct_attrs) = '||SQL%ROWCOUNT,
471: p_component_code => 'purge');
472:
473: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
474: trace(p_msg => '# record deleted from xla_aad_hdr_acct_attrs = '||SQL%ROWCOUNT,

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

470: p_encoded_message => '# delete (xla_aad_hdr_acct_attrs) = '||SQL%ROWCOUNT,
471: p_component_code => 'purge');
472:
473: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
474: trace(p_msg => '# record deleted from xla_aad_hdr_acct_attrs = '||SQL%ROWCOUNT,
475: p_module => l_log_module,
476: p_level => C_LEVEL_STATEMENT);
477: END IF;
478:

Line 828: FROM xla_aad_hdr_acct_attrs

824: FOR UPDATE NOWAIT;
825:
826: CURSOR c_aad_hdr_acct_attrs IS
827: SELECT *
828: FROM xla_aad_hdr_acct_attrs
829: WHERE application_id = p_application_id
830: AND amb_context_code = p_amb_context_code
831: FOR UPDATE NOWAIT;
832:

Line 3181: DELETE FROM xla_aad_hdr_acct_attrs

3177: p_module => l_log_module,
3178: p_level => C_LEVEL_PROCEDURE);
3179: END IF;
3180:
3181: DELETE FROM xla_aad_hdr_acct_attrs
3182: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3183: AND application_id = p_application_id;
3184:
3185: -- Bug 16208537

Line 3192: p_encoded_message => '# delete (xla_aad_hdr_acct_attrs) = '||SQL%ROWCOUNT,

3188: p_amb_context_code => p_amb_context_code,
3189: p_application_id => p_application_id,
3190: p_request_code => 'IMPORT' ,
3191: p_log_type_code => 'MERGE',
3192: p_encoded_message => '# delete (xla_aad_hdr_acct_attrs) = '||SQL%ROWCOUNT,
3193: p_component_code => 'purge_aad');
3194:
3195: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3196: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||SQL%ROWCOUNT,

Line 3196: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||SQL%ROWCOUNT,

3192: p_encoded_message => '# delete (xla_aad_hdr_acct_attrs) = '||SQL%ROWCOUNT,
3193: p_component_code => 'purge_aad');
3194:
3195: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3196: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||SQL%ROWCOUNT,
3197: p_module => l_log_module,
3198: p_level => C_LEVEL_PROCEDURE);
3199: END IF;
3200: