DBA Data[Home] [Help]

APPS.XLA_PRODUCT_RULES_PKG dependencies on XLA_AAD_HEADER_AC_ASSGNS

Line 545: FROM xla_aad_header_ac_assgns

541: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
542: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
543:
544: DELETE
545: FROM xla_aad_header_ac_assgns
546: WHERE application_id = p_application_id
547: AND amb_context_code = p_amb_context_code
548: AND product_rule_type_code = p_product_rule_type_code
549: AND product_rule_code = p_product_rule_code;

Line 611: FROM xla_aad_header_ac_assgns

607: xla_utility_pkg.trace('product_rule_type_code = '||p_product_rule_type_code , 20);
608: xla_utility_pkg.trace('product_rule_code = '||p_product_rule_code , 20);
609:
610: DELETE
611: FROM xla_aad_header_ac_assgns
612: WHERE application_id = p_application_id
613: AND amb_context_code = p_amb_context_code
614: AND product_rule_type_code = p_product_rule_type_code
615: AND product_rule_code = p_product_rule_code

Line 734: INSERT INTO xla_aad_header_ac_assgns

730: AND product_rule_type_code = p_old_product_rule_type_code
731: AND product_rule_code = p_old_product_rule_code;
732:
733: IF (p_include_header_assignments = 'Y') THEN
734: INSERT INTO xla_aad_header_ac_assgns
735: (application_id
736: ,amb_context_code
737: ,product_rule_type_code
738: ,product_rule_code

Line 763: FROM xla_aad_header_ac_assgns

759: ,l_created_by
760: ,l_last_update_date
761: ,l_last_updated_by
762: ,l_last_update_login
763: FROM xla_aad_header_ac_assgns
764: WHERE application_id = p_application_id
765: AND amb_context_code = p_amb_context_code
766: AND product_rule_type_code = p_old_product_rule_type_code
767: AND product_rule_code = p_old_product_rule_code;