[Home] [Help]
PACKAGE BODY: APPS.OZF_OFFER_ADJ_NEW_PRODUCTS_PKG
Source
1 PACKAGE BODY OZF_OFFER_ADJ_NEW_PRODUCTS_PKG as
2 /* $Header: ozftanpb.pls 120.0 2006/03/30 13:47:44 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_OFFER_ADJ_NEW_PRODUCTS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_OFFER_ADJ_NEW_PRODUCTS_PKG';
16 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftanpb.pls';
17 ----------------------------------------------------------
18 ---- MEDIA ----
19 ----------------------------------------------------------
20
21 -- ========================================================
22 --
23 -- NAME
24 -- createInsertBody
25 --
26 -- PURPOSE
27 --
28 -- NOTES
29 --
30 -- HISTORY
31 --
32 -- ========================================================
33 PROCEDURE Insert_Row(
34 px_offer_adj_new_product_id IN OUT NOCOPY NUMBER,
35 p_offer_adj_new_line_id NUMBER,
36 p_offer_adjustment_id NUMBER,
37 p_product_context VARCHAR2,
38 p_product_attribute VARCHAR2,
39 p_product_attr_value VARCHAR2,
40 p_excluder_flag VARCHAR2,
41 p_uom_code VARCHAR2,
42 p_creation_date DATE,
43 p_created_by NUMBER,
44 p_last_update_date DATE,
45 p_last_updated_by NUMBER,
46 p_last_update_login NUMBER,
47 px_object_version_number IN OUT NOCOPY NUMBER)
48
49 IS
50 x_rowid VARCHAR2(30);
51
52
53 BEGIN
54
55
56 px_object_version_number := 1;
57
58
59 INSERT INTO OZF_OFFER_ADJ_NEW_PRODUCTS(
60 offer_adj_new_product_id,
61 offer_adj_new_line_id,
62 offer_adjustment_id,
63 product_context,
64 product_attribute,
65 product_attr_value,
66 excluder_flag,
67 uom_code,
68 creation_date,
69 created_by,
70 last_update_date,
71 last_updated_by,
72 last_update_login,
73 object_version_number
74 ) VALUES (
75 DECODE( px_offer_adj_new_product_id, FND_API.g_miss_num, NULL, px_offer_adj_new_product_id),
76 DECODE( p_offer_adj_new_line_id, FND_API.g_miss_num, NULL, p_offer_adj_new_line_id),
77 DECODE( p_offer_adjustment_id, FND_API.g_miss_num, NULL, p_offer_adjustment_id),
78 DECODE( p_product_context, FND_API.g_miss_char, NULL, p_product_context),
79 DECODE( p_product_attribute, FND_API.g_miss_char, NULL, p_product_attribute),
80 DECODE( p_product_attr_value, FND_API.g_miss_char, NULL, p_product_attr_value),
81 DECODE( p_excluder_flag, FND_API.g_miss_char, NULL, p_excluder_flag),
82 DECODE( p_uom_code, FND_API.g_miss_char, NULL, p_uom_code),
83 DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
84 DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85 DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
86 DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87 DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
88 DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
89 END Insert_Row;
90
91
92 ----------------------------------------------------------
93 ---- MEDIA ----
94 ----------------------------------------------------------
95
96 -- ========================================================
97 --
98 -- NAME
99 -- createUpdateBody
100 --
101 -- PURPOSE
102 --
103 -- NOTES
104 --
105 -- HISTORY
106 --
107 -- ========================================================
108 PROCEDURE Update_Row(
109 p_offer_adj_new_product_id NUMBER,
110 p_offer_adj_new_line_id NUMBER,
111 p_offer_adjustment_id NUMBER,
112 p_product_context VARCHAR2,
113 p_product_attribute VARCHAR2,
114 p_product_attr_value VARCHAR2,
115 p_excluder_flag VARCHAR2,
116 p_uom_code VARCHAR2,
117 p_creation_date DATE,
118 p_created_by NUMBER,
119 p_last_update_date DATE,
120 p_last_updated_by NUMBER,
121 p_last_update_login NUMBER,
122 p_object_version_number NUMBER)
123
124 IS
125 BEGIN
126 Update OZF_OFFER_ADJ_NEW_PRODUCTS
127 SET
128 offer_adj_new_product_id = DECODE( p_offer_adj_new_product_id , null, offer_adj_new_product_id, FND_API.g_miss_num , null , p_offer_adj_new_product_id)
129 , offer_adj_new_line_id = DECODE( p_offer_adj_new_line_id, null, offer_adj_new_line_id, FND_API.g_miss_num, null , p_offer_adj_new_line_id)
130 , offer_adjustment_id = DECODE(p_offer_adjustment_id , null, offer_adjustment_id, FND_API.g_miss_num, null, p_offer_adjustment_id)
131 , product_context = DECODE( p_product_context, null, product_context,FND_API.g_miss_char, null, p_product_context)
132 , product_attribute = DECODE( p_product_attribute, null , product_attribute, FND_API.g_miss_char , null, p_product_attribute)
133 , product_attr_value = DECODE( p_product_attr_value, null, product_attr_value, FND_API.g_miss_char, null, p_product_attr_value)
134 , excluder_flag = DECODE( p_excluder_flag, null , excluder_flag, FND_API.g_miss_char , null, p_excluder_flag)
135 , uom_code = DECODE( p_uom_code, null , uom_code, FND_API.g_miss_char , null, p_uom_code)
136 , last_update_date = DECODE( p_last_update_date, null , last_update_date,FND_API.g_miss_date, null, p_last_update_date)
137 , last_updated_by = DECODE( p_last_updated_by, null , last_updated_by, FND_API.g_miss_num , null , p_last_updated_by)
138 , last_update_login = DECODE( p_last_update_login, null , last_update_login, FND_API.g_miss_num, null , p_last_update_login)
139 , object_version_number = nvl(p_object_version_number,0) + 1
140 WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID
141 AND object_version_number = p_object_version_number;
142
143 IF (SQL%NOTFOUND) THEN
144 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145 END IF;
146 END Update_Row;
147
148
149 ----------------------------------------------------------
150 ---- MEDIA ----
151 ----------------------------------------------------------
152
153 -- ========================================================
154 --
155 -- NAME
156 -- createDeleteBody
157 --
158 -- PURPOSE
159 --
160 -- NOTES
161 --
162 -- HISTORY
163 --
164 -- ========================================================
165 PROCEDURE Delete_Row(
166 p_OFFER_ADJ_NEW_PRODUCT_ID NUMBER)
167 IS
168 BEGIN
169 DELETE FROM OZF_OFFER_ADJ_NEW_PRODUCTS
170 WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID;
171 If (SQL%NOTFOUND) then
172 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173 End If;
174 END Delete_Row ;
175
176
177
178 ----------------------------------------------------------
179 ---- MEDIA ----
180 ----------------------------------------------------------
181
182 -- ========================================================
183 --
184 -- NAME
185 -- createLockBody
186 --
187 -- PURPOSE
188 --
189 -- NOTES
190 --
191 -- HISTORY
192 --
193 -- ========================================================
194 PROCEDURE Lock_Row(
195 p_offer_adj_new_product_id NUMBER,
196 p_offer_adj_new_line_id NUMBER,
197 p_offer_adjustment_id NUMBER,
198 p_product_context VARCHAR2,
199 p_product_attribute VARCHAR2,
200 p_product_attr_value VARCHAR2,
201 p_excluder_flag VARCHAR2,
202 p_uom_code VARCHAR2,
203 p_creation_date DATE,
204 p_created_by NUMBER,
205 p_last_update_date DATE,
206 p_last_updated_by NUMBER,
207 p_last_update_login NUMBER,
208 p_object_version_number NUMBER)
209
210 IS
211 CURSOR C IS
212 SELECT *
213 FROM OZF_OFFER_ADJ_NEW_PRODUCTS
214 WHERE OFFER_ADJ_NEW_PRODUCT_ID = p_OFFER_ADJ_NEW_PRODUCT_ID
215 FOR UPDATE of OFFER_ADJ_NEW_PRODUCT_ID NOWAIT;
216 Recinfo C%ROWTYPE;
217 BEGIN
218 OPEN c;
219 FETCH c INTO Recinfo;
220 If (c%NOTFOUND) then
221 CLOSE c;
222 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
223 APP_EXCEPTION.RAISE_EXCEPTION;
224 END IF;
225 CLOSE C;
226 IF (
227 ( Recinfo.offer_adj_new_product_id = p_offer_adj_new_product_id)
228 AND ( ( Recinfo.offer_adj_new_line_id = p_offer_adj_new_line_id)
229 OR ( ( Recinfo.offer_adj_new_line_id IS NULL )
230 AND ( p_offer_adj_new_line_id IS NULL )))
231 AND ( ( Recinfo.product_context = p_product_context)
232 OR ( ( Recinfo.product_context IS NULL )
233 AND ( p_product_context IS NULL )))
234 AND ( ( Recinfo.offer_adjustment_id = p_offer_adjustment_id)
235 OR ( ( Recinfo.offer_adjustment_id IS NULL )
236 AND ( p_offer_adjustment_id IS NULL )))
237 AND ( ( Recinfo.product_attribute = p_product_attribute)
238 OR ( ( Recinfo.product_attribute IS NULL )
239 AND ( p_product_attribute IS NULL )))
240 AND ( ( Recinfo.product_attr_value = p_product_attr_value)
241 OR ( ( Recinfo.product_attr_value IS NULL )
242 AND ( p_product_attr_value IS NULL )))
243 AND ( ( Recinfo.excluder_flag = p_excluder_flag)
244 OR ( ( Recinfo.excluder_flag IS NULL )
245 AND ( p_excluder_flag IS NULL )))
246 AND ( ( Recinfo.uom_code = p_uom_code)
247 OR ( ( Recinfo.uom_code IS NULL )
248 AND ( p_uom_code IS NULL )))
249 AND ( ( Recinfo.creation_date = p_creation_date)
250 OR ( ( Recinfo.creation_date IS NULL )
251 AND ( p_creation_date IS NULL )))
252 AND ( ( Recinfo.created_by = p_created_by)
253 OR ( ( Recinfo.created_by IS NULL )
254 AND ( p_created_by IS NULL )))
255 AND ( ( Recinfo.last_update_date = p_last_update_date)
256 OR ( ( Recinfo.last_update_date IS NULL )
257 AND ( p_last_update_date IS NULL )))
258 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
259 OR ( ( Recinfo.last_updated_by IS NULL )
260 AND ( p_last_updated_by IS NULL )))
261 AND ( ( Recinfo.last_update_login = p_last_update_login)
262 OR ( ( Recinfo.last_update_login IS NULL )
263 AND ( p_last_update_login IS NULL )))
264 AND ( ( Recinfo.object_version_number = p_object_version_number)
265 OR ( ( Recinfo.object_version_number IS NULL )
266 AND ( p_object_version_number IS NULL )))
267 ) THEN
268 RETURN;
269 ELSE
270 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
271 APP_EXCEPTION.RAISE_EXCEPTION;
272 END IF;
273 END Lock_Row;
274
275 END OZF_OFFER_ADJ_NEW_PRODUCTS_PKG;