1 package GMO_VBATCH_TASK_PVT AS
2 /* $Header: GMOVVTKS.pls 120.1 2007/06/21 06:17:16 rvsingh noship $ */
3
4 function is_wms_installed return varchar2;
5
6 procedure update_process_parameter
7 (
8 p_batch_no IN VARCHAR2
9 ,p_org_code IN VARCHAR2
10 ,p_validate_flexfields IN VARCHAR2
11 ,p_batchstep_no IN NUMBER
12 ,p_activity IN VARCHAR2
13 ,p_parameter IN VARCHAR2
14 ,p_process_param_rec IN fnd_table_of_varchar2_255
15 ,x_process_param_rec OUT NOCOPY fnd_table_of_varchar2_255
16 ,x_return_status OUT NOCOPY VARCHAR2
17 ,x_message_count OUT NOCOPY NUMBER
18 ,x_message_data OUT NOCOPY VARCHAR2
19 );
20
21
22 procedure setup_resource_transaction(
23 p_org_id NUMBER,
24 p_org_code VARCHAR2,
25 p_batch_id NUMBER,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_message_count OUT NOCOPY NUMBER,
28 x_message_data OUT NOCOPY VARCHAR2
29 );
30
31 procedure create_resource_transaction (
32 p_resource_transaction_rec IN fnd_table_of_varchar2_255
33 ,x_resource_transaction_rec OUT NOCOPY fnd_table_of_varchar2_255
34 ,x_return_status OUT NOCOPY VARCHAR2
35 ,x_message_count OUT NOCOPY NUMBER
36 ,x_message_data OUT NOCOPY VARCHAR2
37 );
38
39 procedure update_resource_transaction (
40 p_resource_transaction_rec IN fnd_table_of_varchar2_255
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_message_count OUT NOCOPY NUMBER
43 ,x_message_data OUT NOCOPY VARCHAR2
44 );
45
46 procedure delete_resource_transaction (
47 p_resource_transaction_rec IN fnd_table_of_varchar2_255
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_message_count OUT NOCOPY NUMBER
50 ,x_message_data OUT NOCOPY VARCHAR2
51 );
52
53 procedure save_batch (
54 p_table in number
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_message_count OUT NOCOPY NUMBER
57 ,x_message_data OUT NOCOPY VARCHAR2
58 );
59
60 procedure get_resource_txn_end_date(
61 p_start_date IN DATE
62 ,p_usage IN NUMBER
63 ,p_trans_um IN VARCHAR2
64 ,x_end_date OUT NOCOPY DATE
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_message_count OUT NOCOPY NUMBER
67 ,x_message_data OUT NOCOPY VARCHAR2
68 );
69
70 procedure get_resource_txn_usage(
71 p_start_date IN DATE
72 ,p_end_date IN DATE
73 ,p_trans_um IN VARCHAR2
74 ,x_usage OUT NOCOPY NUMBER
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_message_count OUT NOCOPY NUMBER
77 ,x_message_data OUT NOCOPY VARCHAR2
78 );
79
80 procedure convert_um (
81 p_organization_id IN NUMBER
82 ,p_inventory_item_id IN NUMBER
83 ,p_lot_number IN VARCHAR2
84 ,p_from_qty IN NUMBER
85 ,p_from_um IN VARCHAR2
86 ,p_to_um IN VARCHAR2
87 ,x_to_qty OUT NOCOPY NUMBER
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_message_count OUT NOCOPY NUMBER
90 ,x_message_data OUT NOCOPY VARCHAR2
91 );
92
93 procedure qty_within_deviation (
94 p_organization_id IN NUMBER
95 ,p_inventory_item_id IN NUMBER
96 ,p_lot_number IN NUMBER
97 ,p_qty IN NUMBER
98 ,p_um IN VARCHAR2
99 ,p_sec_qty IN NUMBER
100 ,p_sec_um IN VARCHAR2
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_message_count OUT NOCOPY NUMBER
103 ,x_message_data OUT NOCOPY VARCHAR2
104 );
105
106 procedure get_material_transactions(
107 p_organization_id IN NUMBER
108 ,p_batch_id IN NUMBER
109 ,p_material_detail_id IN NUMBER
110 ,x_mmt_cur OUT NOCOPY gme_api_grp.g_gmo_txns
111 ,x_return_status OUT NOCOPY VARCHAR2
112 ,x_message_count OUT NOCOPY NUMBER
113 ,x_message_data OUT NOCOPY VARCHAR2
114 );
115
116 procedure get_material_reservations(
117 p_organization_id IN NUMBER
118 ,p_batch_id IN NUMBER
119 ,p_material_detail_id IN NUMBER
120 ,x_res_cur OUT NOCOPY gme_api_grp.g_gmo_resvns
121 ,x_return_status OUT NOCOPY VARCHAR2
122 ,x_message_count OUT NOCOPY NUMBER
123 ,x_message_data OUT NOCOPY VARCHAR2
124 );
125
126 procedure get_material_pplots(
127 p_organization_id IN NUMBER
128 ,p_batch_id IN NUMBER
129 ,p_material_detail_id IN NUMBER
130 ,x_pplot_cur OUT NOCOPY gme_api_grp.g_gmo_pplots
131 ,x_return_status OUT NOCOPY VARCHAR2
132 ,x_message_count OUT NOCOPY NUMBER
133 ,x_message_data OUT NOCOPY VARCHAR2
134 );
135
136 procedure get_lot_transactions(
137 p_transaction_id IN NUMBER
138 ,x_lt_cur OUT NOCOPY gme_api_grp.g_gmo_lot_txns
139 ,x_return_status OUT NOCOPY VARCHAR2
140 ,x_message_count OUT NOCOPY NUMBER
141 ,x_message_data OUT NOCOPY VARCHAR2
142 );
143
144 procedure get_dispense_um(
145 p_material_detail_id IN NUMBER
146 ,x_dispense_um OUT NOCOPY VARCHAR2
147 ,x_return_status OUT NOCOPY VARCHAR2
148 ,x_message_count OUT NOCOPY NUMBER
149 ,x_message_data OUT NOCOPY VARCHAR2
150 );
151
152 procedure relieve_reservation(
153 p_reservation_id IN NUMBER
154 ,p_prim_relieve_quantity IN NUMBER
155 ,x_return_status OUT NOCOPY VARCHAR2
156 ,x_message_count OUT NOCOPY NUMBER
157 ,x_message_data OUT NOCOPY VARCHAR2
158 );
159
160 procedure relieve_pending_lot(
161 p_pending_lot_id IN NUMBER
162 ,p_quantity IN NUMBER
163 ,p_secondary_quantity IN NUMBER
164 ,x_return_status OUT NOCOPY VARCHAR2
165 ,x_message_count OUT NOCOPY NUMBER
166 ,x_message_data OUT NOCOPY VARCHAR2
167 );
168
169 procedure create_material_transaction(
170 p_mtl_txn_rec IN fnd_table_of_varchar2_255
171 ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
172 ,x_return_status OUT NOCOPY VARCHAR2
173 ,x_message_count OUT NOCOPY NUMBER
174 ,x_message_data OUT NOCOPY VARCHAR2
175 );
176
177 procedure update_material_transaction(
178 p_mtl_txn_rec IN fnd_table_of_varchar2_255
179 ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
180 ,x_return_status OUT NOCOPY VARCHAR2
181 ,x_message_count OUT NOCOPY NUMBER
182 ,x_message_data OUT NOCOPY VARCHAR2
183 );
184
185 procedure delete_material_transaction(
186 p_mtl_txn_rec IN fnd_table_of_varchar2_255
187 ,p_mtl_lot_rec IN fnd_table_of_varchar2_255
188 ,x_return_status OUT NOCOPY VARCHAR2
189 ,x_message_count OUT NOCOPY NUMBER
190 ,x_message_data OUT NOCOPY VARCHAR2
191 );
192
193 procedure create_lot(
194 p_lot_rec IN fnd_table_of_varchar2_255
195 ,x_return_status OUT NOCOPY VARCHAR2
196 ,x_message_count OUT NOCOPY NUMBER
197 ,x_message_data OUT NOCOPY VARCHAR2
198 );
199
200 procedure generate_lot(
201 p_organization_id IN NUMBER
202 ,p_inventory_item_id IN NUMBER
203 ,x_lot_number OUT NOCOPY VARCHAR2
204 ,x_return_status OUT NOCOPY VARCHAR2
205 ,x_message_count OUT NOCOPY NUMBER
206 ,x_message_data OUT NOCOPY VARCHAR2
207 );
208
209 procedure get_lot_event_key (
210 p_organization_id IN NUMBER
211 ,p_inventory_item_id IN NUMBER
212 ,p_lot_number IN VARCHAR2
213 ,x_lot_event_key OUT NOCOPY VARCHAR2
214 );
215
216 end GMO_VBATCH_TASK_PVT;
[Home] [Help]