APPS.OZF_OFFER_PVT dependencies on OZF_ACT_OFFERS

Line 2074: l_act_offer_rec OZF_Act_Offers_Pvt.act_offer_rec_type;

2070: l_api_version CONSTANT NUMBER := 1.0;
2071: l_api_name CONSTANT VARCHAR2(30) := 'offer_object_usage';
2072: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2073:
2074: l_act_offer_rec OZF_Act_Offers_Pvt.act_offer_rec_type;
2075: l_activity_offer_id NUMBER := Fnd_Api.g_miss_num;
2076:
2077: BEGIN
2078:

Line 2089: OZF_Act_Offers_Pvt.Create_Act_Offer

2085: l_act_offer_rec.arc_act_offer_used_by := 'CAMP';
2086: l_act_offer_rec.qp_list_header_id := p_modifier_list_rec.qp_list_header_id;
2087: l_act_offer_rec.primary_offer_flag := 'N';
2088:
2089: OZF_Act_Offers_Pvt.Create_Act_Offer
2090: (
2091: p_api_version => 1.0,
2092: p_init_msg_list => FND_API.g_false,
2093: p_commit => Fnd_Api.g_false,

Line 3615: FROM ozf_act_offers

3611: IS
3612:
3613: CURSOR c_act_offer(l_qp_id NUMBER) IS
3614: SELECT act_offer_used_by_id
3615: FROM ozf_act_offers
3616: WHERE arc_act_offer_used_by = 'CSCH'
3617: AND qp_list_header_id = l_qp_id;
3618: l_act_offer_rec c_act_offer%ROWTYPE;
3619:

Line 8962: FROM ozf_act_offers

8958: p_count NUMBER := 0;
8959:
8960: CURSOR cur_budget_source_count(list_header_id NUMBER) IS
8961: SELECT count(1)
8962: FROM ozf_act_offers
8963: where qp_list_header_id = list_header_id;
8964:
8965: BEGIN
8966: OPEN cur_budget_source_count( p_list_header_id ) ;