APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_PRODUCT_RULES_B

Line 522: DELETE FROM xla_product_rules_b

518: p_module => l_log_module,
519: p_level => C_LEVEL_STATEMENT);
520: END IF;
521:
522: DELETE FROM xla_product_rules_b
523: WHERE application_id = p_application_id
524: AND amb_context_code = p_amb_context_code;
525:
526: -- Bug : 16208537

Line 533: p_encoded_message => '# delete (xla_product_rules_b) = '||SQL%ROWCOUNT,

529: p_amb_context_code => p_amb_context_code,
530: p_application_id => p_application_id,
531: p_request_code => 'IMPORT' ,
532: p_log_type_code => 'MERGE',
533: p_encoded_message => '# delete (xla_product_rules_b) = '||SQL%ROWCOUNT,
534: p_component_code => 'purge');
535:
536: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
537: trace(p_msg => '# record deleted from xla_product_rules_b = '||SQL%ROWCOUNT,

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

533: p_encoded_message => '# delete (xla_product_rules_b) = '||SQL%ROWCOUNT,
534: p_component_code => 'purge');
535:
536: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
537: trace(p_msg => '# record deleted from xla_product_rules_b = '||SQL%ROWCOUNT,
538: p_module => l_log_module,
539: p_level => C_LEVEL_STATEMENT);
540: END IF;
541:

Line 807: FROM xla_product_rules_b

803: RETURN VARCHAR2
804: IS
805: CURSOR c_product_rules_b IS
806: SELECT *
807: FROM xla_product_rules_b
808: WHERE application_id = p_application_id
809: AND amb_context_code = p_amb_context_code
810: FOR UPDATE NOWAIT;
811:

Line 3481: DELETE FROM xla_product_rules_b

3477: p_module => l_log_module,
3478: p_level => C_LEVEL_PROCEDURE);
3479: END IF;
3480:
3481: DELETE FROM xla_product_rules_b
3482: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
3483: AND application_id = p_application_id;
3484:
3485: -- Bug 16208537

Line 3492: p_encoded_message => '# delete (xla_product_rules_b) = '||SQL%ROWCOUNT,

3488: p_amb_context_code => p_amb_context_code,
3489: p_application_id => p_application_id,
3490: p_request_code => 'IMPORT' ,
3491: p_log_type_code => 'MERGE',
3492: p_encoded_message => '# delete (xla_product_rules_b) = '||SQL%ROWCOUNT,
3493: p_component_code => 'purge_aad');
3494:
3495:
3496: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 3497: trace(p_msg => '# xla_product_rules_b deleted = '||SQL%ROWCOUNT,

3493: p_component_code => 'purge_aad');
3494:
3495:
3496: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3497: trace(p_msg => '# xla_product_rules_b deleted = '||SQL%ROWCOUNT,
3498: p_module => l_log_module,
3499: p_level => C_LEVEL_PROCEDURE);
3500: END IF;
3501:

Line 4125: UPDATE xla_product_rules_b

4121:
4122: DELETE FROM xla_amb_components_h
4123: WHERE application_id = p_application_id;
4124:
4125: UPDATE xla_product_rules_b
4126: SET version_num = 0
4127: , updated_flag = 'Y'
4128: WHERE application_id = p_application_id;
4129: