1 PACKAGE BODY GMICOMN AS
2 /* $Header: GMICOMNB.pls 115.2 2004/01/16 10:21:24 gmangari noship $ */
3 /*
4 +==========================================================================+
5 | Copyright (c) 1998 Oracle Corporation |
6 | Redwood Shores, CA, USA |
7 | All rights reserved. |
8 +==========================================================================+
9 | FILE NAME |
10 | GMICOMNB.pls |
11 | |
12 | PACKAGE NAME |
13 | GMICOMN |
14 | |
15 | DESCRIPTION |
16 | Created this new package to be used for common procedures |
17 | or functions that are used by the forms. |
18 | |
19 | CONTENTS |
20 | |
21 | Get_Itemno |
22 | |
23 | HISTORY |
24 | N.Vikranth 06/28/2002 BUG#2314294 |
25 | Created a new Function Get_Itemno that will return the |
26 | Item_no for the Item_id. |
27 | Ramakrishna 01/08/2004 Bug#3199418 |
28 | Created a new Function Get_LotNo that will return the |
29 | Lot_no for the given Lot_id and Item_id parameters. |
30 +==========================================================================+
31 */
32
33
34 /* +=========================================================================+
35 | FUNCTION NAME |
36 | Get_Itemno |
37 | |
38 | USAGE |
39 | Used to retrieve the Item number for the Item id. |
40 | |
41 | DESCRIPTION |
42 | This procedure is used to retrieve the item number from the |
43 | IC_ITEM_MST table. |
44 | |
45 | PARAMETERS |
46 | V_Item_id IN NUMBER - Item ID |
47 | |
48 | HISTORY |
49 | Nayini Vikranth 06/28/2002 Bug#2314294 - Created this procedure. |
50 +=========================================================================+
51 */
52 FUNCTION Get_Itemno(v_item_id NUMBER)
53 RETURN VARCHAR2
54 IS
55 x_item_no VARCHAR2 (32);
56 BEGIN
57 SELECT item_no
58 INTO x_item_no
59 FROM ic_item_mst
60 WHERE item_id = v_item_id;
61 RETURN (x_item_no);
62 END get_itemno;
63
64 /* +=========================================================================+
65 | FUNCTION NAME |
66 | Get_LotNo |
67 | |
68 | USAGE |
69 | Used to retrieve the Lot number for the Item id and Lot Id |
70 | |
71 | DESCRIPTION |
72 | This procedure is used to retrieve the Lot number from the |
73 | IC_LOTS_MST table. |
74 | |
75 | PARAMETERS |
76 | V_Lot_id IN NUMBER - Lot ID | |
77 | V_Item_id IN NUMBER - Item ID |
78 | |
79 | HISTORY |
80 | Ramakrishna 01/08/2004 Bug#3199418 - Created this procedure. |
81 +=========================================================================+
82 */
83
84 FUNCTION Get_Lotno(v_lot_id NUMBER,v_Item_id Number)
85 RETURN VARCHAR2
86 IS
87 x_lot_no VARCHAR2 (32);
88 BEGIN
89 SELECT Lot_no
90 INTO x_lot_no
91 FROM ic_lots_mst
92 WHERE Item_id = v_Item_Id
93 AND Lot_id = v_lot_id;
94 RETURN (x_lot_no);
95 END get_Lotno;
96
97
98 END GMICOMN;