[Home] [Help]
PACKAGE BODY: APPS.OZF_SD_REQUEST_LINES_PKG
Source
1 PACKAGE BODY OZF_SD_REQUEST_LINES_PKG AS
2 /* $Header: ozftsplb.pls 120.0 2008/01/03 06:26:38 bkunjan noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_SD_REQUEST_LINES_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(15) := 'ozftsplb.pls';
6
7 PROCEDURE Insert_Row(
8 p_request_line_id NUMBER,
9 p_object_version_number NUMBER,
10 p_last_update_date DATE,
11 p_last_updated_by NUMBER,
12 p_creation_date DATE,
13 p_created_by NUMBER,
14 p_last_update_login NUMBER,
15 p_request_id NUMBER,
16 p_program_application_id NUMBER,
17 p_program_update_date DATE,
18 p_program_id NUMBER,
19 p_create_from VARCHAR2,
20 p_request_header_id NUMBER,
21 p_product_context VARCHAR2,
22 p_inventory_item_id NUMBER,
23 p_prod_catg_id NUMBER,
24 p_product_cat_set_id NUMBER,
25 p_product_cost NUMBER,
26 p_item_uom VARCHAR2,
27 p_requested_discount_type VARCHAR2,
28 p_requested_discount_value NUMBER,
29 p_cost_basis VARCHAR2,
30 p_max_qty NUMBER,
31 p_limit_qty NUMBER,
32 p_design_win VARCHAR2,
33 p_end_customer_price NUMBER,
34 p_requested_line_amount NUMBER,
35 p_approved_discount_type VARCHAR2,
36 p_approved_discount_value NUMBER,
37 p_approved_amount NUMBER,
38 p_total_requested_amount NUMBER,
39 p_total_approved_amount NUMBER,
40 p_approved_max_qty NUMBER,
41 p_attribute_category VARCHAR2,
42 p_attribute1 VARCHAR2,
43 p_attribute2 VARCHAR2,
44 p_attribute3 VARCHAR2,
45 p_attribute4 VARCHAR2,
46 p_attribute5 VARCHAR2,
47 p_attribute6 VARCHAR2,
48 p_attribute7 VARCHAR2,
49 p_attribute8 VARCHAR2,
50 p_attribute9 VARCHAR2,
51 p_attribute10 VARCHAR2,
52 p_attribute11 VARCHAR2,
53 p_attribute12 VARCHAR2,
54 p_attribute13 VARCHAR2,
55 p_attribute14 VARCHAR2,
56 p_attribute15 VARCHAR2,
57 p_vendor_approved_flag VARCHAR2,
58 p_vendor_item_code VARCHAR2,
59 p_start_date DATE,
60 p_end_date DATE,
61 p_end_customer_price_type VARCHAR2,
62 p_end_customer_tolerance_type VARCHAR2,
63 p_end_customer_tolerance_value NUMBER,
64 p_security_group_id NUMBER,
65 p_org_id NUMBER,
66 p_rejection_code VARCHAR2,
67 p_discount_currency VARCHAR2,
68 p_product_cost_currency VARCHAR2,
69 p_end_customer_currency VARCHAR2,
70 p_approved_discount_currency VARCHAR2)
71 IS
72 BEGIN
73 INSERT INTO OZF_SD_REQUEST_LINES_ALL(
74 request_line_id,
75 object_version_number,
76 last_update_date,
77 last_updated_by,
78 creation_date,
79 created_by,
80 last_update_login,
81 request_id,
82 program_application_id,
83 program_update_date,
84 program_id,
85 create_from,
86 request_header_id,
87 product_context,
88 inventory_item_id,
89 prod_catg_id,
90 product_cat_set_id,
91 product_cost,
92 item_uom,
93 requested_discount_type,
94 requested_discount_value,
95 cost_basis,
96 max_qty,
97 limit_qty,
98 design_win,
99 end_customer_price,
100 requested_line_amount,
101 approved_discount_type,
102 approved_discount_value,
103 approved_amount,
104 total_requested_amount,
105 total_approved_amount,
106 approved_max_qty,
107 attribute_category,
108 attribute1,
109 attribute2,
110 attribute3,
111 attribute4,
112 attribute5,
113 attribute6,
114 attribute7,
115 attribute8,
116 attribute9,
117 attribute10,
118 attribute11,
119 attribute12,
120 attribute13,
121 attribute14,
122 attribute15,
123 vendor_approved_flag,
124 vendor_item_code,
125 start_date,
126 end_date,
127 end_customer_price_type,
128 end_customer_tolerance_type,
129 end_customer_tolerance_value,
130 security_group_id,
131 org_id,
132 rejection_code,
133 requested_discount_currency,
134 product_cost_currency,
135 end_customer_currency,
136 approved_discount_currency
137 )
138 VALUES(
139 p_request_line_id,
140 p_object_version_number,
141 p_last_update_date,
142 p_last_updated_by,
143 p_creation_date,
144 p_created_by,
145 p_last_update_login,
146 p_request_id,
147 p_program_application_id,
148 p_program_update_date,
149 p_program_id,
150 p_create_from,
151 p_request_header_id,
152 p_product_context,
153 p_inventory_item_id,
154 p_prod_catg_id,
155 p_product_cat_set_id,
156 p_product_cost,
157 p_item_uom,
158 p_requested_discount_type,
159 p_requested_discount_value,
160 p_cost_basis,
161 p_max_qty,
162 p_limit_qty,
163 p_design_win,
164 p_end_customer_price,
165 p_requested_line_amount,
166 p_approved_discount_type,
167 p_approved_discount_value,
168 p_approved_amount,
169 p_total_requested_amount,
170 p_total_approved_amount,
171 p_approved_max_qty,
172 p_attribute_category,
173 p_attribute1,
174 p_attribute2,
175 p_attribute3,
176 p_attribute4,
177 p_attribute5,
178 p_attribute6,
179 p_attribute7,
180 p_attribute8,
181 p_attribute9,
182 p_attribute10,
183 p_attribute11,
184 p_attribute12,
185 p_attribute13,
186 p_attribute14,
187 p_attribute15,
188 p_vendor_approved_flag,
189 p_vendor_item_code,
190 p_start_date,
191 p_end_date,
192 p_end_customer_price_type,
193 p_end_customer_tolerance_type,
194 p_end_customer_tolerance_value,
195 p_security_group_id,
196 p_org_id,
197 p_rejection_code,
198 p_discount_currency,
199 p_product_cost_currency,
200 p_end_customer_currency,
201 p_approved_discount_currency);
202
203 END Insert_Row;
204
205 PROCEDURE Update_Row(
206 p_request_line_id NUMBER,
207 p_object_version_number NUMBER,
208 p_last_update_date DATE,
209 p_last_updated_by NUMBER,
210 p_last_update_login NUMBER,
211 p_request_id NUMBER,
212 p_program_application_id NUMBER,
213 p_program_update_date DATE,
214 p_program_id NUMBER,
215 p_create_from VARCHAR2,
216 p_request_header_id NUMBER,
217 p_product_context VARCHAR2,
218 p_inventory_item_id NUMBER,
219 p_prod_catg_id NUMBER,
220 p_product_cat_set_id NUMBER,
221 p_product_cost NUMBER,
222 p_item_uom VARCHAR2,
223 p_requested_discount_type VARCHAR2,
224 p_requested_discount_value NUMBER,
225 p_cost_basis VARCHAR2,
226 p_max_qty NUMBER,
227 p_limit_qty NUMBER,
228 p_design_win VARCHAR2,
229 p_end_customer_price NUMBER,
230 p_requested_line_amount NUMBER,
231 p_approved_discount_type VARCHAR2,
232 p_approved_discount_value NUMBER,
233 p_approved_amount NUMBER,
234 p_total_requested_amount NUMBER,
235 p_total_approved_amount NUMBER,
236 p_approved_max_qty NUMBER,
237 p_attribute_category VARCHAR2,
238 p_attribute1 VARCHAR2,
239 p_attribute2 VARCHAR2,
240 p_attribute3 VARCHAR2,
241 p_attribute4 VARCHAR2,
242 p_attribute5 VARCHAR2,
243 p_attribute6 VARCHAR2,
244 p_attribute7 VARCHAR2,
245 p_attribute8 VARCHAR2,
246 p_attribute9 VARCHAR2,
247 p_attribute10 VARCHAR2,
248 p_attribute11 VARCHAR2,
249 p_attribute12 VARCHAR2,
250 p_attribute13 VARCHAR2,
251 p_attribute14 VARCHAR2,
252 p_attribute15 VARCHAR2,
253 p_vendor_approved_flag VARCHAR2,
254 p_vendor_item_code VARCHAR2,
255 p_start_date DATE,
256 p_end_date DATE,
257 p_end_customer_price_type VARCHAR2,
258 p_end_customer_tolerance_type VARCHAR2,
259 p_end_customer_tolerance_value NUMBER,
260 p_security_group_id NUMBER,
261 p_org_id NUMBER,
262 p_rejection_code VARCHAR2,
263 p_discount_currency VARCHAR2,
264 p_product_cost_currency VARCHAR2,
265 p_end_customer_currency VARCHAR2,
266 p_approved_discount_currency VARCHAR2)
267 IS
268 BEGIN
269 UPDATE OZF_SD_REQUEST_LINES_ALL
270 SET request_line_id = p_request_line_id,
271 object_version_number = p_object_version_number,
272 last_update_date = p_last_update_date,
273 last_updated_by = p_last_updated_by,
274 last_update_login = p_last_update_login,
275 request_id = p_request_id,
276 program_application_id = p_program_application_id,
277 program_update_date = p_program_update_date,
278 program_id = p_program_id,
279 create_from = p_create_from,
280 request_header_id = p_request_header_id,
281 product_context = p_product_context,
282 inventory_item_id = p_inventory_item_id,
283 prod_catg_id = p_prod_catg_id,
284 product_cat_set_id = p_product_cat_set_id,
285 product_cost = p_product_cost,
286 item_uom = p_item_uom,
287 requested_discount_type = p_requested_discount_type,
288 requested_discount_value = p_requested_discount_value,
289 cost_basis = p_cost_basis,
290 max_qty = p_max_qty,
291 limit_qty = p_limit_qty,
292 design_win = p_design_win,
293 end_customer_price = p_end_customer_price,
294 requested_line_amount = p_requested_line_amount,
295 approved_discount_type = p_approved_discount_type,
296 approved_discount_value = p_approved_discount_value,
297 approved_amount = p_approved_amount,
298 total_requested_amount = p_total_requested_amount,
299 total_approved_amount = p_total_approved_amount,
300 approved_max_qty = p_approved_max_qty,
301 attribute_category = p_attribute_category,
302 attribute1 = p_attribute1,
303 attribute2 = p_attribute2,
304 attribute3 = p_attribute3,
305 attribute4 = p_attribute4,
306 attribute5 = p_attribute5,
307 attribute6 = p_attribute6,
308 attribute7 = p_attribute7,
309 attribute8 = p_attribute8,
310 attribute9 = p_attribute9,
311 attribute10 = p_attribute10,
312 attribute11 = p_attribute11,
313 attribute12 = p_attribute12,
314 attribute13 = p_attribute13,
315 attribute14 = p_attribute14,
316 attribute15 = p_attribute15,
317 vendor_approved_flag = p_vendor_approved_flag,
318 vendor_item_code = p_vendor_item_code,
319 start_date = p_start_date,
320 end_date = p_end_date,
321 end_customer_price_type = p_end_customer_price_type,
322 end_customer_tolerance_type = p_end_customer_tolerance_type,
323 end_customer_tolerance_value = p_end_customer_tolerance_value,
324 security_group_id = p_security_group_id,
325 org_id = p_org_id,
326 rejection_code = p_rejection_code,
327 requested_discount_currency = p_discount_currency,
328 product_cost_currency = p_product_cost_currency,
329 end_customer_currency = p_end_customer_currency,
330 approved_discount_currency = p_approved_discount_currency
331 WHERE request_line_id =p_request_line_id;
332
333 END Update_Row;
334 END OZF_SD_REQUEST_LINES_PKG;