[Home] [Help]
82: CURSOR c_mo_uk (p_offer_id NUMBER, p_group_number NUMBER) IS
83: SELECT 1 FROM dual
84: WHERE EXISTS
85: (SELECT 'X'
86: FROM ozf_offr_market_options
87: WHERE offer_id = p_offer_id --p_mo_rec.offer_id
88: AND group_number = p_group_number); --p_mo_rec.group_number);
89:
90: BEGIN
92: OZF_Volume_Offer_disc_PVT.debug_message('Market optionId is : '|| p_mo_rec.offer_market_option_id);
93: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
94: IF p_mo_rec.offer_market_option_id IS NOT NULL AND p_mo_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
95: OZF_Volume_Offer_disc_PVT.debug_message('Checking qunqieness for moid');
96: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_market_options','offer_market_option_id = ''' || p_mo_rec.offer_market_option_id ||'''') = FND_API.g_false THEN
97: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFF_MO_ID_DUP');
98: x_return_status := FND_API.g_ret_sts_error;
99: END IF;
100: END IF;
621: l_market_option_id NUMBER;
622: l_object_version_number NUMBER;
623: l_dummy NUMBER;
624: CURSOR c_id IS
625: SELECT ozf_offr_market_options_s.NEXTVAL
626: FROM dual;
627: CURSOR c_id_exists (l_id IN NUMBER) IS
628: SELECT 1
629: FROM ozf_offr_market_options
625: SELECT ozf_offr_market_options_s.NEXTVAL
626: FROM dual;
627: CURSOR c_id_exists (l_id IN NUMBER) IS
628: SELECT 1
629: FROM ozf_offr_market_options
630: WHERE offer_market_option_id = l_id;
631:
632: BEGIN
633: -- initialize
830: )
831: IS
832: CURSOR c_get_mo(p_market_option_id NUMBER, p_object_version_number NUMBER) IS
833: SELECT *
834: FROM ozf_offr_market_options
835: WHERE offer_market_option_id = p_market_option_id
836: AND object_version_number = p_object_version_number;
837: -- Hint: Developer need to provide Where clause
838: