Line 274: FUNCTION val_item (v_item_no IN ic_item_mst.item_no%TYPE)
270: | 10/22/97 Kenny Jiang created |
271: | |
272: =========================================================================*/
273: 274: FUNCTION val_item (v_item_no IN ic_item_mst.item_no%TYPE) 275: RETURN BOOLEAN
276: IS
277: err_num NUMBER;
278: err_msg VARCHAR2(100);
Line 283: FROM ic_item_mst
279: v_dummy NUMBER;
280:
281: CURSOR item_cur IS
282: SELECT 1 283: FROM ic_item_mst 284: WHERE item_no = v_item_no;
285:
286: BEGIN
287: OPEN item_cur;