APPS.OZF_VOL_OFFR_PKG dependencies on OZF_VOLUME_OFFER_TIERS

Line 56: INSERT INTO ozf_volume_offer_tiers(

52: BEGIN
53: px_object_version_number := nvl(px_object_version_number, 1);
54:
55:
56: INSERT INTO ozf_volume_offer_tiers(
57: volume_offer_tiers_id,
58: qp_list_header_id,
59: discount_type_code,
60: discount,

Line 117: Update ozf_volume_offer_tiers

113: OZF_UTILITY_PVT.debug_message('before inserting');
114: OZF_UTILITY_PVT.debug_message('id: ' || p_volume_offer_tiers_id);
115: OZF_UTILITY_PVT.debug_message('ver: ' || px_object_version_number);
116:
117: Update ozf_volume_offer_tiers
118: SET
119: 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),
120: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.G_MISS_NUM, null, p_qp_list_header_id),
121: discount_type_code = DECODE( p_discount_type_code, null, discount_type_code, FND_API.g_miss_char, null, p_discount_type_code),

Line 163: DELETE FROM ozf_volume_offer_tiers

159: p_volume_offer_tiers_id NUMBER,
160: p_object_version_number NUMBER)
161: IS
162: BEGIN
163: DELETE FROM ozf_volume_offer_tiers
164: WHERE volume_offer_tiers_id = p_volume_offer_tiers_id
165: AND object_version_number = p_object_version_number;
166: If (SQL%NOTFOUND) then
167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 193: FROM ozf_volume_offer_tiers

189: p_object_version_number NUMBER)
190: IS
191: CURSOR C IS
192: SELECT *
193: FROM ozf_volume_offer_tiers
194: WHERE volume_offer_tiers_id = p_volume_offer_tiers_id
195: AND object_version_number = p_object_version_number
196: FOR UPDATE OF volume_offer_tiers_id NOWAIT;
197: Recinfo C%ROWTYPE;