[Home] [Help]
PACKAGE: APPS.QA_SOLUTION_DISPOSITION_PKG
Source
1 PACKAGE QA_SOLUTION_DISPOSITION_PKG AUTHID CURRENT_USER as
2 /* $Header: qasodiss.pls 115.8 2003/01/13 12:34:47 kabalakr 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 PROCEDURE PO_RETURN_TO_VENDOR(
128 p_item IN VARCHAR2,
129 p_revision IN VARCHAR2,
130 p_subinventory IN VARCHAR2,
131 p_locator IN VARCHAR2,
132 p_lot_number IN VARCHAR2,
133 p_serial_number IN VARCHAR2,
134 p_uom_code IN VARCHAR2,
135 p_quantity IN NUMBER,
136 p_po_number IN VARCHAR2,
137 p_po_line_number IN NUMBER,
138 p_po_shipment_number IN NUMBER,
139 p_po_receipt_number IN NUMBER,
140 p_transaction_date IN VARCHAR2,
141 p_collection_id IN NUMBER,
142 p_occurrence IN NUMBER,
143 p_plan_name IN VARCHAR2,
144 p_organization_code IN VARCHAR2,
145 p_launch_action IN VARCHAR2,
146 p_action_fired IN VARCHAR2);
147
148
149
150 FUNCTION PO_RETURN_TO_VENDOR_INT(
151 p_item_id IN NUMBER,
152 p_revision IN VARCHAR2,
153 p_subinventory IN VARCHAR2,
154 p_locator_id IN NUMBER ,
155 p_lot_number IN VARCHAR2,
156 p_serial_number IN VARCHAR2,
157 p_uom_code IN VARCHAR2,
158 p_quantity IN NUMBER,
159 p_po_number IN VARCHAR2,
160 p_po_line_number IN NUMBER,
161 p_po_shipment_number IN NUMBER,
162 p_po_receipt_number IN NUMBER,
163 p_transaction_date IN DATE,
164 p_collection_id IN NUMBER,
165 p_occurrence IN NUMBER,
166 p_plan_id IN NUMBER,
167 p_organization_id IN NUMBER,
168 p_interface_transaction_id IN NUMBER)
169 RETURN NUMBER;
170
171
172 PROCEDURE INV_CREATE_MOVE_ORDER (
173 p_item IN VARCHAR2,
174 p_revision IN VARCHAR2,
175 p_from_subinventory IN VARCHAR2,
176 p_from_locator IN VARCHAR2,
177 p_lot_number IN VARCHAR2,
178 p_serial_number IN VARCHAR2,
179 p_uom_code IN VARCHAR2,
180 p_quantity IN NUMBER,
181 p_to_subinventory IN VARCHAR2,
182 p_to_locator IN VARCHAR2,
183 p_date_required IN VARCHAR2,
184 p_project_number IN VARCHAR2,
185 p_task_number IN VARCHAR2,
186 p_collection_id IN NUMBER,
187 p_occurrence IN NUMBER,
188 p_plan_name IN VARCHAR2,
189 p_organization_code IN VARCHAR2,
190 p_launch_action IN VARCHAR2,
191 p_action_fired IN VARCHAR2 );
192
193
194 FUNCTION INV_CREATE_MOVE_ORDER_INT (
195 p_item_id IN NUMBER,
196 p_revision IN VARCHAR2,
197 p_from_subinventory IN VARCHAR2,
198 p_from_locator_id IN NUMBER,
199 p_lot_number IN VARCHAR2,
200 p_serial_number IN VARCHAR2,
201 p_uom_code IN VARCHAR2,
202 p_quantity IN NUMBER,
203 p_to_subinventory IN VARCHAR2,
204 p_to_locator_id IN NUMBER,
205 p_date_required IN DATE,
206 p_project_id IN NUMBER,
207 p_task_id IN NUMBER,
208 p_organization_id IN NUMBER,
209 x_request_number OUT NOCOPY VARCHAR2)
210 RETURN VARCHAR2;
211
212
213 PROCEDURE WIP_COMP_RETURN(
214 p_job_name IN VARCHAR2,
215 p_item IN VARCHAR2,
216 p_revision IN VARCHAR2,
217 p_subinventory IN VARCHAR2,
218 p_locator IN VARCHAR2,
219 p_lot_number IN VARCHAR2,
220 p_serial_number IN VARCHAR2,
221 p_transaction_uom IN VARCHAR2,
222 p_transaction_qty IN NUMBER,
223 p_transaction_date IN VARCHAR2,
224 p_op_seq_num IN NUMBER,
225 p_reason_code IN VARCHAR2,
226 p_collection_id IN NUMBER,
227 p_occurrence IN NUMBER,
228 p_organization_code IN VARCHAR2,
229 p_plan_name IN VARCHAR2,
230 p_launch_action IN VARCHAR2,
231 p_action_fired IN VARCHAR2);
232
233
234
235 PROCEDURE WIP_COMP_ISSUE (
236 p_job_name IN VARCHAR2,
237 p_item IN VARCHAR2,
238 p_revision IN VARCHAR2,
239 p_subinventory IN VARCHAR2,
240 p_locator IN VARCHAR2,
241 p_lot_number IN VARCHAR2,
242 p_serial_number IN VARCHAR2,
243 p_transaction_uom IN VARCHAR2,
244 p_transaction_qty IN NUMBER,
245 p_transaction_date IN VARCHAR2,
246 p_op_seq_num IN NUMBER,
247 p_reason_code IN VARCHAR2,
248 p_collection_id IN NUMBER,
249 p_occurrence IN NUMBER,
250 p_organization_code IN VARCHAR2,
251 p_plan_name IN VARCHAR2,
252 p_launch_action IN VARCHAR2,
253 p_action_fired IN VARCHAR2);
254
255
256 FUNCTION WIP_MATERIAL_TXN_INT(
257 p_job_name VARCHAR2,
261 p_locator_id NUMBER,
258 p_item_id NUMBER,
259 p_revision VARCHAR2,
260 p_subinventory VARCHAR2,
262 p_lot_number VARCHAR2,
263 p_serial_number VARCHAR2,
264 p_transaction_uom VARCHAR2,
265 p_transaction_qty NUMBER,
266 p_transaction_date DATE,
267 p_op_seq_num NUMBER,
268 p_reason_id NUMBER,
269 p_source_code VARCHAR2,
270 p_txn_type_id NUMBER,
271 p_txn_action_id NUMBER,
272 p_collection_id NUMBER,
273 p_occurrence NUMBER,
274 p_organization_id NUMBER)
275 RETURN NUMBER;
276
277 PROCEDURE WIP_MOVE_TXN(
278 p_item IN VARCHAR2,
279 p_job_name IN VARCHAR2,
280 p_from_op_seq IN NUMBER,
281 p_from_intra_step IN VARCHAR2,
282 p_to_op_seq IN NUMBER,
283 p_to_intra_step IN VARCHAR2,
284 p_fm_op_code IN VARCHAR2,
285 p_to_op_code IN VARCHAR2,
286 p_reason_name IN VARCHAR2,
287 p_uom IN VARCHAR2,
288 p_quantity IN NUMBER,
289 p_txn_date IN VARCHAR2,
290 p_collection_id IN NUMBER,
291 p_occurrence IN NUMBER,
292 p_organization_code IN VARCHAR2,
293 p_plan_name IN VARCHAR2,
294 p_launch_action IN VARCHAR2,
295 p_action_fired IN VARCHAR2);
296
297
298 PROCEDURE REWORK_ADD_OPERATION(
299 p_job_name IN VARCHAR2,
300 p_op_seq_num IN NUMBER,
301 p_operation_code IN VARCHAR2,
302 p_department_code IN VARCHAR2,
303 p_res_seq_num IN NUMBER,
304 p_resource_code IN VARCHAR2,
305 p_assigned_units IN NUMBER,
306 p_usage_rate IN NUMBER,
307 p_start_date IN VARCHAR2,
308 p_end_date IN VARCHAR2,
309 p_collection_id IN NUMBER,
310 p_occurrence IN NUMBER,
311 p_organization_code IN VARCHAR2,
312 p_plan_name IN VARCHAR2,
313 p_launch_action IN VARCHAR2,
314 p_action_fired IN VARCHAR2);
315
316 FUNCTION REWORK_OP_ADD_OP_INT(
317 p_group_id NUMBER,
318 p_job_name VARCHAR2,
319 p_wip_entity_id NUMBER,
320 p_op_seq_num NUMBER,
321 p_operation_id NUMBER,
322 p_department_id NUMBER,
323 p_start_date DATE,
324 p_end_date DATE,
325 p_organization_id NUMBER,
326 p_status_type NUMBER)
327 RETURN NUMBER;
328
329 FUNCTION REWORK_OP_ADD_RES_INT(
330 p_group_id NUMBER,
331 p_job_name VARCHAR2,
332 p_wip_entity_id NUMBER,
333 p_op_seq_num NUMBER,
334 p_operation_id NUMBER,
335 p_department_id NUMBER,
336 p_res_seq_num NUMBER,
337 p_resource_id NUMBER,
338 p_assigned_units NUMBER,
339 p_usage_rate NUMBER,
340 p_organization_id NUMBER,
341 p_op_type NUMBER,
342 p_status_type NUMBER)
343 RETURN NUMBER;
344
345
346
347 PROCEDURE UPDATE_STATUS(p_plan_id IN NUMBER,
348 p_collection_id IN NUMBER,
349 p_occurrence IN NUMBER);
350
351
352 PROCEDURE WRITE_BACK(p_plan_id IN NUMBER,
353 p_collection_id IN NUMBER,
354 p_occurrence IN NUMBER,
355 p_status IN VARCHAR2,
356 p_mti_transaction_header_id IN NUMBER DEFAULT NULL,
357 p_mti_transaction_interface_id IN NUMBER DEFAULT NULL,
358 p_mmt_transaction_id IN NUMBER DEFAULT NULL,
359 p_wmti_group_id IN NUMBER DEFAULT NULL,
360 p_wmt_transaction_id IN NUMBER DEFAULT NULL,
361 p_rti_interface_transaction_id IN NUMBER DEFAULT NULL,
362 p_job_id IN NUMBER DEFAULT NULL,
363 p_wjsi_group_id IN NUMBER DEFAULT NULL,
364 p_request_id IN NUMBER DEFAULT NULL,
365 p_message IN VARCHAR2 DEFAULT NULL,
366 p_move_order_number IN VARCHAR2 DEFAULT NULL,
367 p_eco_name IN VARCHAR2 DEFAULT NULL);
368
369
370
371 END QA_SOLUTION_DISPOSITION_PKG;
372