265: x_ic_lots_mst_row.qc_grade := UPPER(p_ic_item_mst_row.qc_grade);
266: x_ic_lots_mst_row.lot_created := p_ic_item_mst_row.creation_date;
267: -- Bug 2458413 - Need to set up default dates to avoid having them
268: -- being set to the FND_API.G_MISS_DATE
269: x_ic_lots_mst_row.expire_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
270: x_ic_lots_mst_row.retest_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
271: x_ic_lots_mst_row.expaction_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
272:
273: -- Jatinder Gogna-B3158806- A row is always inserted into ic_lots_cpg
266: x_ic_lots_mst_row.lot_created := p_ic_item_mst_row.creation_date;
267: -- Bug 2458413 - Need to set up default dates to avoid having them
268: -- being set to the FND_API.G_MISS_DATE
269: x_ic_lots_mst_row.expire_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
270: x_ic_lots_mst_row.retest_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
271: x_ic_lots_mst_row.expaction_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
272:
273: -- Jatinder Gogna-B3158806- A row is always inserted into ic_lots_cpg
274: x_ic_lots_cpg_row.lot_id := 0;
267: -- Bug 2458413 - Need to set up default dates to avoid having them
268: -- being set to the FND_API.G_MISS_DATE
269: x_ic_lots_mst_row.expire_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
270: x_ic_lots_mst_row.retest_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
271: x_ic_lots_mst_row.expaction_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
272:
273: -- Jatinder Gogna-B3158806- A row is always inserted into ic_lots_cpg
274: x_ic_lots_cpg_row.lot_id := 0;
275: x_ic_lots_cpg_row.ic_matr_date := NULL;
389: x_ic_lots_mst_row.expire_date :=
390: x_ic_lots_mst_row.lot_created + NVL(p_ic_item_mst_row.shelf_life,0);
391: END IF;
392: ELSE
393: x_ic_lots_mst_row.expire_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
394: END IF;
395: ELSE
396: -- BEGIN BUG#3115930 James Bernard
397: -- Modified code so that user is now allowed to create expired lots.
422: x_ic_lots_mst_row.retest_date :=
423: x_ic_lots_mst_row.lot_created + NVL(p_ic_item_mst_row.retest_interval,0);
424: END IF;
425: ELSE
426: x_ic_lots_mst_row.retest_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
427: END IF;
428: ELSE
429: IF TRUNC(p_lot_rec.retest_date) >= TRUNC(x_ic_lots_mst_row.lot_created)
430: THEN
453: x_ic_lots_mst_row.expaction_date :=
454: x_ic_lots_mst_row.expire_date + NVL(p_ic_item_mst_row.expaction_interval,0);
455: END IF;
456: ELSE
457: x_ic_lots_mst_row.expaction_date := GMA_GLOBAL_GRP.SY$MAX_DATE;
458: END IF;
459: ELSE
460: -- BEGIN BUG#3115930 James Bernard
461: -- Modified code so that user is now allowed to create expired lots.