APPS.OZF_PROMOTIONAL_OFFERS_PKG dependencies on OZF_OFFERS

Line 116: INSERT INTO OZF_OFFERS(

112:
113: px_object_version_number := 1;
114:
115:
116: INSERT INTO OZF_OFFERS(
117: offer_id,
118: qp_list_header_id,
119: offer_type,
120: offer_code,

Line 315: Update OZF_OFFERS

311:
312: IS
313: BEGIN
314:
315: Update OZF_OFFERS
316: SET
317: offer_id = DECODE( p_offer_id, FND_API.g_miss_num, offer_id, p_offer_id),
318: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),
319: offer_type = DECODE( p_offer_type, FND_API.g_miss_char, offer_type, p_offer_type),

Line 403: DELETE FROM OZF_OFFERS

399: PROCEDURE Delete_Row(
400: p_OFFER_ID NUMBER)
401: IS
402: BEGIN
403: DELETE FROM OZF_OFFERS
404: WHERE OFFER_ID = p_OFFER_ID;
405: If (SQL%NOTFOUND) then
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: End If;

Line 488: FROM OZF_OFFERS

484:
485: IS
486: CURSOR C IS
487: SELECT *
488: FROM OZF_OFFERS
489: WHERE OFFER_ID = p_OFFER_ID
490: FOR UPDATE of OFFER_ID NOWAIT;
491: Recinfo C%ROWTYPE;
492: BEGIN