PACKAGE BODY: APPS.GMF_OPM_ITEM

Source

1 PACKAGE BODY GMF_OPM_ITEM AS
2 /* $Header: gmfopmib.pls 120.1 2005/10/06 11:15:10 jsrivast noship $ */
3 	FUNCTION CHECK_OPM_ITEM    (p_item_no	in 	mtl_system_items.segment1%TYPE)
4 		RETURN NUMBER IS
5 
6 		v_result	NUMBER;
7 	BEGIN
8 		v_result := 0;
9 		SELECT count(*) into v_result
10 		FROM ic_item_mst
11 		WHERE item_no = p_item_no;
12 
13 		IF v_result > 0 THEN
14 			RETURN 1;
15 		ELSE
16 			RETURN 0;
17 		END IF;
18 	END CHECK_OPM_ITEM;
19 END GMF_OPM_ITEM;