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.GMIVQTY dependencies on IC_LOTS_MST

Line 104: , p_lot_id IN ic_lots_mst.lot_id%TYPE

100: +=========================================================================+
101: */
102: FUNCTION Check_unposted_jnl_lot_status
103: ( p_item_id IN ic_item_mst.item_id%TYPE
104: , p_lot_id IN ic_lots_mst.lot_id%TYPE
105: , p_whse_code IN ic_whse_mst.whse_code%TYPE
106: , p_location IN ic_loct_mst.location%TYPE
107: , p_lot_status IN ic_lots_sts.lot_status%TYPE
108: )

Line 184: , p_lot_id IN ic_lots_mst.lot_id%TYPE

180: +=========================================================================+
181: */
182: FUNCTION Check_unposted_jnl_qc_grade
183: ( p_item_id IN ic_item_mst.item_id%TYPE
184: , p_lot_id IN ic_lots_mst.lot_id%TYPE
185: , p_qc_grade IN qc_grad_mst.qc_grade%TYPE
186: )
187: RETURN BOOLEAN
188: IS

Line 479: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE

475: , p_validation_level IN NUMBER
476: , p_qty_rec IN GMIGAPI.qty_rec_typ
477: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
478: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
479: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
480: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
481: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE
482: , x_ic_adjs_jnl_row1 OUT NOCOPY ic_adjs_jnl%ROWTYPE
483: , x_ic_adjs_jnl_row2 OUT NOCOPY ic_adjs_jnl%ROWTYPE

Line 523: AND lot_id = p_ic_lots_mst_row.lot_id;

519: CURSOR Cur_get_onhand_for_grade IS
520: SELECT sum(loct_onhand),sum(loct_onhand2)
521: FROM ic_loct_inv
522: WHERE item_id = p_ic_item_mst_row.item_id
523: AND lot_id = p_ic_lots_mst_row.lot_id;
524:
525: --BEGIN BUG#3171345
526: CURSOR Cur_get_status IS
527: SELECT lot_status

Line 690: OR p_ic_lots_mst_row.delete_mark = 1

686:
687: IF p_ic_item_mst_row.lot_ctl > 0
688: THEN
689: IF NVL(l_qty_rec.lot_no,GMIGUTL.IC$DEFAULT_LOT)=GMIGUTL.IC$DEFAULT_LOT
690: OR p_ic_lots_mst_row.delete_mark = 1
691: OR p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
692: THEN
693: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
694: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);

Line 691: OR p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0

687: IF p_ic_item_mst_row.lot_ctl > 0
688: THEN
689: IF NVL(l_qty_rec.lot_no,GMIGUTL.IC$DEFAULT_LOT)=GMIGUTL.IC$DEFAULT_LOT
690: OR p_ic_lots_mst_row.delete_mark = 1
691: OR p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
692: THEN
693: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
694: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_qty_rec.item_no);
695: FND_MESSAGE.SET_TOKEN('LOT_NO',l_qty_rec.lot_no);

Line 818: IF l_qty_rec.qc_grade <> p_ic_lots_mst_row.qc_grade

814: /* transactions we default it from the lot master. */
815:
816: IF (l_trans_type IN (5,10))
817: THEN
818: IF l_qty_rec.qc_grade <> p_ic_lots_mst_row.qc_grade
819: THEN
820: IF GMIGUTL.v_qc_grade(l_qty_rec.qc_grade, l_qc_grad_mst_row)
821: THEN
822: /* Check for unposted journals with different QC grade */

Line 825: , p_lot_id => p_ic_lots_mst_row.lot_id

821: THEN
822: /* Check for unposted journals with different QC grade */
823: IF Check_unposted_jnl_qc_grade
824: ( p_item_id => p_ic_item_mst_row.item_id
825: , p_lot_id => p_ic_lots_mst_row.lot_id
826: , p_qc_grade => l_qty_rec.qc_grade
827: )
828: THEN
829: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_QC_GRADE');

Line 851: l_qty_rec.qc_grade :=p_ic_lots_mst_row.qc_grade;

847: FND_MSG_PUB.Add;
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: ELSE
851: l_qty_rec.qc_grade :=p_ic_lots_mst_row.qc_grade;
852: END IF;
853:
854:
855:

Line 962: , p_lot_id =>p_ic_lots_mst_row.lot_id

958: THEN
959: GMIGUTL.get_loct_inv
960: ( p_item_id => p_ic_item_mst_row.item_id
961: , p_whse_code =>l_qty_rec.from_whse_code
962: , p_lot_id =>p_ic_lots_mst_row.lot_id
963: , p_location =>l_qty_rec.from_location
964: , x_ic_loct_inv_row =>l_ic_loct_inv_row_from
965: );
966: /* *************************************************************

Line 979: , p_lot_id =>p_ic_lots_mst_row.lot_id

975: THEN
976: GMIGUTL.get_loct_inv
977: ( p_item_id => p_ic_item_mst_row.item_id
978: , p_whse_code =>l_qty_rec.from_whse_code
979: , p_lot_id =>p_ic_lots_mst_row.lot_id
980: , p_location =>l_qty_rec.from_location
981: , x_ic_loct_inv_row =>l_ic_loct_inv_row_from
982: );
983: GMIGUTL.get_loct_inv

Line 986: , p_lot_id =>p_ic_lots_mst_row.lot_id

982: );
983: GMIGUTL.get_loct_inv
984: ( p_item_id => p_ic_item_mst_row.item_id
985: , p_whse_code =>l_qty_rec.to_whse_code
986: , p_lot_id =>p_ic_lots_mst_row.lot_id
987: , p_location =>l_qty_rec.to_location
988: , x_ic_loct_inv_row =>l_ic_loct_inv_row_to
989: );
990: ELSIF l_trans_type IN (5,10) THEN

Line 1014: l_original_qc_grade := p_ic_lots_mst_row.qc_grade;

1010:
1011: /* Hang onto original status and grade as we'll need them */
1012: /* when we set up the output journal rows */
1013:
1014: l_original_qc_grade := p_ic_lots_mst_row.qc_grade;
1015: l_original_lot_status := l_ic_loct_inv_row_from.lot_status;
1016:
1017: IF l_trans_type IN (1,6)
1018: THEN

Line 1043: l_qty_rec.qc_grade := p_ic_lots_mst_row.qc_grade;

1039: l_qty_rec.lot_status := p_ic_item_mst_row.lot_status;
1040: l_qty_rec.qc_grade := p_ic_item_mst_row.qc_grade;
1041: ELSE
1042: l_qty_rec.lot_status := l_ic_loct_inv_row_from.lot_status;
1043: l_qty_rec.qc_grade := p_ic_lots_mst_row.qc_grade;
1044: END IF;
1045: ELSIF l_trans_type IN (3,8)
1046: THEN
1047: /* If moving stock then there should be some at the source but */

Line 1154: , p_lot_id => p_ic_lots_mst_row.lot_id

1150: END If;
1151: /* Check for unposted journals with different lot status */
1152: IF Check_unposted_jnl_lot_status
1153: ( p_item_id => p_ic_item_mst_row.item_id
1154: , p_lot_id => p_ic_lots_mst_row.lot_id
1155: , p_whse_code => l_qty_rec.from_whse_code
1156: , p_location => l_qty_rec.from_location
1157: , p_lot_status => l_qty_rec.lot_status
1158: )

Line 1212: , plot_id =>p_ic_lots_mst_row.lot_id

1208: l_qty_rec.trans_qty := 0 - l_qty_rec.trans_qty;
1209: END IF;
1210: l_qty_rec.trans_qty :=GMICUOM.uom_conversion
1211: ( pitem_id =>p_ic_item_mst_row.item_id
1212: , plot_id =>p_ic_lots_mst_row.lot_id
1213: , pcur_qty =>l_qty_rec.trans_qty
1214: , pcur_uom =>l_qty_rec.item_um
1215: , pnew_uom =>p_ic_item_mst_row.item_um
1216: , patomic =>0

Line 1257: , plot_id =>p_ic_lots_mst_row.lot_id

1253: l_check_deviation := 0;
1254: ELSE
1255: l_qty2 := GMICUOM.uom_conversion
1256: ( pitem_id =>p_ic_item_mst_row.item_id
1257: , plot_id =>p_ic_lots_mst_row.lot_id
1258: , pcur_qty =>l_qty_rec.trans_qty
1259: , pcur_uom =>p_ic_item_mst_row.item_um
1260: , pnew_uom =>p_ic_item_mst_row.item_um2
1261: , patomic =>0

Line 1284: , plot_id =>p_ic_lots_mst_row.lot_id

1280: l_check_deviation := 0;
1281: ELSE
1282: l_qty2 := GMICUOM.uom_conversion
1283: ( pitem_id =>p_ic_item_mst_row.item_id
1284: , plot_id =>p_ic_lots_mst_row.lot_id
1285: , pcur_qty =>l_qty_rec.trans_qty
1286: , pcur_uom =>p_ic_item_mst_row.item_um
1287: , pnew_uom =>p_ic_item_mst_row.item_um2
1288: , patomic =>0

Line 1307: , plot_id =>p_ic_lots_mst_row.lot_id

1303: l_qty_rec.trans_qty := 0 - l_qty_rec.trans_qty;
1304: END IF;
1305: l_qty2 :=GMICUOM.uom_conversion
1306: ( pitem_id =>p_ic_item_mst_row.item_id
1307: , plot_id =>p_ic_lots_mst_row.lot_id
1308: , pcur_qty =>l_qty_rec.trans_qty
1309: , pcur_uom =>p_ic_item_mst_row.item_um
1310: , pnew_uom =>p_ic_item_mst_row.item_um2
1311: , patomic =>0

Line 1352: , plot_id =>p_ic_lots_mst_row.lot_id

1348: l_qty_rec.trans_qty2 := 0 - l_qty_rec.trans_qty2;
1349: END IF;
1350: l_qty_rec.trans_qty2 :=GMICUOM.uom_conversion
1351: ( pitem_id =>p_ic_item_mst_row.item_id
1352: , plot_id =>p_ic_lots_mst_row.lot_id
1353: , pcur_qty =>l_qty_rec.trans_qty2
1354: , pcur_uom =>l_qty_rec.item_um2
1355: , pnew_uom =>p_ic_item_mst_row.item_um2
1356: , patomic =>0

Line 1430: AND a.lot_id = nvl(p_ic_lots_mst_row.lot_id,0)

1426: AND j.journal_no = nvl(l_qty_rec.journal_no,GMIGAPI.prev_journal_no)
1427: AND a.journal_id = j.journal_id
1428: AND a.line_type <> -1
1429: AND a.item_id = p_ic_item_mst_row.item_id
1430: AND a.lot_id = nvl(p_ic_lots_mst_row.lot_id,0)
1431: AND a.whse_code = l_qty_rec.from_whse_code
1432: AND a.location = nvl(l_qty_rec.from_location,GMIGUTL.IC$DEFAULT_LOCT);
1433: END IF;-- ( (l_trans_type IN (7,8))
1434: -- Bug 2946031

Line 1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;

1604: x_ic_adjs_jnl_row1.doc_date := l_qty_rec.trans_date;
1605: x_ic_adjs_jnl_row1.item_id := p_ic_item_mst_row.item_id;
1606: x_ic_adjs_jnl_row1.item_um := l_qty_rec.item_um;
1607: x_ic_adjs_jnl_row1.item_um2 := l_qty_rec.item_um2;
1608: x_ic_adjs_jnl_row1.lot_id := p_ic_lots_mst_row.lot_id;
1609: x_ic_adjs_jnl_row1.location := l_qty_rec.from_location;
1610: IF l_qty_rec.txn_type IN ('CRE','ADJ') OR l_trans_code IN ('STSR','GRDR')
1611: THEN
1612: x_ic_adjs_jnl_row1.qty := NVL(l_qty_rec.trans_qty,0);