APPS.OZF_OFFER_ADJUSTMENTS_PKG dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 10: -- 11-DEC-2002 julou change ams_offer_adjustments to ozf_offer_adjustments_b

6: -- OZF_OFFER_ADJUSTMENTS_PKG
7: -- Purpose
8: --
9: -- History
10: -- 11-DEC-2002 julou change ams_offer_adjustments to ozf_offer_adjustments_b
11: -- NOTE
12: --
13: -- End of Comments
14: -- ===============================================================

Line 65: INSERT INTO ozf_OFFER_ADJUSTMENTS_B(

61:
62: px_object_version_number := 1;
63:
64:
65: INSERT INTO ozf_OFFER_ADJUSTMENTS_B(
66: offer_adjustment_id,
67: effective_date,
68: approved_date,
69: settlement_code,

Line 136: Update ozf_OFFER_ADJUSTMENTS_B

132: p_security_group_id NUMBER)
133:
134: IS
135: BEGIN
136: Update ozf_OFFER_ADJUSTMENTS_B
137: SET
138: offer_adjustment_id = DECODE( p_offer_adjustment_id, FND_API.g_miss_num, offer_adjustment_id, p_offer_adjustment_id),
139: effective_date = DECODE( p_effective_date, FND_API.g_miss_date, effective_date, p_effective_date),
140: approved_date = DECODE( p_approved_date, FND_API.g_miss_date, approved_date, p_approved_date),

Line 181: DELETE FROM ozf_OFFER_ADJUSTMENTS_B

177: PROCEDURE Delete_Row(
178: p_OFFER_ADJUSTMENT_ID NUMBER)
179: IS
180: BEGIN
181: DELETE FROM ozf_OFFER_ADJUSTMENTS_B
182: WHERE OFFER_ADJUSTMENT_ID = p_OFFER_ADJUSTMENT_ID;
183: If (SQL%NOTFOUND) then
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: End If;

Line 227: FROM ozf_OFFER_ADJUSTMENTS_B

223:
224: IS
225: CURSOR C IS
226: SELECT *
227: FROM ozf_OFFER_ADJUSTMENTS_B
228: WHERE OFFER_ADJUSTMENT_ID = p_OFFER_ADJUSTMENT_ID
229: FOR UPDATE of OFFER_ADJUSTMENT_ID NOWAIT;
230: Recinfo C%ROWTYPE;
231: BEGIN