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.GMIVLOT dependencies on IC_LOTS_CPG

Line 29: | x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE |

25: | p_lot_rec IN GMIGAPI.lot_rec_typ - Lot Master details |
26: | p_ic_item_mst_row IN ic_item_mst%ROWTYPE |
27: | p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE |
28: | x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE |
29: | x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE |
30: | x_return_status OUT NOCOPY VARCHAR2 - Return Status |
31: | x_msg_count OUT NOCOPY NUMBER - Number of messages |
32: | x_msg_data OUT NOCOPY VARCHAR2 - Messages in encoded format |
33: | |

Line 96: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE

92: , p_lot_rec IN GMIGAPI.lot_rec_typ
93: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
94: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
95: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
96: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
97: , x_return_status OUT NOCOPY VARCHAR2
98: , x_msg_count OUT NOCOPY NUMBER
99: , x_msg_data OUT NOCOPY VARCHAR2
100: )

Line 167: /* Set up values for ic_lots_cpg. */

163: x_ic_lots_mst_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
164: x_ic_lots_mst_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
165:
166: -- Jatinder B3158806 - Removed check for SY$CPG_INSTALL
167: /* Set up values for ic_lots_cpg. */
168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;
169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

Line 168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;

164: x_ic_lots_mst_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
165:
166: -- Jatinder B3158806 - Removed check for SY$CPG_INSTALL
167: /* Set up values for ic_lots_cpg. */
168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;
169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;

Line 169: x_ic_lots_cpg_row.lot_id := NULL;

165:
166: -- Jatinder B3158806 - Removed check for SY$CPG_INSTALL
167: /* Set up values for ic_lots_cpg. */
168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;
169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;

Line 170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;

166: -- Jatinder B3158806 - Removed check for SY$CPG_INSTALL
167: /* Set up values for ic_lots_cpg. */
168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;
169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;
174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;

Line 171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;

167: /* Set up values for ic_lots_cpg. */
168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;
169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;
174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
175:

Line 172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;

168: x_ic_lots_cpg_row.item_id := p_ic_item_mst_row.item_id;
169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;
174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
175:
176: /* Bug 2343411 - User defined lot description */

Line 173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;

169: x_ic_lots_cpg_row.lot_id := NULL;
170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;
174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
175:
176: /* Bug 2343411 - User defined lot description */
177: /* Based on the value of the profile option, populate the lot_desc */

Line 174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;

170: x_ic_lots_cpg_row.created_by := GMIGUTL.DEFAULT_USER_ID;
171: x_ic_lots_cpg_row.last_updated_by := GMIGUTL.DEFAULT_USER_ID;
172: x_ic_lots_cpg_row.creation_date:= x_ic_lots_mst_row.creation_date;
173: x_ic_lots_cpg_row.last_update_date := x_ic_lots_mst_row.last_update_date;
174: x_ic_lots_cpg_row.last_update_login:= GMIGUTL.DEFAULT_LOGIN;
175:
176: /* Bug 2343411 - User defined lot description */
177: /* Based on the value of the profile option, populate the lot_desc */
178:

Line 273: -- Jatinder Gogna-B3158806- A row is always inserted into ic_lots_cpg

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;
276: x_ic_lots_cpg_row.ic_hold_date := NULL;
277: ELSE

Line 274: x_ic_lots_cpg_row.lot_id := 0;

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;
276: x_ic_lots_cpg_row.ic_hold_date := NULL;
277: ELSE
278: /* Carry out fundamental validation. These errors will prevent any */

Line 275: x_ic_lots_cpg_row.ic_matr_date := NULL;

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;
276: x_ic_lots_cpg_row.ic_hold_date := NULL;
277: ELSE
278: /* Carry out fundamental validation. These errors will prevent any */
279: /* further validation. */

Line 276: x_ic_lots_cpg_row.ic_hold_date := NULL;

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;
276: x_ic_lots_cpg_row.ic_hold_date := NULL;
277: ELSE
278: /* Carry out fundamental validation. These errors will prevent any */
279: /* further validation. */
280: IF p_ic_item_mst_row.item_id = 0 OR

Line 542: x_ic_lots_cpg_row.ic_hold_date :=

538: /* Jalaj Srivastava Bug 3158806
539: hold release date would be populated by the first yielding transaction
540: for non CPG installs */
541: IF p_ic_item_cpg_row.ic_hold_days is not NULL and GMIGUTL.SY$CPG_INSTALL <> 0 THEN
542: x_ic_lots_cpg_row.ic_hold_date :=
543: x_ic_lots_mst_row.lot_created +
544: p_ic_item_cpg_row.ic_hold_days;
545: END IF;
546: ELSE

Line 556: x_ic_lots_cpg_row.ic_hold_date := p_lot_rec.ic_hold_date;

552: x_return_status := FND_API.G_RET_STS_ERROR;
553: END IF;
554: /* Jalaj Srivastava Bug 3158806
555: Assign hold release date when passed by the user*/
556: x_ic_lots_cpg_row.ic_hold_date := p_lot_rec.ic_hold_date;
557: END IF;
558:
559: IF GMIGUTL.SY$CPG_INSTALL <> 0
560: THEN

Line 564: x_ic_lots_cpg_row.ic_matr_date :=

560: THEN
561: /* Validate Maturity date (CPG) */
562: IF NVL(p_lot_rec.ic_matr_date, FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE
563: THEN
564: x_ic_lots_cpg_row.ic_matr_date :=
565: x_ic_lots_mst_row.creation_date + NVL(p_ic_item_cpg_row.ic_matr_days, 0);
566: ELSE
567: IF (p_lot_rec.ic_matr_date < x_ic_lots_mst_row.lot_created)
568: THEN