APPS.OZF_MO_PRESET_TIERS_PKG dependencies on OZF_MARKET_PRESET_TIERS

Line 48: INSERT INTO ozf_market_preset_tiers

44: )
45: IS
46: BEGIN
47: px_object_version_number := nvl(px_object_version_number,1);
48: INSERT INTO ozf_market_preset_tiers
49: (
50: market_preset_tier_id
51: , offer_market_option_id
52: , pbh_offer_discount_id

Line 100: UPDATE ozf_market_preset_tiers

96: , p_last_update_login NUMBER
97: )
98: IS
99: BEGIN
100: UPDATE ozf_market_preset_tiers
101: set market_preset_tier_id = DECODE(p_market_preset_tier_id, null, market_preset_tier_id, FND_API.G_MISS_NUM, null, p_market_preset_tier_id)
102: , offer_market_option_id = DECODE(p_offer_market_option_id , null, offer_market_option_id, FND_API.G_MISS_NUM, null, p_offer_market_option_id)
103: , pbh_offer_discount_id = DECODE(p_pbh_offer_discount_id, null, pbh_offer_discount_id, FND_API.G_MISS_NUM, null, p_pbh_offer_discount_id)
104: , dis_offer_discount_id =DECODE(p_dis_offer_discount_id, null, dis_offer_discount_id, FND_API.G_MISS_NUM, null, p_dis_offer_discount_id)

Line 136: DELETE FROM ozf_market_preset_tiers

132: p_market_preset_tier_id NUMBER,
133: p_object_version_number NUMBER)
134: IS
135: BEGIN
136: DELETE FROM ozf_market_preset_tiers
137: WHERE market_preset_tier_id = p_market_preset_tier_id
138: AND object_version_number = p_object_version_number;
139:
140: IF (SQL%NOTFOUND) THEN

Line 166: SELECT * FROM ozf_market_preset_tiers

162: p_market_preset_tier_id NUMBER,
163: p_object_version_number NUMBER)
164: IS
165: CURSOR C IS
166: SELECT * FROM ozf_market_preset_tiers
167: WHERE market_preset_tier_id = p_market_preset_tier_id
168: AND object_version_Number = p_object_version_number
169: FOR UPDATE OF market_preset_tier_id NOWAIT;
170: Recinfo c%ROWTYPE;