APPS.OZF_ACT_OFFERS_PVT dependencies on OZF_ACT_OFFERS_S

Line 57: SELECT ozf_act_offers_s.NEXTVAL

53: WHERE object_type = 'OFFR'
54: AND activity_type_code = p_act_offer_rec.offer_type;
55: */
56: CURSOR c_act_offer_seq IS
57: SELECT ozf_act_offers_s.NEXTVAL
58: FROM DUAL;
59:
60: CURSOR c_act_offer_count(act_offer_id IN NUMBER) IS
61: SELECT COUNT(*)

Line 445: UPDATE ozf_act_offers SET

441: l_act_offer_rec.primary_offer_flag := 'N';
442: END IF;
443:
444: -- update
445: UPDATE ozf_act_offers SET
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: object_version_number = l_act_offer_rec.object_version_number + 1,
449: last_update_login = FND_GLOBAL.conc_login_id,