APPS.GML_MOBILE_RECEIPT dependencies on IC_LOTS_MST

Line 246: from ic_lots_mst a, ic_item_mst b

242:
243:
244: OPEN x_lot_lov FOR
245: select a.lot_no,a.sublot_no,a.expire_date,a.lot_id
246: from ic_lots_mst a, ic_item_mst b
247: where a.item_id= p_item_id
248: and a.lot_id <> 0
249: and a.lot_no like (p_lot_no)
250: and a.delete_mark=0

Line 265: from ic_lots_mst

261: BEGIN
262:
263: OPEN x_sublot_lov FOR
264: select sublot_no ,expire_date,lot_id
265: from ic_lots_mst
266: where item_id= p_item_id
267: and lot_no = p_lot_no
268: and sublot_no like (p_sublot_no)
269: and lot_id <>0

Line 546: l_ic_lots_mst_row ic_lots_mst%ROWTYPE;

542:
543: l_lot_rec GMIGAPI.lot_rec_typ;
544: l_msg_count NUMBER;
545: l_msg_data VARCHAR2(2000);
546: l_ic_lots_mst_row ic_lots_mst%ROWTYPE;
547: l_ic_lots_cpg_row ic_lots_cpg%ROWTYPE;
548:
549: BEGIN
550:

Line 573: , x_ic_lots_mst_row => l_ic_lots_mst_row

569: , p_init_msg_list => 'T'
570: , p_commit => 'F'
571: , p_validation_level => 100
572: , p_lot_rec => l_lot_rec
573: , x_ic_lots_mst_row => l_ic_lots_mst_row
574: , x_ic_lots_cpg_row => l_ic_lots_cpg_row
575: , x_return_status => x_return_status
576: , x_msg_count => l_msg_count
577: , x_msg_data => l_msg_data

Line 586: x_lot_id := l_ic_lots_mst_row.lot_id;

582: dbms_output.put_line('error in API = '||l_msg_data);
583: dbms_output.put_line('error in API count= '||l_msg_count);
584: */
585: IF (x_return_status = 'S') THEN
586: x_lot_id := l_ic_lots_mst_row.lot_id;
587: ELSE
588: For I IN 1..l_msg_count LOOP
589: l_msg_data := fnd_msg_pub.get(I,'F');
590: -- FND_MESSAGE.SET_STRING (x_msg_data);

Line 3202: FROM ic_lots_mst

3198: Where ilm.item_no = p_item_no;
3199:
3200: CURSOR Get_Lot_Id (p_item_id NUMBER) IS
3201: SELECT lot_id
3202: FROM ic_lots_mst
3203: WHERE item_id = p_item_id AND
3204: lot_no = p_lot_no;
3205:
3206: CURSOR Get_LotSubLot_Id (p_item_id NUMBER) IS

Line 3208: FROM ic_lots_mst

3204: lot_no = p_lot_no;
3205:
3206: CURSOR Get_LotSubLot_Id (p_item_id NUMBER) IS
3207: SELECT lot_id
3208: FROM ic_lots_mst
3209: WHERE item_id = p_item_id AND
3210: lot_no = p_lot_no AND
3211: sublot_no = p_sublot_no;
3212: BEGIN