APPS.OZF_OFFER_ADJUSTMENT_PKG dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 82: INSERT INTO ozf_offer_adjustments_b(

78:
79: px_object_version_number := nvl(px_object_version_number, 1);
80:
81:
82: INSERT INTO ozf_offer_adjustments_b(
83: offer_adjustment_id,
84: effective_date,
85: approved_date,
86: settlement_code,

Line 222: Update ozf_offer_adjustments_b

218: )
219:
220: IS
221: BEGIN
222: Update ozf_offer_adjustments_b
223: SET
224: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
225: effective_date = DECODE( p_effective_date, to_date(NULL), effective_date, FND_API.G_MISS_DATE, to_date(NULL), p_effective_date),
226: approved_date = DECODE( p_approved_date, to_date(NULL), approved_date, FND_API.G_MISS_DATE, to_date(NULL), p_approved_date),

Line 299: DELETE FROM ozf_offer_adjustments_b

295: If (SQL%NOTFOUND) then
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
297: End If;
298:
299: DELETE FROM ozf_offer_adjustments_b
300: WHERE offer_adjustment_id = p_offer_adjustment_id
301: AND object_version_number = p_object_version_number;
302: If (SQL%NOTFOUND) then
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 329: FROM ozf_offer_adjustments_b

325: p_object_version_number NUMBER)
326: IS
327: CURSOR C IS
328: SELECT *
329: FROM ozf_offer_adjustments_b
330: WHERE offer_adjustment_id = p_offer_adjustment_id
331: AND object_version_number = p_object_version_number
332: FOR UPDATE OF offer_adjustment_id NOWAIT;
333: Recinfo C%ROWTYPE;

Line 368: from ozf_offer_adjustments_b b

364: BEGIN
365: delete from ozf_offer_adjustments_tl T
366: where not exists
367: (select NULL
368: from ozf_offer_adjustments_b b
369: where b.offer_adjustment_id = t.offer_adjustment_id
370: );
371:
372: update ozf_offer_adjustments_tl t set (