21: ) ;
22:
23: FUNCTION Validate_Cost_Mthd_Code
24: (
25: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
26: )
27: RETURN BOOLEAN;
28:
29: PROCEDURE Validate_cost_mthd_code
72: RETURN BOOLEAN;
73:
74: FUNCTION Validate_Item_Id
75: (
76: p_Item_Id IN ic_item_mst.Item_Id%TYPE
77: )
78: RETURN BOOLEAN;
79:
80: PROCEDURE Validate_Item_Id
78: RETURN BOOLEAN;
79:
80: PROCEDURE Validate_Item_Id
81: (
82: p_Item_Id IN ic_item_mst.Item_Id%TYPE
83: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
84: );
85:
86: FUNCTION Validate_Item_No
79:
80: PROCEDURE Validate_Item_Id
81: (
82: p_Item_Id IN ic_item_mst.Item_Id%TYPE
83: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
84: );
85:
86: FUNCTION Validate_Item_No
87: (
84: );
85:
86: FUNCTION Validate_Item_No
87: (
88: p_Item_No IN ic_item_mst.Item_No%TYPE
89: )
90: RETURN NUMBER;
91:
92: PROCEDURE Validate_Item_No
90: RETURN NUMBER;
91:
92: PROCEDURE Validate_Item_No
93: (
94: p_Item_No IN ic_item_mst.Item_No%TYPE
95: , x_Item_Id OUT NOCOPY ic_item_mst.Item_Id%TYPE
96: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
97: );
98:
91:
92: PROCEDURE Validate_Item_No
93: (
94: p_Item_No IN ic_item_mst.Item_No%TYPE
95: , x_Item_Id OUT NOCOPY ic_item_mst.Item_Id%TYPE
96: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
97: );
98:
99: FUNCTION Validate_Itemcost_Class
92: PROCEDURE Validate_Item_No
93: (
94: p_Item_No IN ic_item_mst.Item_No%TYPE
95: , x_Item_Id OUT NOCOPY ic_item_mst.Item_Id%TYPE
96: , x_Item_UM OUT NOCOPY ic_item_mst.Item_UM%TYPE
97: );
98:
99: FUNCTION Validate_Itemcost_Class
100: (
97: );
98:
99: FUNCTION Validate_Itemcost_Class
100: (
101: p_itemcost_class IN ic_item_mst.itemcost_class%TYPE
102: )
103: RETURN BOOLEAN;
104:
105: FUNCTION Validate_Cost_Cmpntcls_Id
187: );
188:
189: FUNCTION VALIDATE_LOT_ID
190: (
191: p_item_id IN ic_item_mst.item_id%TYPE
192: , p_lot_no IN ic_lots_mst.lot_no%TYPE
193: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
194: )
195: RETURN NUMBER;
195: RETURN NUMBER;
196:
197: FUNCTION VALIDATE_LOT_ID
198: (
199: p_item_id IN ic_item_mst.item_id%TYPE
200: , p_lot_id IN ic_lots_mst.lot_id%TYPE
201: )
202: RETURN BOOLEAN;
203:
202: RETURN BOOLEAN;
203:
204: FUNCTION VALIDATE_LOT_NO
205: (
206: p_item_id IN ic_item_mst.item_id%TYPE
207: , p_lot_no IN ic_lots_mst.lot_no%TYPE
208: , p_sublot_no IN ic_lots_mst.sublot_no%TYPE
209: )
210: RETURN BOOLEAN;
294: RETURN BOOLEAN;
295:
296: FUNCTION Validate_Lot_Cost_Mthd_Code
297: (
298: p_cost_mthd_code IN ic_item_mst.cost_mthd_code%TYPE
299: )
300: RETURN BOOLEAN;
301:
302: FUNCTION Validate_Lot_Cost_Type