DBA Data[Home] [Help]

APPS.GMI_LOTS_PUB dependencies on IC_ITEM_CPG

Line 102: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;

98: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
99: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
100: l_lot_rec lot_rec_typ;
101: l_po_vend_mst_rec po_vend_mst%ROWTYPE;
102: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
103:
104: BEGIN
105:
106: -- Standard Start OF API savepoint

Line 167: , x_ic_item_cpg => l_ic_item_cpg_rec

163: -- Get item details
164:
165: GMI_GLOBAL_GRP.Get_Item ( p_item_no => l_lot_rec.item_no
166: , x_ic_item_mst => l_ic_item_mst_rec
167: , x_ic_item_cpg => l_ic_item_cpg_rec
168: );
169:
170: IF (l_ic_item_mst_rec.item_id < 0)
171: THEN

Line 197: IF l_ic_item_cpg_rec.ic_hold_days IS NULL

193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195:
196: -- Set up defaults for hold and maturity days
197: IF l_ic_item_cpg_rec.ic_hold_days IS NULL
198: THEN
199: l_ic_item_cpg_rec.ic_hold_days :=0;
200: END IF;
201:

Line 199: l_ic_item_cpg_rec.ic_hold_days :=0;

195:
196: -- Set up defaults for hold and maturity days
197: IF l_ic_item_cpg_rec.ic_hold_days IS NULL
198: THEN
199: l_ic_item_cpg_rec.ic_hold_days :=0;
200: END IF;
201:
202: IF l_ic_item_cpg_rec.ic_matr_days IS NULL
203: THEN

Line 202: IF l_ic_item_cpg_rec.ic_matr_days IS NULL

198: THEN
199: l_ic_item_cpg_rec.ic_hold_days :=0;
200: END IF;
201:
202: IF l_ic_item_cpg_rec.ic_matr_days IS NULL
203: THEN
204: l_ic_item_cpg_rec.ic_matr_days :=0;
205: END IF;
206:

Line 204: l_ic_item_cpg_rec.ic_matr_days :=0;

200: END IF;
201:
202: IF l_ic_item_cpg_rec.ic_matr_days IS NULL
203: THEN
204: l_ic_item_cpg_rec.ic_matr_days :=0;
205: END IF;
206:
207:
208: -- If creating default lot (i.e. being call from create_item API) then

Line 277: l_ic_item_cpg_rec.ic_matr_days;

273: -- Ic_Matr_Date
274: IF (l_lot_rec.ic_matr_date IS NULL)
275: THEN
276: l_lot_rec.ic_matr_date := l_lot_rec.lot_created +
277: l_ic_item_cpg_rec.ic_matr_days;
278: END IF;
279:
280: -- Ic_Hold_Date
281: IF (l_lot_rec.ic_hold_date IS NULL)

Line 284: l_ic_item_cpg_rec.ic_hold_days;

280: -- Ic_Hold_Date
281: IF (l_lot_rec.ic_hold_date IS NULL)
282: THEN
283: l_lot_rec.ic_hold_date := l_lot_rec.lot_created +
284: l_ic_item_cpg_rec.ic_hold_days;
285: END IF;
286:
287: -- Perform Validation
288: