APPS.OZF_OFFER_PVT dependencies on OZF_PROMOTIONAL_OFFERS_PVT

Line 561: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;

557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
559: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
560: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
561: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;
562:
563: BEGIN
564:
565: SAVEPOINT process_adv_options;

Line 663: OZF_Promotional_Offers_Pvt.UPDATE_OFFERS(

659: CLOSE c_cust_account_id;
660: END IF;
661: -- end comment
662:
663: OZF_Promotional_Offers_Pvt.UPDATE_OFFERS(
664: p_api_version_number => 1.0,
665: x_return_status => x_return_status,
666: x_msg_count => x_msg_count,
667: x_msg_data => x_msg_data,

Line 4657: l_promotional_offers_rec OZF_Promotional_Offers_Pvt.offers_rec_Type;

4653: SELECT status_code
4654: FROM ozf_offers
4655: WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id;
4656:
4657: l_promotional_offers_rec OZF_Promotional_Offers_Pvt.offers_rec_Type;
4658: l_object_version_number NUMBER;
4659: l_api_version CONSTANT NUMBER := 1.0;
4660: l_api_name CONSTANT VARCHAR2(30) := 'process_ozf_offer';
4661: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 4819: OZF_Promotional_Offers_Pvt.CREATE_OFFERS

4815: -- l_promotional_offers_rec.na_qual_attr_value := p_modifier_list_rec.na_qual_attr_value;
4816:
4817:
4818: IF p_modifier_list_rec.offer_operation = 'CREATE' THEN
4819: OZF_Promotional_Offers_Pvt.CREATE_OFFERS
4820: (
4821: p_api_version_number => 1.0,
4822: x_return_status => x_return_status,
4823: x_msg_count => x_msg_count,

Line 4830: OZF_Promotional_Offers_Pvt.UPDATE_OFFERS

4826: x_offer_id => x_offer_id
4827: );
4828: ELSIF p_modifier_list_rec.offer_operation = 'UPDATE' THEN
4829:
4830: OZF_Promotional_Offers_Pvt.UPDATE_OFFERS
4831: (
4832: p_api_version_number => 1.0,
4833: x_return_status => x_return_status,
4834: x_msg_count => x_msg_count,

Line 4841: OZF_Promotional_Offers_Pvt.DELETE_OFFERS

4837: x_object_version_number => l_object_version_number
4838: );
4839: x_offer_id := l_promotional_offers_rec.offer_id;
4840: ELSIF p_modifier_list_rec.offer_operation = 'DELETE' THEN
4841: OZF_Promotional_Offers_Pvt.DELETE_OFFERS
4842: (
4843: p_api_version_number => 1.0,
4844: x_return_status => x_return_status,
4845: x_msg_count => x_msg_count,