APPS.OZF_OFFER_PVT dependencies on OZF_PROMOTIONAL_OFFERS_PVT

Line 652: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;

648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
650: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
651: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
652: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;
653:
654: BEGIN
655:
656: SAVEPOINT process_adv_options;

Line 757: OZF_Promotional_Offers_Pvt.UPDATE_OFFERS(

753: CLOSE c_cust_account_id;
754: END IF;
755: -- end comment
756:
757: OZF_Promotional_Offers_Pvt.UPDATE_OFFERS(
758: p_api_version_number => 1.0,
759: x_return_status => x_return_status,
760: x_msg_count => x_msg_count,
761: x_msg_data => x_msg_data,

Line 5035: l_promotional_offers_rec OZF_Promotional_Offers_Pvt.offers_rec_Type;

5031: SELECT status_code
5032: FROM ozf_offers
5033: WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id;
5034:
5035: l_promotional_offers_rec OZF_Promotional_Offers_Pvt.offers_rec_Type;
5036: l_object_version_number NUMBER;
5037: l_api_version CONSTANT NUMBER := 1.0;
5038: l_api_name CONSTANT VARCHAR2(30) := 'process_ozf_offer';
5039: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 5197: OZF_Promotional_Offers_Pvt.CREATE_OFFERS

5193: -- l_promotional_offers_rec.na_qual_attr_value := p_modifier_list_rec.na_qual_attr_value;
5194:
5195:
5196: IF p_modifier_list_rec.offer_operation = 'CREATE' THEN
5197: OZF_Promotional_Offers_Pvt.CREATE_OFFERS
5198: (
5199: p_api_version_number => 1.0,
5200: x_return_status => x_return_status,
5201: x_msg_count => x_msg_count,

Line 5208: OZF_Promotional_Offers_Pvt.UPDATE_OFFERS

5204: x_offer_id => x_offer_id
5205: );
5206: ELSIF p_modifier_list_rec.offer_operation = 'UPDATE' THEN
5207:
5208: OZF_Promotional_Offers_Pvt.UPDATE_OFFERS
5209: (
5210: p_api_version_number => 1.0,
5211: x_return_status => x_return_status,
5212: x_msg_count => x_msg_count,

Line 5219: OZF_Promotional_Offers_Pvt.DELETE_OFFERS

5215: x_object_version_number => l_object_version_number
5216: );
5217: x_offer_id := l_promotional_offers_rec.offer_id;
5218: ELSIF p_modifier_list_rec.offer_operation = 'DELETE' THEN
5219: OZF_Promotional_Offers_Pvt.DELETE_OFFERS
5220: (
5221: p_api_version_number => 1.0,
5222: x_return_status => x_return_status,
5223: x_msg_count => x_msg_count,