APPS.GMIVLOT dependencies on IC_ITEM_CPG

Line 27: | p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE |

23: | p_api_version IN NUMBER - Api Version |
24: | p_validation_level IN VARCHAR2 - Validation Level Indicator |
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 |

Line 94: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE

90: ( p_api_version IN NUMBER
91: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
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

Line 541: IF p_ic_item_cpg_row.ic_hold_days is not NULL and GMIGUTL.SY$CPG_INSTALL <> 0 THEN

537: THEN
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;

Line 544: p_ic_item_cpg_row.ic_hold_days;

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
547: IF (p_lot_rec.ic_hold_date < x_ic_lots_mst_row.lot_created)
548: THEN

Line 565: x_ic_lots_mst_row.creation_date + NVL(p_ic_item_cpg_row.ic_matr_days, 0);

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
569: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_MATR_DATE');