APPS.OZF_MO_PRESET_TIERS_PVT dependencies on OZF_MARKET_PRESET_TIERS

Line 88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN

84: BEGIN
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN
88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN
89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;
92: END IF;

Line 114: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'

110: (
111: p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM
112: )
113: THEN
114: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
115: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id
116: ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id
117: || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id
118: || ' AND market_preset_tier_id <> ' ||p_preset_tier_rec.market_preset_tier_id

Line 141: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'

137: (
138: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM
139: )
140: THEN
141: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
142: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id ) = FND_API.G_FALSE
143: THEN
144: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');
145: x_return_status := FND_API.g_ret_sts_error;

Line 368: SELECT ozf_market_preset_tiers_s.nextval

364: l_object_version_number NUMBER;
365:
366: l_preset_tier_rec mo_preset_rec_type;
367: CURSOR c_id IS
368: SELECT ozf_market_preset_tiers_s.nextval
369: FROM DUAL;
370:
371: CURSOR c_id_exists(l_market_preset_tier_id NUMBER)
372: is

Line 373: SELECT 1 FROM dual WHERE exists(SELECT 'X' FROM ozf_market_preset_tiers WHERE market_preset_tier_id = l_market_preset_tier_id);

369: FROM DUAL;
370:
371: CURSOR c_id_exists(l_market_preset_tier_id NUMBER)
372: is
373: SELECT 1 FROM dual WHERE exists(SELECT 'X' FROM ozf_market_preset_tiers WHERE market_preset_tier_id = l_market_preset_tier_id);
374: BEGIN
375: -- initialize
376: -- savepoint
377: SAVEPOINT Create_mo_preset_tiers;

Line 518: SELECT * FROM ozf_market_preset_tiers

514: l_tar_preset_rec mo_preset_rec_type := p_preset_tier_rec;
515:
516: CURSOR c_get_preset_tiers(p_market_preset_tier_id NUMBER, p_object_version_number NUMBER)
517: IS
518: SELECT * FROM ozf_market_preset_tiers
519: WHERE market_preset_tier_id = p_market_preset_tier_id
520: AND object_version_number = p_object_version_number;
521: l_ref_preset_tiers c_get_preset_tiers%ROWTYPE;
522: