eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_LOTS_PVT dependencies on IC_LOTS_CPG

Line 21: --| Insert_Ic_Lots_Cpg |

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

Line 193: --| Insert_Ic_Lots_Cpg |

189:
190: -- Func start of comments
191: --+==========================================================================+
192: --| FUNCTION NAME |
193: --| Insert_Ic_Lots_Cpg |
194: --| |
195: --| USAGE |
196: --| Insert a row into ic_lots_cpg |
197: --| |

Line 196: --| Insert a row into ic_lots_cpg |

192: --| FUNCTION NAME |
193: --| Insert_Ic_Lots_Cpg |
194: --| |
195: --| USAGE |
196: --| Insert a row into ic_lots_cpg |
197: --| |
198: --| DESCRIPTION |
199: --| This procedure inserts a row into ic_lots_cpg |
200: --| |

Line 199: --| This procedure inserts a row into ic_lots_cpg |

195: --| USAGE |
196: --| Insert a row into ic_lots_cpg |
197: --| |
198: --| DESCRIPTION |
199: --| This procedure inserts a row into ic_lots_cpg |
200: --| |
201: --| PARAMETERS |
202: --| p_ic_lots_cpg_rec IN RECORD - CPG Lots Additional Attributes |
203: --| |

Line 202: --| p_ic_lots_cpg_rec IN RECORD - CPG Lots Additional Attributes |

198: --| DESCRIPTION |
199: --| This procedure inserts a row into ic_lots_cpg |
200: --| |
201: --| PARAMETERS |
202: --| p_ic_lots_cpg_rec IN RECORD - CPG Lots Additional Attributes |
203: --| |
204: --| RETURNS |
205: --| TRUE - If insert successful |
206: --| FALSE - If insert fails |

Line 212: FUNCTION Insert_Ic_Lots_Cpg

208: --| HISTORY |
209: --| |
210: --+==========================================================================+
211: -- Func end of comments
212: FUNCTION Insert_Ic_Lots_Cpg
213: (p_ic_lots_cpg_rec IN ic_lots_cpg%ROWTYPE)
214: RETURN BOOLEAN
215: IS
216:

Line 213: (p_ic_lots_cpg_rec IN ic_lots_cpg%ROWTYPE)

209: --| |
210: --+==========================================================================+
211: -- Func end of comments
212: FUNCTION Insert_Ic_Lots_Cpg
213: (p_ic_lots_cpg_rec IN ic_lots_cpg%ROWTYPE)
214: RETURN BOOLEAN
215: IS
216:
217: BEGIN

Line 219: INSERT INTO ic_lots_cpg

215: IS
216:
217: BEGIN
218:
219: INSERT INTO ic_lots_cpg
220: ( item_id
221: , lot_id
222: , ic_matr_date
223: , ic_hold_date

Line 231: ( p_ic_lots_cpg_rec.item_id

227: , last_updated_by
228: , last_update_login
229: )
230: VALUES
231: ( p_ic_lots_cpg_rec.item_id
232: , p_ic_lots_cpg_rec.lot_id
233: , p_ic_lots_cpg_rec.ic_matr_date
234: , p_ic_lots_cpg_rec.ic_hold_date
235: , p_ic_lots_cpg_rec.created_by

Line 232: , p_ic_lots_cpg_rec.lot_id

228: , last_update_login
229: )
230: VALUES
231: ( p_ic_lots_cpg_rec.item_id
232: , p_ic_lots_cpg_rec.lot_id
233: , p_ic_lots_cpg_rec.ic_matr_date
234: , p_ic_lots_cpg_rec.ic_hold_date
235: , p_ic_lots_cpg_rec.created_by
236: , p_ic_lots_cpg_rec.creation_date

Line 233: , p_ic_lots_cpg_rec.ic_matr_date

229: )
230: VALUES
231: ( p_ic_lots_cpg_rec.item_id
232: , p_ic_lots_cpg_rec.lot_id
233: , p_ic_lots_cpg_rec.ic_matr_date
234: , p_ic_lots_cpg_rec.ic_hold_date
235: , p_ic_lots_cpg_rec.created_by
236: , p_ic_lots_cpg_rec.creation_date
237: , p_ic_lots_cpg_rec.last_update_date

Line 234: , p_ic_lots_cpg_rec.ic_hold_date

230: VALUES
231: ( p_ic_lots_cpg_rec.item_id
232: , p_ic_lots_cpg_rec.lot_id
233: , p_ic_lots_cpg_rec.ic_matr_date
234: , p_ic_lots_cpg_rec.ic_hold_date
235: , p_ic_lots_cpg_rec.created_by
236: , p_ic_lots_cpg_rec.creation_date
237: , p_ic_lots_cpg_rec.last_update_date
238: , p_ic_lots_cpg_rec.last_updated_by

Line 235: , p_ic_lots_cpg_rec.created_by

231: ( p_ic_lots_cpg_rec.item_id
232: , p_ic_lots_cpg_rec.lot_id
233: , p_ic_lots_cpg_rec.ic_matr_date
234: , p_ic_lots_cpg_rec.ic_hold_date
235: , p_ic_lots_cpg_rec.created_by
236: , p_ic_lots_cpg_rec.creation_date
237: , p_ic_lots_cpg_rec.last_update_date
238: , p_ic_lots_cpg_rec.last_updated_by
239: , p_ic_lots_cpg_rec.last_update_login

Line 236: , p_ic_lots_cpg_rec.creation_date

232: , p_ic_lots_cpg_rec.lot_id
233: , p_ic_lots_cpg_rec.ic_matr_date
234: , p_ic_lots_cpg_rec.ic_hold_date
235: , p_ic_lots_cpg_rec.created_by
236: , p_ic_lots_cpg_rec.creation_date
237: , p_ic_lots_cpg_rec.last_update_date
238: , p_ic_lots_cpg_rec.last_updated_by
239: , p_ic_lots_cpg_rec.last_update_login
240: );

Line 237: , p_ic_lots_cpg_rec.last_update_date

233: , p_ic_lots_cpg_rec.ic_matr_date
234: , p_ic_lots_cpg_rec.ic_hold_date
235: , p_ic_lots_cpg_rec.created_by
236: , p_ic_lots_cpg_rec.creation_date
237: , p_ic_lots_cpg_rec.last_update_date
238: , p_ic_lots_cpg_rec.last_updated_by
239: , p_ic_lots_cpg_rec.last_update_login
240: );
241:

Line 238: , p_ic_lots_cpg_rec.last_updated_by

234: , p_ic_lots_cpg_rec.ic_hold_date
235: , p_ic_lots_cpg_rec.created_by
236: , p_ic_lots_cpg_rec.creation_date
237: , p_ic_lots_cpg_rec.last_update_date
238: , p_ic_lots_cpg_rec.last_updated_by
239: , p_ic_lots_cpg_rec.last_update_login
240: );
241:
242: RETURN TRUE;

Line 239: , p_ic_lots_cpg_rec.last_update_login

235: , p_ic_lots_cpg_rec.created_by
236: , p_ic_lots_cpg_rec.creation_date
237: , p_ic_lots_cpg_rec.last_update_date
238: , p_ic_lots_cpg_rec.last_updated_by
239: , p_ic_lots_cpg_rec.last_update_login
240: );
241:
242: RETURN TRUE;
243:

Line 251: , 'insert_ic_lots_cpg'

247: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: -- THEN
249:
250: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
251: , 'insert_ic_lots_cpg'
252: );
253: -- END IF;
254: RETURN FALSE;
255:

Line 256: END Insert_Ic_Lots_Cpg;

252: );
253: -- END IF;
254: RETURN FALSE;
255:
256: END Insert_Ic_Lots_Cpg;
257:
258: END GMI_LOTS_PVT;