APPS.GML_RELEASE_SHIPMENT_PKG dependencies on IC_ITEM_MST

Line 51: CURSOR Cur_get_noninv_ind(pitem_id ic_item_mst.item_id%TYPE) IS

47: ORDER BY item_id,whse_code,lot_id,location;
48:
49:
50: /* Begin bug 1994824 - lswamy */
51: CURSOR Cur_get_noninv_ind(pitem_id ic_item_mst.item_id%TYPE) IS
52: SELECT noninv_ind
53: FROM ic_item_mst
54: WHERE item_id = pitem_id;
55: l_noninv_ind ic_item_mst.noninv_ind%TYPE;

Line 53: FROM ic_item_mst

49:
50: /* Begin bug 1994824 - lswamy */
51: CURSOR Cur_get_noninv_ind(pitem_id ic_item_mst.item_id%TYPE) IS
52: SELECT noninv_ind
53: FROM ic_item_mst
54: WHERE item_id = pitem_id;
55: l_noninv_ind ic_item_mst.noninv_ind%TYPE;
56: /* End bug 1994824 */
57:

Line 55: l_noninv_ind ic_item_mst.noninv_ind%TYPE;

51: CURSOR Cur_get_noninv_ind(pitem_id ic_item_mst.item_id%TYPE) IS
52: SELECT noninv_ind
53: FROM ic_item_mst
54: WHERE item_id = pitem_id;
55: l_noninv_ind ic_item_mst.noninv_ind%TYPE;
56: /* End bug 1994824 */
57:
58: l_counter NUMBER DEFAULT 1;
59: l_num_trans NUMBER DEFAULT 0;