17: --| related tables |
18: --| |
19: --| CONTENTS |
20: --| Insert_Ic_Item_Mst |
21: --| Insert_Ic_Item_Cpg |
22: --| |
23: --| HISTORY |
24: --| |
25: --+==========================================================================+
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: --| |
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: --| |
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: --| |
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 |
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:
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
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
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
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
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
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
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: );
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:
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;
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:
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:
334: );
335: -- END IF;
336: RETURN FALSE;
337:
338: END Insert_Ic_Item_Cpg;
339:
340: END GMI_ITEM_PVT;