-
OZF_OFFER_PUB.process_modifiers
SET serveroutput on; DECLARE — v_return_status VARCHAR2(1); –v_msg_count NUMBER; — v_msg_data VARCHAR2(20000); l_user_id NUMBER; l_resp_id NUMBER; l_api_version constant number := 1.0; l_qp_list_header_id NUMBER := 0; l_validation_level NUMBER := fnd_api.g_valid_level_none; l_return_status varchar2(1); l_msg_count number; l_msg_data varchar2(2000); l_error_location NUMBER := 0; l_modifier_list_rec OZF_Offer_Pub.modifier_list_rec_type; l_modifier_line_tbl OZF_Offer_Pub.modifier_line_tbl_type; l_qualifier_tbl OZF_Offer_Pub.qualifiers_tbl_type; l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type; l_budget_tbl OZF_Offer_Pub.budget_tbl_type; l_act_product_tbl OZF_Offer_Pub.act_product_tbl_type; l_discount_tbl OZF_Offer_Pub.discount_line_tbl_type; l_excl_tbl OZF_Offer_Pub.excl_rec_tbl_type;…