[Home] [Help]
PACKAGE BODY: APPS.OZF_OFFER_ADJ_LINE_PKG
Source
1 PACKAGE BODY OZF_Offer_Adj_Line_PKG as
2 /* $Header: ozftoalb.pls 120.1 2005/09/26 17:59:42 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Offer_Adj_Line_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
16 -- End of Comments
17 -- ===============================================================
18
19
20 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Offer_Adj_Line_PKG';
21 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftoalb.pls';
22
23
24
25
26 -- ========================================================
27 --
28 -- NAME
29 -- Insert_Row
30 --
31 -- PURPOSE
32 --
33 -- NOTES
34 --
35 -- HISTORY
36 --
37 -- ========================================================
38 PROCEDURE Insert_Row(
39 px_offer_adjustment_line_id IN OUT NOCOPY NUMBER,
40 p_offer_adjustment_id NUMBER,
41 p_list_line_id NUMBER,
42 p_arithmetic_operator VARCHAR2,
43 p_original_discount NUMBER,
44 p_modified_discount NUMBER,
45 p_last_update_date DATE,
46 p_last_updated_by NUMBER,
47 p_creation_date DATE,
48 p_created_by NUMBER,
49 p_last_update_login NUMBER,
50 px_object_version_number IN OUT NOCOPY NUMBER,
51 p_list_header_id NUMBER,
52 p_accrual_flag VARCHAR2,
53 p_list_line_id_td NUMBER,
54 p_original_discount_td NUMBER,
55 p_modified_discount_td NUMBER,
56 p_quantity NUMBER ,
57 p_created_from_adjustments VARCHAR2,
58 p_discount_end_date DATE)
59
60 IS
61 x_rowid VARCHAR2(30);
62
63
64 BEGIN
65
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,
75 original_discount,
76 modified_discount,
77 last_update_date,
78 last_updated_by,
79 creation_date,
80 created_by,
81 last_update_login,
82 object_version_number,
83 list_header_id,
84 accrual_flag,
85 list_line_id_td,
86 original_discount_td,
87 modified_discount_td,
88 quantity,
89 created_from_adjustments,
90 discount_end_date
91 ) VALUES (
92 DECODE( px_offer_adjustment_line_id, FND_API.G_MISS_NUM, NULL, px_offer_adjustment_line_id),
93 DECODE( p_offer_adjustment_id, FND_API.G_MISS_NUM, NULL, p_offer_adjustment_id),
94 DECODE( p_list_line_id, FND_API.G_MISS_NUM, NULL, p_list_line_id),
95 DECODE( p_arithmetic_operator, FND_API.g_miss_char, NULL, p_arithmetic_operator),
96 DECODE( p_original_discount, FND_API.G_MISS_NUM, NULL, p_original_discount),
97 DECODE( p_modified_discount, FND_API.G_MISS_NUM, NULL, p_modified_discount),
98 DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99 DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
100 DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
101 DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
102 DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
103 DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
104 DECODE( p_list_header_id, FND_API.G_MISS_NUM, NULL, p_list_header_id),
105 DECODE( p_accrual_flag, FND_API.g_miss_char, NULL, p_accrual_flag),
106 DECODE( p_list_line_id_td, FND_API.G_MISS_NUM, NULL, p_list_line_id_td),
107 DECODE( p_original_discount_td, FND_API.G_MISS_NUM, NULL, p_original_discount_td),
108 DECODE( p_modified_discount_td, FND_API.G_MISS_NUM, NULL, p_modified_discount_td),
109 DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity),
110 DECODE( p_created_from_adjustments, FND_API.g_miss_char, NULL, p_created_from_adjustments),
111 DECODE( p_discount_end_date, FND_API.g_miss_date, NULL, p_discount_end_date)
112 );
113
114 END Insert_Row;
115
116
117
118
119 -- ========================================================
120 --
121 -- NAME
122 -- Update_Row
123 --
124 -- PURPOSE
125 --
126 -- NOTES
127 --
128 -- HISTORY
129 --
130 -- ========================================================
131 PROCEDURE Update_Row(
132 p_offer_adjustment_line_id NUMBER,
133 p_offer_adjustment_id NUMBER,
134 p_list_line_id NUMBER,
135 p_arithmetic_operator VARCHAR2,
136 p_original_discount NUMBER,
137 p_modified_discount NUMBER,
138 p_last_update_date DATE,
139 p_last_updated_by NUMBER,
140 p_last_update_login NUMBER,
141 px_object_version_number IN OUT NOCOPY NUMBER,
142 p_list_header_id NUMBER,
143 p_accrual_flag VARCHAR2,
144 p_list_line_id_td NUMBER,
145 p_original_discount_td NUMBER,
146 p_modified_discount_td NUMBER,
147 p_quantity NUMBER,
148 p_created_from_adjustments VARCHAR2,
149 p_discount_end_date DATE
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),
159 arithmetic_operator = DECODE( p_arithmetic_operator, null, arithmetic_operator, FND_API.g_miss_char, null, p_arithmetic_operator),
160 original_discount = DECODE( p_original_discount, null, original_discount, FND_API.G_MISS_NUM, null, p_original_discount),
161 -- modified_discount = DECODE( p_modified_discount, null, modified_discount, FND_API.G_MISS_NUM, null, p_modified_discount),
162 modified_discount = p_modified_discount,
163 last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(null), p_last_update_date),
164 last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
165 last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
166 object_version_number = object_version_number + 1 ,
167 list_header_id = DECODE( p_list_header_id, null, list_header_id, FND_API.G_MISS_NUM, null, p_list_header_id),
168 accrual_flag = DECODE( p_accrual_flag, null, accrual_flag, FND_API.g_miss_char, null, p_accrual_flag),
169 list_line_id_td = DECODE( p_list_line_id_td, null, list_line_id_td, FND_API.G_MISS_NUM, null, p_list_line_id_td),
170 original_discount_td = DECODE( p_original_discount_td, null, original_discount_td, FND_API.G_MISS_NUM, null, p_original_discount_td),
171 -- modified_discount_td = DECODE( p_modified_discount_td, null, modified_discount_td, FND_API.G_MISS_NUM, null, p_modified_discount_td),
172 modified_discount_td = p_modified_discount_td,
173 quantity = DECODE( p_quantity, null, quantity, FND_API.G_MISS_NUM, null, p_quantity),
174 discount_end_date = DECODE(p_discount_end_date, null, discount_end_date, FND_API.G_MISS_DATE, null, p_discount_end_date)
175 -- created_from_adjustments = DECODE( p_created_from_adjustments, null, created_from_adjustments, FND_API.g_miss_char, null, p_created_from_adjustments)
176 WHERE offer_adjustment_line_id = p_offer_adjustment_line_id
177 AND object_version_number = px_object_version_number;
178
179
180 IF (SQL%NOTFOUND) THEN
181 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182 END IF;
183
184 px_object_version_number := nvl(px_object_version_number,0) + 1;
185
186 END Update_Row;
187
188
189
190
191 -- ========================================================
192 --
193 -- NAME
194 -- Delete_Row
195 --
196 -- PURPOSE
197 --
198 -- NOTES
199 --
200 -- HISTORY
201 --
202 -- ========================================================
203 PROCEDURE Delete_Row(
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;
213 End If;
214 END Delete_Row ;
215
216
217
218
219
220 -- ========================================================
221 --
222 -- NAME
223 -- Lock_Row
224 --
225 -- PURPOSE
226 --
227 -- NOTES
228 --
229 -- HISTORY
230 --
231 -- ========================================================
232 PROCEDURE Lock_Row(
233 p_offer_adjustment_line_id NUMBER,
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;
243 BEGIN
244
245 OPEN c;
246 FETCH c INTO Recinfo;
247 IF (c%NOTFOUND) THEN
248 CLOSE c;
249 OZF_Utility_PVT.error_message ('OZF_API_RECORD_NOT_FOUND');
250 RAISE FND_API.g_exc_error;
251 END IF;
252 CLOSE c;
253 END Lock_Row;
254
255
256
257 END OZF_Offer_Adj_Line_PKG;