[Home] [Help]
PACKAGE BODY: APPS.GMI_ITEM_PVT
Source
1 PACKAGE BODY GMI_ITEM_PVT AS
2 --$Header: GMIVITMB.pls 115.3 99/10/21 07:50:52 porting ship $
3 -- Body start of comments
4 --+==========================================================================+
5 --| Copyright (c) 1998 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+==========================================================================+
9 --| FILE NAME |
10 --| GMIVITMB.pls |
11 --| |
12 --| PACKAGE NAME |
13 --| GMI_ITEM_PVT |
14 --| |
15 --| DESCRIPTION |
16 --| This package contains all utility functions that insert/update Item |
17 --| related tables |
18 --| |
19 --| CONTENTS |
20 --| Insert_Ic_Item_Mst |
21 --| Insert_Ic_Item_Cpg |
22 --| |
23 --| HISTORY |
24 --| |
25 --+==========================================================================+
26 -- Body end of comments
27
28 -- Global variables
29 G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMI_ITEM_PVT';
30
31 -- Func start of comments
32 --+==========================================================================+
33 --| FUNCTION NAME |
34 --| Insert_Ic_Item_Mst |
35 --| |
36 --| USAGE |
37 --| Insert a row into ic_item_mst |
38 --| |
39 --| DESCRIPTION |
40 --| This procedure inserts a row into ic_item_mst |
41 --| |
42 --| PARAMETERS |
43 --| p_ic_item_mst_rec IN RECORD - Item Master Details |
44 --| |
45 --| RETURNS |
46 --| TRUE - If insert successful |
47 --| FALSE - If insert fails |
48 --| |
49 --| HISTORY |
50 --| 16-FEB-1999 M.Godfrey Upgrade to R11 |
51 --| 21-OCT-1999 H.Verdding Added Addition Of Attribute Fields |
52 --| B1042722 |
53 --+==========================================================================+
54 -- Func end of comments
55 FUNCTION Insert_Ic_Item_Mst
56 (p_ic_item_mst_rec IN ic_item_mst%ROWTYPE)
57 RETURN BOOLEAN
58 IS
59
60 BEGIN
61
62 INSERT INTO ic_item_mst
63 ( item_id
64 , item_no
65 , item_desc1
66 , item_desc2
67 , alt_itema
68 , alt_itemb
69 , item_um
70 , dualum_ind
71 , item_um2
72 , deviation_lo
73 , deviation_hi
74 , level_code
75 , lot_ctl
76 , lot_indivisible
77 , sublot_ctl
78 , loct_ctl
79 , noninv_ind
80 , match_type
81 , inactive_ind
82 , inv_type
83 , shelf_life
84 , retest_interval
85 , item_abccode
86 , gl_class
87 , inv_class
88 , sales_class
89 , ship_class
90 , frt_class
91 , price_class
92 , storage_class
93 , purch_class
94 , tax_class
95 , customs_class
96 , alloc_class
97 , planning_class
98 , itemcost_class
99 , cost_mthd_code
100 , upc_code
101 , grade_ctl
102 , status_ctl
103 , qc_grade
104 , lot_status
105 , bulk_id
106 , pkg_id
107 , qcitem_id
108 , qchold_res_code
109 , expaction_code
110 , fill_qty
111 , fill_um
112 , expaction_interval
113 , phantom_type
114 , whse_item_id
115 , experimental_ind
116 , exported_date
117 , created_by
118 , creation_date
119 , last_updated_by
120 , last_update_date
121 , last_update_login
122 , trans_cnt
123 , delete_mark
124 , text_code
125 , seq_dpnd_class
126 , commodity_code
127 , attribute1
128 , attribute2
129 , attribute3
130 , attribute4
131 , attribute5
132 , attribute6
133 , attribute7
134 , attribute8
135 , attribute9
136 , attribute10
137 , attribute11
138 , attribute12
139 , attribute13
140 , attribute14
141 , attribute15
142 , attribute16
143 , attribute17
144 , attribute18
145 , attribute19
146 , attribute20
147 , attribute21
148 , attribute22
149 , attribute23
150 , attribute24
151 , attribute25
152 , attribute26
153 , attribute27
154 , attribute28
155 , attribute29
156 , attribute30
157 , attribute_category
158 )
159 VALUES
160 ( p_ic_item_mst_rec.item_id
161 , p_ic_item_mst_rec.item_no
162 , p_ic_item_mst_rec.item_desc1
163 , p_ic_item_mst_rec.item_desc2
164 , p_ic_item_mst_rec.alt_itema
165 , p_ic_item_mst_rec.alt_itemb
166 , p_ic_item_mst_rec.item_um
167 , p_ic_item_mst_rec.dualum_ind
168 , p_ic_item_mst_rec.item_um2
169 , p_ic_item_mst_rec.deviation_lo
170 , p_ic_item_mst_rec.deviation_hi
171 , p_ic_item_mst_rec.level_code
172 , p_ic_item_mst_rec.lot_ctl
173 , p_ic_item_mst_rec.lot_indivisible
174 , p_ic_item_mst_rec.sublot_ctl
175 , p_ic_item_mst_rec.loct_ctl
176 , p_ic_item_mst_rec.noninv_ind
177 , p_ic_item_mst_rec.match_type
178 , p_ic_item_mst_rec.inactive_ind
179 , p_ic_item_mst_rec.inv_type
180 , p_ic_item_mst_rec.shelf_life
181 , p_ic_item_mst_rec.retest_interval
182 , p_ic_item_mst_rec.item_abccode
183 , p_ic_item_mst_rec.gl_class
184 , p_ic_item_mst_rec.inv_class
185 , p_ic_item_mst_rec.sales_class
186 , p_ic_item_mst_rec.ship_class
187 , p_ic_item_mst_rec.frt_class
188 , p_ic_item_mst_rec.price_class
189 , p_ic_item_mst_rec.storage_class
190 , p_ic_item_mst_rec.purch_class
191 , p_ic_item_mst_rec.tax_class
192 , p_ic_item_mst_rec.customs_class
193 , p_ic_item_mst_rec.alloc_class
194 , p_ic_item_mst_rec.planning_class
195 , p_ic_item_mst_rec.itemcost_class
196 , p_ic_item_mst_rec.cost_mthd_code
197 , p_ic_item_mst_rec.upc_code
198 , p_ic_item_mst_rec.grade_ctl
199 , p_ic_item_mst_rec.status_ctl
200 , p_ic_item_mst_rec.qc_grade
201 , p_ic_item_mst_rec.lot_status
202 , p_ic_item_mst_rec.bulk_id
203 , p_ic_item_mst_rec.pkg_id
204 , p_ic_item_mst_rec.qcitem_id
205 , p_ic_item_mst_rec.qchold_res_code
206 , p_ic_item_mst_rec.expaction_code
207 , p_ic_item_mst_rec.fill_qty
208 , p_ic_item_mst_rec.fill_um
209 , p_ic_item_mst_rec.expaction_interval
210 , p_ic_item_mst_rec.phantom_type
211 , p_ic_item_mst_rec.whse_item_id
212 , p_ic_item_mst_rec.experimental_ind
213 , p_ic_item_mst_rec.exported_date
214 , p_ic_item_mst_rec.created_by
215 , p_ic_item_mst_rec.creation_date
216 , p_ic_item_mst_rec.last_updated_by
217 , p_ic_item_mst_rec.last_update_date
218 , p_ic_item_mst_rec.last_update_login
219 , p_ic_item_mst_rec.trans_cnt
220 , p_ic_item_mst_rec.delete_mark
221 , p_ic_item_mst_rec.text_code
222 , p_ic_item_mst_rec.seq_dpnd_class
223 , p_ic_item_mst_rec.commodity_code
224 , p_ic_item_mst_rec.attribute1
225 , p_ic_item_mst_rec.attribute2
226 , p_ic_item_mst_rec.attribute3
227 , p_ic_item_mst_rec.attribute4
228 , p_ic_item_mst_rec.attribute5
229 , p_ic_item_mst_rec.attribute6
230 , p_ic_item_mst_rec.attribute7
231 , p_ic_item_mst_rec.attribute8
232 , p_ic_item_mst_rec.attribute9
233 , p_ic_item_mst_rec.attribute10
234 , p_ic_item_mst_rec.attribute11
235 , p_ic_item_mst_rec.attribute12
236 , p_ic_item_mst_rec.attribute13
237 , p_ic_item_mst_rec.attribute14
238 , p_ic_item_mst_rec.attribute15
239 , p_ic_item_mst_rec.attribute16
240 , p_ic_item_mst_rec.attribute17
241 , p_ic_item_mst_rec.attribute18
242 , p_ic_item_mst_rec.attribute19
243 , p_ic_item_mst_rec.attribute20
244 , p_ic_item_mst_rec.attribute21
245 , p_ic_item_mst_rec.attribute22
246 , p_ic_item_mst_rec.attribute23
247 , p_ic_item_mst_rec.attribute24
248 , p_ic_item_mst_rec.attribute25
249 , p_ic_item_mst_rec.attribute26
250 , p_ic_item_mst_rec.attribute27
251 , p_ic_item_mst_rec.attribute28
252 , p_ic_item_mst_rec.attribute29
253 , p_ic_item_mst_rec.attribute30
254 , p_ic_item_mst_rec.attribute_category
255 );
256
257 RETURN TRUE;
258
259 EXCEPTION
260
261 WHEN OTHERS THEN
262 -- IF FND_MSG_PUB.check_msg_level
263 -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
264 -- THEN
265
266 FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
267 , 'insert_ic_item_mst'
268 );
269 -- END IF;
270 RETURN FALSE;
271
272 END Insert_Ic_Item_Mst;
273
274 -- Func start of comments
275 --+==========================================================================+
276 --| FUNCTION NAME |
277 --| Insert_Ic_Item_Cpg |
278 --| |
279 --| USAGE |
280 --| Insert a row into ic_item_cpg |
281 --| |
282 --| DESCRIPTION |
283 --| This procedure inserts a row into ic_item_cpg |
284 --| |
285 --| PARAMETERS |
286 --| p_ic_item_cpg_rec IN RECORD - CPG Item Additional Attributes |
287 --| |
288 --| RETURNS |
289 --| TRUE - If insert successful |
290 --| FALSE - If insert fails |
291 --| |
292 --| HISTORY |
293 --| |
294 --+==========================================================================+
295 -- Func end of comments
296 FUNCTION Insert_Ic_Item_Cpg
297 (p_ic_item_cpg_rec IN ic_item_cpg%ROWTYPE)
298 RETURN BOOLEAN
299 IS
300
301 BEGIN
302
303 INSERT INTO ic_item_cpg
304 ( item_id
305 , ic_matr_days
306 , ic_hold_days
307 , created_by
308 , creation_date
309 , last_updated_by
310 , last_update_date
311 , last_update_login
312 )
313 VALUES
314 ( p_ic_item_cpg_rec.item_id
315 , p_ic_item_cpg_rec.ic_matr_days
316 , p_ic_item_cpg_rec.ic_hold_days
317 , p_ic_item_cpg_rec.created_by
318 , p_ic_item_cpg_rec.creation_date
319 , p_ic_item_cpg_rec.last_updated_by
320 , p_ic_item_cpg_rec.last_update_date
321 , p_ic_item_cpg_rec.last_update_login
322 );
323
324 RETURN TRUE;
325
326 EXCEPTION
327 WHEN OTHERS THEN
328 -- IF FND_MSG_PUB.check_msg_level
329 -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
330 -- THEN
331
332 FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
333 , 'insert_ic_item_cpg'
334 );
335 -- END IF;
336 RETURN FALSE;
337
338 END Insert_Ic_Item_Cpg;
339
340 END GMI_ITEM_PVT;