[Home] [Help]
PACKAGE: APPS.QA_SOLUTION_DISPOSITION_PKG
Source
1 PACKAGE QA_SOLUTION_DISPOSITION_PKG AUTHID CURRENT_USER as
2 /* $Header: qasodiss.pls 120.0.12010000.4 2010/04/26 17:22:38 ntungare ship $ */
3
4
5 PROCEDURE REWORK_NEW_NONSTANDARD_JOB(
6 p_item IN VARCHAR2,
7 p_job_class IN VARCHAR2,
8 p_job_name IN VARCHAR2,
9 p_job_start IN VARCHAR2,
10 p_job_end IN VARCHAR2,
11 p_bill_reference IN VARCHAR2,
12 p_bom_revision IN VARCHAR2,
13 p_routing_reference IN VARCHAR2,
14 p_routing_revision IN VARCHAR2,
15 p_quantity IN NUMBER,
16 p_job_mrp_net_quantity IN NUMBER,
17 p_project_number IN VARCHAR2,
18 p_task_number IN VARCHAR2,
19 p_collection_id IN NUMBER,
20 p_occurrence IN NUMBER,
21 p_organization_code IN VARCHAR2,
22 p_plan_name IN VARCHAR2,
23 p_launch_action IN VARCHAR2,
24 p_action_fired IN VARCHAR2);
25
26
27 FUNCTION REWORK_NEW_NONSTANDARD_JOB_INT(
28 p_item_id NUMBER,
29 p_group_id NUMBER,
30 p_jclass VARCHAR2,
31 p_job_name VARCHAR2,
32 p_job_start DATE,
33 p_job_end DATE,
34 p_bill_id NUMBER,
35 p_bill_revision VARCHAR2,
36 p_routing_id NUMBER,
37 p_routing_revision VARCHAR2,
38 p_quantity NUMBER,
39 p_job_mrp_net_quantity NUMBER,
40 p_project_number VARCHAR2,
41 p_task_number VARCHAR2,
42 p_organization_id NUMBER)
43 RETURN NUMBER;
44
45
46
47 PROCEDURE WIP_SCRAP_WIP_MOVE(
48 p_item IN VARCHAR2,
49 p_job_name IN VARCHAR2,
50 p_scrap_alias IN VARCHAR2,
51 p_from_op_seq IN NUMBER,
52 p_from_intra_step IN VARCHAR2,
53 p_to_op_seq IN NUMBER,
54 p_to_intra_step IN VARCHAR2,
55 p_from_op_code IN VARCHAR2,
56 p_to_op_code IN VARCHAR2,
57 p_reason_code IN VARCHAR2,
58 p_uom IN VARCHAR2,
59 p_quantity IN NUMBER,
60 p_txn_date IN VARCHAR2,
61 p_collection_id IN NUMBER,
62 p_occurrence IN NUMBER,
63 p_organization_code IN VARCHAR2,
64 p_plan_name IN VARCHAR2,
65 p_launch_action IN VARCHAR2,
66 p_action_fired IN VARCHAR2);
67
68
69 FUNCTION WIP_SCRAP_WIP_MOVE_INT(
70 p_item_id NUMBER,
71 p_txn_id NUMBER,
72 p_job_name VARCHAR2,
73 p_dist_account_id NUMBER,
74 p_from_op_seq NUMBER,
75 p_from_intra_step NUMBER,
76 p_to_op_seq NUMBER,
77 p_to_intra_step NUMBER,
78 p_fm_op_code VARCHAR2 DEFAULT NULL,
79 p_to_op_code VARCHAR2 DEFAULT NULL,
80 p_reason_id NUMBER DEFAULT NULL,
81 p_uom VARCHAR2,
82 p_quantity NUMBER,
83 p_txn_date DATE,
84 p_organization_code VARCHAR2,
85 p_collection_id VARCHAR2)
86 RETURN NUMBER;
87
88
89
90 PROCEDURE INV_SCRAP_ACCOUNT_ALIAS(
91 p_item IN VARCHAR2,
92 p_revision IN VARCHAR2,
93 p_subinventory IN VARCHAR2,
94 p_locator IN VARCHAR2,
95 p_lot_number IN VARCHAR2,
96 p_serial_number IN VARCHAR2,
97 p_transaction_uom IN VARCHAR2,
98 p_transaction_qty IN NUMBER,
99 p_transaction_date IN VARCHAR2,
100 p_inv_acc_alias IN VARCHAR2,
101 p_collection_id IN NUMBER,
102 p_occurrence IN NUMBER,
103 p_organization_code IN VARCHAR2,
104 p_plan_name IN VARCHAR2,
105 p_launch_action IN VARCHAR2,
106 p_action_fired IN VARCHAR2);
107
108
109
110 FUNCTION INV_SCRAP_ACCOUNT_ALIAS_INT(
111 p_item_id NUMBER,
112 p_revision VARCHAR2,
113 p_subinventory VARCHAR2,
114 p_locator_id NUMBER,
115 p_lot_number VARCHAR2,
116 p_serial_number VARCHAR2,
117 p_transaction_uom VARCHAR2,
118 p_transaction_qty NUMBER,
119 p_transaction_date DATE,
120 p_disposition_id NUMBER,
121 p_collection_id NUMBER,
122 p_occurrence NUMBER,
123 p_organization_id NUMBER)
124 RETURN NUMBER;
125
126 --
127 -- bug 9652549 CLM changes
128 --
129 PROCEDURE PO_RETURN_TO_VENDOR(
130 p_item IN VARCHAR2,
131 p_revision IN VARCHAR2,
132 p_subinventory IN VARCHAR2,
133 p_locator IN VARCHAR2,
134 p_lot_number IN VARCHAR2,
135 p_serial_number IN VARCHAR2,
136 p_uom_code IN VARCHAR2,
137 p_quantity IN NUMBER,
138 p_po_number IN VARCHAR2,
139 p_po_line_number IN VARCHAR2,
140 p_po_shipment_number IN NUMBER,
141 p_po_receipt_number IN NUMBER,
142 p_transaction_date IN VARCHAR2,
143 p_collection_id IN NUMBER,
144 p_occurrence IN NUMBER,
145 p_plan_name IN VARCHAR2,
146 p_organization_code IN VARCHAR2,
147 p_launch_action IN VARCHAR2,
148 p_action_fired IN VARCHAR2);
149
150
151 --
152 -- bug 9652549 CLM changes
153 --
154 FUNCTION PO_RETURN_TO_VENDOR_INT(
155 p_item_id IN NUMBER,
156 p_revision IN VARCHAR2,
157 p_subinventory IN VARCHAR2,
158 p_locator_id IN NUMBER ,
159 p_lot_number IN VARCHAR2,
160 p_serial_number IN VARCHAR2,
161 p_uom_code IN VARCHAR2,
162 p_quantity IN NUMBER,
163 p_po_number IN VARCHAR2,
164 p_po_line_number IN VARCHAR2,
165 p_po_shipment_number IN NUMBER,
166 p_po_receipt_number IN NUMBER,
167 p_transaction_date IN DATE,
168 p_collection_id IN NUMBER,
169 p_occurrence IN NUMBER,
170 p_plan_id IN NUMBER,
171 p_organization_id IN NUMBER,
172 p_interface_transaction_id IN NUMBER)
173 RETURN NUMBER;
174
175
176 PROCEDURE INV_CREATE_MOVE_ORDER (
177 p_item IN VARCHAR2,
178 p_revision IN VARCHAR2,
179 p_from_subinventory IN VARCHAR2,
180 p_from_locator IN VARCHAR2,
181 p_lot_number IN VARCHAR2,
182 p_serial_number IN VARCHAR2,
183 p_uom_code IN VARCHAR2,
184 p_quantity IN NUMBER,
185 p_to_subinventory IN VARCHAR2,
186 p_to_locator IN VARCHAR2,
187 p_date_required IN VARCHAR2,
188 p_project_number IN VARCHAR2,
189 p_task_number IN VARCHAR2,
190 p_collection_id IN NUMBER,
191 p_occurrence IN NUMBER,
192 p_plan_name IN VARCHAR2,
193 p_organization_code IN VARCHAR2,
194 p_launch_action IN VARCHAR2,
195 p_action_fired IN VARCHAR2 );
196
197
198 FUNCTION INV_CREATE_MOVE_ORDER_INT (
199 p_item_id IN NUMBER,
200 p_revision IN VARCHAR2,
201 p_from_subinventory IN VARCHAR2,
202 p_from_locator_id IN NUMBER,
203 p_lot_number IN VARCHAR2,
204 p_serial_number IN VARCHAR2,
205 p_uom_code IN VARCHAR2,
206 p_quantity IN NUMBER,
207 p_to_subinventory IN VARCHAR2,
208 p_to_locator_id IN NUMBER,
209 p_date_required IN DATE,
210 p_project_id IN NUMBER,
211 p_task_id IN NUMBER,
212 p_organization_id IN NUMBER,
213 x_request_number OUT NOCOPY VARCHAR2)
214 RETURN VARCHAR2;
215
216
217 PROCEDURE WIP_COMP_RETURN(
218 p_job_name IN VARCHAR2,
219 p_item IN VARCHAR2,
220 p_revision IN VARCHAR2,
221 p_subinventory IN VARCHAR2,
222 p_locator IN VARCHAR2,
223 p_lot_number IN VARCHAR2,
224 p_serial_number IN VARCHAR2,
225 p_transaction_uom IN VARCHAR2,
226 p_transaction_qty IN NUMBER,
227 p_transaction_date IN VARCHAR2,
228 p_op_seq_num IN NUMBER,
229 p_reason_code IN VARCHAR2,
230 p_collection_id IN NUMBER,
231 p_occurrence IN NUMBER,
232 p_organization_code IN VARCHAR2,
233 p_plan_name IN VARCHAR2,
234 p_launch_action IN VARCHAR2,
235 p_action_fired IN VARCHAR2);
236
237
238
239 PROCEDURE WIP_COMP_ISSUE (
240 p_job_name IN VARCHAR2,
241 p_item IN VARCHAR2,
242 p_revision IN VARCHAR2,
243 p_subinventory IN VARCHAR2,
244 p_locator IN VARCHAR2,
245 p_lot_number IN VARCHAR2,
246 p_serial_number IN VARCHAR2,
247 p_transaction_uom IN VARCHAR2,
248 p_transaction_qty IN NUMBER,
249 p_transaction_date IN VARCHAR2,
250 p_op_seq_num IN NUMBER,
251 p_reason_code IN VARCHAR2,
252 p_collection_id IN NUMBER,
253 p_occurrence IN NUMBER,
254 p_organization_code IN VARCHAR2,
255 p_plan_name IN VARCHAR2,
256 p_launch_action IN VARCHAR2,
257 p_action_fired IN VARCHAR2);
258
259
260 FUNCTION WIP_MATERIAL_TXN_INT(
261 p_job_name VARCHAR2,
262 p_item_id NUMBER,
263 p_revision VARCHAR2,
264 p_subinventory VARCHAR2,
265 p_locator_id NUMBER,
266 p_lot_number VARCHAR2,
267 p_serial_number VARCHAR2,
268 p_transaction_uom VARCHAR2,
269 p_transaction_qty NUMBER,
270 p_transaction_date DATE,
271 p_op_seq_num NUMBER,
272 p_reason_id NUMBER,
273 p_source_code VARCHAR2,
274 p_txn_type_id NUMBER,
275 p_txn_action_id NUMBER,
276 p_collection_id NUMBER,
277 p_occurrence NUMBER,
278 p_organization_id NUMBER)
279 RETURN NUMBER;
280
281 PROCEDURE WIP_MOVE_TXN(
282 p_item IN VARCHAR2,
283 p_job_name IN VARCHAR2,
284 p_from_op_seq IN NUMBER,
285 p_from_intra_step IN VARCHAR2,
286 p_to_op_seq IN NUMBER,
287 p_to_intra_step IN VARCHAR2,
288 p_fm_op_code IN VARCHAR2,
289 p_to_op_code IN VARCHAR2,
290 p_reason_name IN VARCHAR2,
291 p_uom IN VARCHAR2,
292 p_quantity IN NUMBER,
293 p_txn_date IN VARCHAR2,
294 p_collection_id IN NUMBER,
295 p_occurrence IN NUMBER,
296 p_organization_code IN VARCHAR2,
297 p_plan_name IN VARCHAR2,
298 p_launch_action IN VARCHAR2,
299 p_action_fired IN VARCHAR2);
300
301
302 PROCEDURE REWORK_ADD_OPERATION(
303 p_job_name IN VARCHAR2,
304 p_op_seq_num IN NUMBER,
305 p_operation_code IN VARCHAR2,
306 p_department_code IN VARCHAR2,
307 p_res_seq_num IN NUMBER,
308 p_resource_code IN VARCHAR2,
309 p_assigned_units IN NUMBER,
310 p_usage_rate IN NUMBER,
311 p_start_date IN VARCHAR2,
312 p_end_date IN VARCHAR2,
313 p_collection_id IN NUMBER,
314 p_occurrence IN NUMBER,
315 p_organization_code IN VARCHAR2,
316 p_plan_name IN VARCHAR2,
317 p_launch_action IN VARCHAR2,
318 p_action_fired IN VARCHAR2);
319
320 FUNCTION REWORK_OP_ADD_OP_INT(
321 p_group_id NUMBER,
322 p_job_name VARCHAR2,
323 p_wip_entity_id NUMBER,
324 p_op_seq_num NUMBER,
325 p_operation_id NUMBER,
326 p_department_id NUMBER,
327 p_start_date DATE,
328 p_end_date DATE,
329 p_organization_id NUMBER,
330 p_status_type NUMBER)
331 RETURN NUMBER;
332
333 FUNCTION REWORK_OP_ADD_RES_INT(
334 p_group_id NUMBER,
335 p_job_name VARCHAR2,
336 p_wip_entity_id NUMBER,
337 p_op_seq_num NUMBER,
338 p_operation_id NUMBER,
339 p_department_id NUMBER,
340 p_res_seq_num NUMBER,
341 p_resource_id NUMBER,
345 p_op_type NUMBER,
342 p_assigned_units NUMBER,
343 p_usage_rate NUMBER,
344 p_organization_id NUMBER,
346 p_status_type NUMBER)
347 RETURN NUMBER;
348
349
350
351 PROCEDURE UPDATE_STATUS(p_plan_id IN NUMBER,
352 p_collection_id IN NUMBER,
353 p_occurrence IN NUMBER);
354
355
356 PROCEDURE WRITE_BACK(p_plan_id IN NUMBER,
357 p_collection_id IN NUMBER,
358 p_occurrence IN NUMBER,
359 p_status IN VARCHAR2,
360 p_mti_transaction_header_id IN NUMBER DEFAULT NULL,
361 p_mti_transaction_interface_id IN NUMBER DEFAULT NULL,
362 p_mmt_transaction_id IN NUMBER DEFAULT NULL,
363 p_wmti_group_id IN NUMBER DEFAULT NULL,
364 p_wmt_transaction_id IN NUMBER DEFAULT NULL,
365 p_rti_interface_transaction_id IN NUMBER DEFAULT NULL,
366 p_job_id IN NUMBER DEFAULT NULL,
367 p_wjsi_group_id IN NUMBER DEFAULT NULL,
368 p_request_id IN NUMBER DEFAULT NULL,
369 p_message IN VARCHAR2 DEFAULT NULL,
370 p_move_order_number IN VARCHAR2 DEFAULT NULL,
371 p_eco_name IN VARCHAR2 DEFAULT NULL);
372
373
374
375 END QA_SOLUTION_DISPOSITION_PKG;
376