DBA Data[Home] [Help]

APPS.GMIVLOT dependencies on GMA_GLOBAL_GRP

Line 269: x_ic_lots_mst_row.expire_date := GMA_GLOBAL_GRP.SY$MAX_DATE;

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

Line 270: x_ic_lots_mst_row.retest_date := GMA_GLOBAL_GRP.SY$MAX_DATE;

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;

Line 271: x_ic_lots_mst_row.expaction_date := GMA_GLOBAL_GRP.SY$MAX_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;
275: x_ic_lots_cpg_row.ic_matr_date := NULL;

Line 393: x_ic_lots_mst_row.expire_date := GMA_GLOBAL_GRP.SY$MAX_DATE;

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.

Line 426: x_ic_lots_mst_row.retest_date := GMA_GLOBAL_GRP.SY$MAX_DATE;

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

Line 457: x_ic_lots_mst_row.expaction_date := GMA_GLOBAL_GRP.SY$MAX_DATE;

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.