APPS.OZF_OFFR_QUAL_PKG dependencies on OZF_OFFER_QUALIFIERS

Line 81: INSERT INTO ozf_offer_qualifiers(

77:
78:
79: px_object_version_number := nvl(px_object_version_number, 1);
80:
81: INSERT INTO ozf_offer_qualifiers(
82: qualifier_id,
83: creation_date,
84: created_by,
85: last_update_date,

Line 200: Update ozf_offer_qualifiers

196: p_object_version_number NUMBER)
197:
198: IS
199: BEGIN
200: Update ozf_offer_qualifiers
201: SET
202: qualifier_id = DECODE( p_qualifier_id, null, qualifier_id, FND_API.G_MISS_NUM, null, p_qualifier_id),
203: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
204: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 264: DELETE FROM ozf_offer_qualifiers

260: p_qualifier_id NUMBER,
261: p_object_version_number NUMBER)
262: IS
263: BEGIN
264: DELETE FROM ozf_offer_qualifiers
265: WHERE qualifier_id = p_qualifier_id
266: AND object_version_number = p_object_version_number;
267: If (SQL%NOTFOUND) then
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 294: FROM ozf_offer_qualifiers

290: p_object_version_number NUMBER)
291: IS
292: CURSOR C IS
293: SELECT *
294: FROM ozf_offer_qualifiers
295: WHERE qualifier_id = p_qualifier_id
296: AND object_version_number = p_object_version_number
297: FOR UPDATE OF qualifier_id NOWAIT;
298: Recinfo C%ROWTYPE;