APPS.OZF_OFFER_ADJ_TIER_PKG dependencies on OZF_OFFER_ADJUSTMENT_TIERS

Line 64: INSERT INTO ozf_offer_adjustment_tiers(

60:
61: px_object_version_number := nvl(px_object_version_number, 1);
62:
63:
64: INSERT INTO ozf_offer_adjustment_tiers(
65: offer_adjst_tier_id,
66: offer_adjustment_id,
67: volume_offer_tiers_id,
68: qp_list_header_id,

Line 128: Update ozf_offer_adjustment_tiers

124: px_object_version_number IN OUT NOCOPY NUMBER)
125:
126: IS
127: BEGIN
128: Update ozf_offer_adjustment_tiers
129: SET
130: offer_adjst_tier_id = DECODE( p_offer_adjst_tier_id, null, offer_adjst_tier_id, FND_API.G_MISS_NUM, null, p_offer_adjst_tier_id),
131: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
132: volume_offer_tiers_id = DECODE( p_volume_offer_tiers_id, null, volume_offer_tiers_id, FND_API.G_MISS_NUM, null, p_volume_offer_tiers_id),

Line 174: DELETE FROM ozf_offer_adjustment_tiers

170: p_offer_adjst_tier_id NUMBER,
171: p_object_version_number NUMBER)
172: IS
173: BEGIN
174: DELETE FROM ozf_offer_adjustment_tiers
175: WHERE offer_adjst_tier_id = p_offer_adjst_tier_id
176: AND object_version_number = p_object_version_number;
177: If (SQL%NOTFOUND) then
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 204: FROM ozf_offer_adjustment_tiers

200: p_object_version_number NUMBER)
201: IS
202: CURSOR C IS
203: SELECT *
204: FROM ozf_offer_adjustment_tiers
205: WHERE offer_adjst_tier_id = p_offer_adjst_tier_id
206: AND object_version_number = p_object_version_number
207: FOR UPDATE OF offer_adjst_tier_id NOWAIT;
208: Recinfo C%ROWTYPE;