DBA Data[Home] [Help]

APPS.GMI_ITEM_PVT dependencies on IC_ITEM_CPG

Line 21: --| Insert_Ic_Item_Cpg |

17: --| related tables |
18: --| |
19: --| CONTENTS |
20: --| Insert_Ic_Item_Mst |
21: --| Insert_Ic_Item_Cpg |
22: --| |
23: --| HISTORY |
24: --| |
25: --+==========================================================================+

Line 277: --| Insert_Ic_Item_Cpg |

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: --| |

Line 280: --| Insert a row into ic_item_cpg |

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: --| |

Line 283: --| This procedure inserts a row into ic_item_cpg |

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: --| |

Line 286: --| p_ic_item_cpg_rec IN RECORD - CPG Item Additional Attributes |

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 |

Line 296: FUNCTION Insert_Ic_Item_Cpg

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:

Line 297: (p_ic_item_cpg_rec IN ic_item_cpg%ROWTYPE)

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

Line 303: INSERT INTO ic_item_cpg

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

Line 314: ( p_ic_item_cpg_rec.item_id

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

Line 315: , p_ic_item_cpg_rec.ic_matr_days

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

Line 316: , p_ic_item_cpg_rec.ic_hold_days

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

Line 317: , p_ic_item_cpg_rec.created_by

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

Line 318: , p_ic_item_cpg_rec.creation_date

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: );

Line 319: , p_ic_item_cpg_rec.last_updated_by

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:

Line 320: , p_ic_item_cpg_rec.last_update_date

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;

Line 321: , p_ic_item_cpg_rec.last_update_login

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:

Line 333: , 'insert_ic_item_cpg'

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:

Line 338: END Insert_Ic_Item_Cpg;

334: );
335: -- END IF;
336: RETURN FALSE;
337:
338: END Insert_Ic_Item_Cpg;
339:
340: END GMI_ITEM_PVT;