1 PACKAGE GMO_DISPENSE_GRP AS
2 /* $Header: GMOGDSPS.pls 120.2.12000000.3 2007/04/17 07:18:16 achawla ship $ */
3
4
5 G_PKG_NAME CONSTANT VARCHAR2(16) := 'GMO_DISPENSE_GRP';
6
7 G_MATERIAL_LINE_ENTITY CONSTANT VARCHAR2(30) := 'MATERIAL_DETAILS_ID';
8
9 -- Start of comments
10 -- API name : MAINTAIN_RESERVATION
11 -- Type : Group.
12 -- Function : Synch the reservation ID in dispensing tables
13 -- for all dispensed and reverse dispensed rows.
14 -- Pre-reqs : None.
15 -- Parameters :
16 -- IN : p_api_version IN NUMBER Required
17 -- p_init_msg_list IN VARCHAR2 Required
18 -- p_commit IN VARCHAR2 Required
19 -- p_batch_id IN NUMBER Required
20 -- p_old_reservation_id IN NUMBER Required
21 -- p_new_reservation_id IN NUMBER Required
22 -- p_batchstep_id IN NUMBER
23 -- p_item_id IN NUMBER Required
24 -- p_material_detail_id IN NUMBER Required
25 -- .
26 -- OUT : x_return_status OUT VARCHAR2(1)
27 -- x_msg_count OUT NUMBER
28 -- x_msg_data OUT VARCHAR2(2000)
29 -- .
30 -- Version : Current version 1.0
31 -- Initial version 1.0
32 --
33 -- End of comments
34
35 PROCEDURE MAINTAIN_RESERVATION(p_api_version NUMBER,
36 p_init_msg_list IN VARCHAR2,
37 p_commit IN VARCHAR2,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2,
41 p_batch_id NUMBER,
42 p_old_reservation_id NUMBER,
43 p_new_reservation_id NUMBER,
44 p_batchstep_id NUMBER,
45 p_item_id NUMBER,
46 p_material_detail_id NUMBER
47 );
48
49 -- Start of comments
50 -- API name : CHANGE_DISPENSE_STATUS
51 -- Type : Group.
52 -- Function : To mark the dispensed rows as 'consumed' or not consumed
53 -- rows to 'only for reverse dispense' or consumed rows
54 -- as 'not consumed. This API gets called by GME material
55 -- transaction.
56 -- Pre-reqs : None.
57 -- Parameters :
58 -- IN : p_api_version IN NUMBER Required
59 -- p_init_msg_list IN VARCHAR2 Required
60 -- p_commit IN VARCHAR2 Required
61 -- p_dispense_id IN NUMBER Required
62 -- p_status_code IN VARCHAR2 Required
63 -- p_transaction_id IN NUMBER Required
64 -- .
65 -- OUT : x_return_status OUT VARCHAR2(1)
66 -- x_msg_count OUT NUMBER
67 -- x_msg_data OUT VARCHAR2(2000)
68 -- .
69 -- Version : Current version 1.0
70 -- Initial version 1.0
71 --
72 -- End of comments
73
74 PROCEDURE CHANGE_DISPENSE_STATUS(p_api_version NUMBER,
75 p_init_msg_list IN VARCHAR2,
76 p_commit IN VARCHAR2,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_dispense_id NUMBER,
81 p_status_code VARCHAR2,
82 p_transaction_id NUMBER
83 );
84
85 -- Start of comments
86 -- API name : IS_DISPENSE_ITEM
87 -- Type : Group.
88 -- Function : To check if dispense setup is configured
89 -- as dispense required for given item , item - org
90 -- and item-org-recipe level.
91 -- Pre-reqs : None.
92 -- Parameters :
93 -- IN : p_api_version IN NUMBER Required
94 -- p_init_msg_list IN VARCHAR2 Required
95 -- p_inventory_item_id IN NUMBER Required
96 -- p_organization_id IN NUMBER Required
97 -- p_recipe_id IN NUMBER Required
98 -- .
99 -- OUT : x_return_status OUT VARCHAR2(1)
100 -- x_msg_count OUT NUMBER
101 -- x_msg_data OUT VARCHAR2(2000)
102 -- x_dispense_required OUT VARHCHAR2(1)
103 -- x_dispense_config_id OUT NUMBER
104 -- .
105 -- Version : Current version 1.0
106 -- Initial version 1.0
107 --
108 -- Note : x_dispense_required will either be FND_API.G_TRUE
109 -- or FND_API.G_FALSE.
110 -- End of comments
111 PROCEDURE IS_DISPENSE_ITEM (p_api_version NUMBER,
112 p_init_msg_list IN VARCHAR2,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_inventory_item_id NUMBER,
117 p_organization_id NUMBER,
118 p_recipe_id NUMBER,
119 x_dispense_required OUT NOCOPY VARCHAR2,
120 x_dispense_config_id OUT NOCOPY NUMBER);
121
122
123
124 -- Start of comments
125 -- API name : GET_MATERIAL_DISPENSE_DATA
126 -- Type : Group.
127 -- Function : Returns dispensed and consumed rows for the
128 -- requested material. All the quantity data
129 -- are in dispense UOM , read from dispense setup tables.
130 -- Pre-reqs : None.
131 -- Parameters :
132 -- IN : p_api_version IN NUMBER Required
133 -- p_material_detail_id IN NUMBER Required
134 -- .
135 -- OUT : x_return_status OUT VARCHAR2(1)
136 -- x_msg_count OUT NUMBER
137 -- x_msg_data OUT VARCHAR2(2000)
138 -- x_dispense_data OUT DISPENSE_TBL_TYPE Dispense Items to be consumed.
139 -- .
140 -- Version : Current version 1.0
141 -- Initial version 1.0
142 --
143 -- End of comments
144
145 PROCEDURE GET_MATERIAL_DISPENSE_DATA (p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_material_detail_id IN NUMBER,
151 x_dispense_data OUT NOCOPY GME_COMMON_PVT.reservations_tab
152 );
153
154
155 -- Start of comments
156 -- API name : INSTANTIATE_DISPENSE_SETUP
157 -- Type : Group API
158 -- Function : This procedure is used to instantiate the dispense setup identified by the specified
159 -- dispense config ID, entity name and entity key.
160
161 -- Pre-reqs : None.
162 -- Parameters :
163 -- IN : P_API_VERSION IN NUMBER Required
164 -- P_DISPENSE_CONFIG_ID IN NUMBER The dispense config ID.
165 -- P_ENTITY_NAME IN VARCHAR2 The entity name.
166 -- P_ENTITY_KEY IN VARCHAR2 The entity key.
167 -- P_INIT_MSG_LIST IN VARCHAR2 Whether the message list should be initialized.
168 -- .
169 -- OUT : X_RETURN_STATUS OUT VARCHAR2 The return status.
170 -- X_MSG_COUNT OUT NUMBER The message count.
171 -- X_MSG_DATA OUT VARCHAR2 Error message if any.
172 -- .
173 -- Version : Current version 1.0
174 -- Initial version 1.0
175 --
176 -- End of comments
177
178 PROCEDURE INSTANTIATE_DISPENSE_SETUP
179 (P_API_VERSION IN NUMBER,
180 P_DISPENSE_CONFIG_ID IN NUMBER,
181 P_ENTITY_NAME IN VARCHAR2,
182 P_ENTITY_KEY IN VARCHAR2,
183 P_INIT_MSG_LIST IN VARCHAR2,
184 P_AUTO_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
185 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
186 X_MSG_COUNT OUT NOCOPY NUMBER,
187 X_MSG_DATA OUT NOCOPY VARCHAR2);
188
189 Function isDispenseOccuredAtDispBooth(disp_booth_id number) return varchar2;
190 Function isDispenseOccuredAtDispArea(disp_area_id number) return varchar2;
191 END GMO_DISPENSE_GRP;