498:
499: --
500: -- Delete application accounting definitions
501: --
502: DELETE FROM xla_product_rules_tl
503: WHERE application_id = p_application_id
504: AND amb_context_code = p_amb_context_code;
505:
506: -- Bug : 16208537
509: p_amb_context_code => p_amb_context_code,
510: p_application_id => p_application_id,
511: p_request_code => 'IMPORT' ,
512: p_log_type_code => 'MERGE',
513: p_encoded_message => '# delete (xla_product_rules_tl) = '||SQL%ROWCOUNT,
514: p_component_code => 'purge');
515:
516: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
517: trace(p_msg => '# record deleted from xla_product_rules_tl = '||SQL%ROWCOUNT,
513: p_encoded_message => '# delete (xla_product_rules_tl) = '||SQL%ROWCOUNT,
514: p_component_code => 'purge');
515:
516: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
517: trace(p_msg => '# record deleted from xla_product_rules_tl = '||SQL%ROWCOUNT,
518: p_module => l_log_module,
519: p_level => C_LEVEL_STATEMENT);
520: END IF;
521:
810: FOR UPDATE NOWAIT;
811:
812: CURSOR c_product_rules_tl IS
813: SELECT *
814: FROM xla_product_rules_tl
815: WHERE application_id = p_application_id
816: AND amb_context_code = p_amb_context_code
817: FOR UPDATE NOWAIT;
818:
3457: p_module => l_log_module,
3458: p_level => C_LEVEL_PROCEDURE);
3459: END IF;
3460:
3461: DELETE FROM xla_product_rules_tl
3462: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3463: AND application_id = p_application_id;
3464:
3465: -- Bug 16208537
3468: p_amb_context_code => p_amb_context_code,
3469: p_application_id => p_application_id,
3470: p_request_code => 'IMPORT' ,
3471: p_log_type_code => 'MERGE',
3472: p_encoded_message => '# delete (xla_product_rules_tl) = '||SQL%ROWCOUNT,
3473: p_component_code => 'purge_aad');
3474:
3475: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3476: trace(p_msg => '# xla_product_rules_tl deleted = '||SQL%ROWCOUNT,
3472: p_encoded_message => '# delete (xla_product_rules_tl) = '||SQL%ROWCOUNT,
3473: p_component_code => 'purge_aad');
3474:
3475: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3476: trace(p_msg => '# xla_product_rules_tl deleted = '||SQL%ROWCOUNT,
3477: p_module => l_log_module,
3478: p_level => C_LEVEL_PROCEDURE);
3479: END IF;
3480: