APPS.GMIVQTY dependencies on SY_REAS_CDS

Line 493: l_sy_reas_cds_row sy_reas_cds%ROWTYPE;

489: l_qty_rec GMIGAPI.qty_rec_typ;
490: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
491: l_ic_loct_inv_row_from ic_loct_inv%ROWTYPE;
492: l_ic_loct_inv_row_to ic_loct_inv%ROWTYPE;
493: l_sy_reas_cds_row sy_reas_cds%ROWTYPE;
494: l_qc_grad_mst_row qc_grad_mst%ROWTYPE;
495: l_ic_lots_sts_row ic_lots_sts%ROWTYPE;
496: l_qty2 NUMBER;
497: l_onhand NUMBER;

Line 896: , x_sy_reas_cds_row=> l_sy_reas_cds_row

892: /* types and reason codes. */
893:
894: IF GMIGUTL.v_reason_code
895: ( p_reason_code => l_qty_rec.reason_code
896: , x_sy_reas_cds_row=> l_sy_reas_cds_row
897: )
898: THEN
899: IF (l_trans_type IN (1,2,3,6,7,8))
900: THEN

Line 901: IF l_sy_reas_cds_row.reason_type = 1 AND

897: )
898: THEN
899: IF (l_trans_type IN (1,2,3,6,7,8))
900: THEN
901: IF l_sy_reas_cds_row.reason_type = 1 AND
902: l_qty_rec.trans_qty < 0
903: THEN
904: FND_MESSAGE.SET_NAME('GMI','IC_API_DEC_NOT_ALLOWED');
905: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

Line 910: ELSIF l_sy_reas_cds_row.reason_type = 2 AND

906: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);
907: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_qty_rec.sublot_no);
908: FND_MSG_PUB.Add;
909: RAISE FND_API.G_EXC_ERROR;
910: ELSIF l_sy_reas_cds_row.reason_type = 2 AND
911: l_qty_rec.trans_qty > 0
912: THEN
913: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');
914: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);