APPS.OZF_OFFER_ADJ_LINE_PKG dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 70: INSERT INTO ozf_offer_adjustment_lines(

66:
67: px_object_version_number := nvl(px_object_version_number, 1);
68:
69:
70: INSERT INTO ozf_offer_adjustment_lines(
71: offer_adjustment_line_id,
72: offer_adjustment_id,
73: list_line_id,
74: arithmetic_operator,

Line 154: Update ozf_offer_adjustment_lines

150: )
151:
152: IS
153: BEGIN
154: Update ozf_offer_adjustment_lines
155: SET
156: offer_adjustment_line_id = DECODE( p_offer_adjustment_line_id, null, offer_adjustment_line_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_line_id),
157: offer_adjustment_id = DECODE( p_offer_adjustment_id, null, offer_adjustment_id, FND_API.G_MISS_NUM, null, p_offer_adjustment_id),
158: list_line_id = DECODE( p_list_line_id, null, list_line_id, FND_API.G_MISS_NUM, null, p_list_line_id),

Line 208: DELETE FROM ozf_offer_adjustment_lines

204: p_offer_adjustment_line_id NUMBER,
205: p_object_version_number NUMBER)
206: IS
207: BEGIN
208: DELETE FROM ozf_offer_adjustment_lines
209: WHERE offer_adjustment_line_id = p_offer_adjustment_line_id
210: AND object_version_number = p_object_version_number;
211: If (SQL%NOTFOUND) then
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 238: FROM ozf_offer_adjustment_lines

234: p_object_version_number NUMBER)
235: IS
236: CURSOR C IS
237: SELECT *
238: FROM ozf_offer_adjustment_lines
239: WHERE offer_adjustment_line_id = p_offer_adjustment_line_id
240: AND object_version_number = p_object_version_number
241: FOR UPDATE OF offer_adjustment_line_id NOWAIT;
242: Recinfo C%ROWTYPE;