DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on OZF_ACT_OFFERS

Line 1963: l_act_offer_rec OZF_Act_Offers_Pvt.act_offer_rec_type;

1959: l_api_version CONSTANT NUMBER := 1.0;
1960: l_api_name CONSTANT VARCHAR2(30) := 'offer_object_usage';
1961: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1962:
1963: l_act_offer_rec OZF_Act_Offers_Pvt.act_offer_rec_type;
1964: l_activity_offer_id NUMBER := Fnd_Api.g_miss_num;
1965:
1966: BEGIN
1967:

Line 1978: OZF_Act_Offers_Pvt.Create_Act_Offer

1974: l_act_offer_rec.arc_act_offer_used_by := 'CAMP';
1975: l_act_offer_rec.qp_list_header_id := p_modifier_list_rec.qp_list_header_id;
1976: l_act_offer_rec.primary_offer_flag := 'N';
1977:
1978: OZF_Act_Offers_Pvt.Create_Act_Offer
1979: (
1980: p_api_version => 1.0,
1981: p_init_msg_list => FND_API.g_false,
1982: p_commit => Fnd_Api.g_false,

Line 3450: FROM ozf_act_offers

3446: IS
3447:
3448: CURSOR c_act_offer(l_qp_id NUMBER) IS
3449: SELECT act_offer_used_by_id
3450: FROM ozf_act_offers
3451: WHERE arc_act_offer_used_by = 'CSCH'
3452: AND qp_list_header_id = l_qp_id;
3453: l_act_offer_rec c_act_offer%ROWTYPE;
3454:

Line 8428: FROM ozf_act_offers

8424: p_count NUMBER := 0;
8425:
8426: CURSOR cur_budget_source_count(list_header_id NUMBER) IS
8427: SELECT count(1)
8428: FROM ozf_act_offers
8429: where qp_list_header_id = list_header_id;
8430:
8431: BEGIN
8432: OPEN cur_budget_source_count( p_list_header_id ) ;