APPS.OZF_PROMOTIONAL_OFFERS_PKG dependencies on OZF_OFFERS

Line 119: INSERT INTO OZF_OFFERS(

115:
116: px_object_version_number := 1;
117:
118:
119: INSERT INTO OZF_OFFERS(
120: offer_id,
121: qp_list_header_id,
122: offer_type,
123: offer_code,

Line 322: Update OZF_OFFERS

318:
319: IS
320: BEGIN
321:
322: Update OZF_OFFERS
323: SET
324: offer_id = DECODE( p_offer_id, FND_API.g_miss_num, offer_id, p_offer_id),
325: qp_list_header_id = DECODE( p_qp_list_header_id, FND_API.g_miss_num, qp_list_header_id, p_qp_list_header_id),
326: offer_type = DECODE( p_offer_type, FND_API.g_miss_char, offer_type, p_offer_type),

Line 413: DELETE FROM OZF_OFFERS

409: PROCEDURE Delete_Row(
410: p_OFFER_ID NUMBER)
411: IS
412: BEGIN
413: DELETE FROM OZF_OFFERS
414: WHERE OFFER_ID = p_OFFER_ID;
415: If (SQL%NOTFOUND) then
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: End If;

Line 499: FROM OZF_OFFERS

495:
496: IS
497: CURSOR C IS
498: SELECT *
499: FROM OZF_OFFERS
500: WHERE OFFER_ID = p_OFFER_ID
501: FOR UPDATE of OFFER_ID NOWAIT;
502: Recinfo C%ROWTYPE;
503: BEGIN