1 PACKAGE CSTPSMUT AUTHID CURRENT_USER AS
2 /* $Header: CSTSMUTS.pls 120.1 2005/11/10 04:40:23 sikhanna noship $ */
3
4 /*
5 BOM PatchSet I Enhancements for OSFM Costing -
6 Added Procedures:
7 COST_SPLIT_TXN
8 COST_MERGE_TXN
9 COST_BONUS_TXN
10 COST_UPDATE_QTY_TXN
11 GET_WIP_TXN_ID
12 INSERT_WOO
13 UPDATE_JOB_QUANTITY
14 GET_JOB_VALUE
15 Removed Procedures:
16 GET_PARAMS
17 UPDATE_OP_RES_REQ_INFO
18 GET_CHARGE_VAL
19 GET_SCRAP_VAL
20 */
21
22 PROCEDURE COST_SPLIT_TXN (p_api_version IN NUMBER DEFAULT 1.0,
23 p_transaction_id IN NUMBER,
24 p_mmt_transaction_id IN NUMBER,
25 p_transaction_date IN DATE,
26 p_prog_application_id IN NUMBER,
27 p_program_id IN NUMBER,
28 p_request_id IN NUMBER,
29 p_login_id IN NUMBER,
30 p_user_id IN NUMBER,
31 x_err_num IN OUT NOCOPY NUMBER,
32 x_err_code IN OUT NOCOPY VARCHAR2,
33 x_err_msg IN OUT NOCOPY VARCHAR2);
34
35 PROCEDURE COST_MERGE_TXN (p_api_version IN NUMBER DEFAULT 1.0,
36 p_transaction_id IN NUMBER,
37 p_mmt_transaction_id IN NUMBER,
38 p_transaction_date IN DATE,
39 p_prog_application_id IN NUMBER,
40 p_program_id IN NUMBER,
41 p_request_id IN NUMBER,
42 p_login_id IN NUMBER,
43 p_user_id IN NUMBER,
44 x_err_num IN OUT NOCOPY NUMBER,
45 x_err_code IN OUT NOCOPY VARCHAR2,
46 x_err_msg IN OUT NOCOPY VARCHAR2);
47
48 PROCEDURE COST_UPDATE_QTY_TXN
49 (p_api_version IN NUMBER DEFAULT 1.0,
50 p_transaction_id IN NUMBER,
51 p_mmt_transaction_id IN NUMBER,
52 p_transaction_date IN DATE,
53 p_prog_application_id IN NUMBER,
54 p_program_id IN NUMBER,
55 p_request_id IN NUMBER,
56 p_login_id IN NUMBER,
57 p_user_id IN NUMBER,
58 x_err_num IN OUT NOCOPY NUMBER,
59 x_err_code IN OUT NOCOPY VARCHAR2,
60 x_err_msg IN OUT NOCOPY VARCHAR2);
61
62 PROCEDURE COST_BONUS_TXN (p_api_version IN NUMBER DEFAULT 1.0,
63 p_transaction_id IN NUMBER,
64 p_mmt_transaction_id IN NUMBER,
65 p_transaction_date IN DATE,
66 p_prog_application_id IN NUMBER,
67 p_program_id IN NUMBER,
68 p_request_id IN NUMBER,
69 p_login_id IN NUMBER,
70 p_user_id IN NUMBER,
71 x_err_num IN OUT NOCOPY NUMBER,
72 x_err_code IN OUT NOCOPY VARCHAR2,
73 x_err_msg IN OUT NOCOPY VARCHAR2);
74
75 PROCEDURE GET_WIP_TXN_ID( x_wip_txn_id OUT NOCOPY NUMBER,
76 x_err_num IN OUT NOCOPY NUMBER,
77 x_err_code IN OUT NOCOPY VARCHAR2,
78 x_err_msg IN OUT NOCOPY VARCHAR2 );
79
80 PROCEDURE UPDATE_JOB_QUANTITY ( p_api_version IN NUMBER,
81 p_txn_id IN NUMBER,
82 x_err_num IN OUT NOCOPY NUMBER,
83 x_err_code IN OUT NOCOPY VARCHAR2,
84 x_err_msg IN OUT NOCOPY VARCHAR2 );
85 PROCEDURE GET_JOB_VALUE
86 (p_api_version in number,
87 p_lot_size in number,
88 p_run_mode in number,
89 p_entity_id in number,
90 p_intraop_step in number,
91 p_operation_seq_num in number,
92 p_transaction_id in number,
93 p_txn_type in number,
94 p_org_id in number,
95 x_err_num in OUT NOCOPY number,
96 x_err_code in OUT NOCOPY varchar2,
97 x_err_msg in OUT NOCOPY varchar2,
98 x_pl_mtl_cost in OUT NOCOPY number,
99 x_pl_mto_cost in OUT NOCOPY number,
100 x_pl_res_cost in OUT NOCOPY number,
101 x_pl_ovh_cost in OUT NOCOPY number,
102 x_pl_osp_cost in OUT NOCOPY number,
103 x_tl_res_cost in OUT NOCOPY number,
104 x_tl_ovh_cost in OUT NOCOPY number,
105 x_tl_osp_cost in OUT NOCOPY number);
106
107 /*
108 BOM PatchSet I Enhancements for OSFM Costing - End
109 */
110
111
112 /*------------------------------------------------------------------+
113 | PROCEDURE BALANCE_MTA to balance any variance in MTA |
114 -------------------------------------------------------------------*/
115
116 PROCEDURE BALANCE_ACCOUNTING (p_mtl_txn_id IN NUMBER,
117 p_wip_txn_id IN NUMBER,
118 p_txn_type IN NUMBER,
119 p_err_msg IN OUT NOCOPY VARCHAR2,
120 p_err_code IN OUT NOCOPY VARCHAR2,
121 p_err_num IN OUT NOCOPY NUMBER);
122
123
124 /*------------------------------------------------------------------+
125 | INSERT_MAT_TXN: procedure to enter a dummy transaction in |
126 | mtl_material_transaction for cost processor: |
127 | x_sm_txn_id => WIP lot split/merge transaction id |
128 | p_mtl_txn_id => material transaction id |
129 | x_user_id, x_login_id, x_request_id, x_prog_appl_id, |
130 | x_program_id => standard who columns |
131 | x_acct_period_id => current accouting period id |
132 | x_txn_qty => transaction quantity: starting lot quantity or |
133 | resulting lot quantity |
134 | x_action_id => transaction_action_id |
135 | cost processor: 40 (Split Issue), 41 (Split |
136 | Return), 42 (Merge Issue), 43 (Merge |
137 | Return), 44 (Translate Issue), |
138 | 45 (Translate Return) |
139 | cost update: 46 Split/Merge Cost Update |
140 | x_source_type_id => transaction source type (5-job/schedule)|
141 | p_txn_type_name => cost processor: Split Resulting, Split |
142 | Starting, Merge Resulting, Merge |
143 | Starting, Translate Resulting, |
144 | Translate Starting |
145 | cost update: Split/Merge Cost Update |
146 | p_wip_entity_id => Starting or resulting lot wip entity id, |
147 | used to populate transaction_source_id |
148 +------------------------------------------------------------------*/
149 PROCEDURE INSERT_MAT_TXN( p_date IN DATE,
150 p_sm_txn_id IN NUMBER,
151 p_mtl_txn_id IN NUMBER,
152 p_acct_period_id IN NUMBER,
153 p_txn_qty IN NUMBER,
154 p_action_id IN NUMBER,
155 p_source_type_id IN NUMBER,
156 p_txn_type_name IN VARCHAR2,
157 p_wip_entity_id IN NUMBER,
158 p_operation_seq_num IN NUMBER,
159 p_user_id IN NUMBER,
160 p_login_id IN NUMBER,
161 p_request_id IN NUMBER,
162 p_prog_appl_id IN NUMBER,
163 p_program_id IN NUMBER,
164 p_debug IN VARCHAR2,
165 p_err_num IN OUT NOCOPY NUMBER,
166 p_err_code IN OUT NOCOPY VARCHAR2,
167 p_err_msg IN OUT NOCOPY VARCHAR2);
168
169 /*------------------------------------------------------------------+
170 | INSERT_MAT_TXN: procedure to enter a dummy transaction in |
171 | mtl_material_transaction for cost processor: |
172 | p_sm_txn_id => WIP lot split/merge transaction id |
173 | p_wip_txn_id => wip transaction id |
174 | x_user_id, x_login_id, x_request_id, x_prog_appl_id, |
175 | x_program_id => standard who columns |
176 | p_acct_period_id => current accouting period id |
177 | p_txn_type_name => cost processor: Split Resulting, Split |
178 | Starting, Merge Resulting, Merge |
179 | Starting, Translate Resulting, |
180 | Translate Starting |
181 | p_wip_entity_id => Starting or resulting lot wip entity id, |
182 | used to populate transaction_source_id |
183 | p_txn_id => added to get UOM Bug#4307365 |
184 +------------------------------------------------------------------*/
185 PROCEDURE INSERT_WIP_TXN( p_date IN DATE,
186 p_sm_txn_id IN NUMBER,
187 p_wip_txn_id IN NUMBER,
188 p_acct_period_id IN NUMBER,
189 p_wip_entity_id IN NUMBER,
190 p_operation_seq_num IN NUMBER,
191 p_lookup_code IN NUMBER,
192 p_user_id IN NUMBER,
193 p_login_id IN NUMBER,
194 p_request_id IN NUMBER,
195 p_prog_appl_id IN NUMBER,
196 p_program_id IN NUMBER,
197 p_debug IN VARCHAR2,
198 p_err_num IN OUT NOCOPY NUMBER,
199 p_err_code IN OUT NOCOPY VARCHAR2,
200 p_err_msg IN OUT NOCOPY VARCHAR2,
201 p_txn_id IN NUMBER);
202
203 PROCEDURE INSERT_MTA(p_date IN DATE,
204 p_min_acct_unit IN NUMBER,
205 p_ext_prec IN NUMBER,
206 p_sm_txn_type IN NUMBER,
207 p_mtl_txn_id IN NUMBER,
208 p_org_id IN NUMBER,
209 p_wip_id IN NUMBER,
210 p_acct_ltype IN NUMBER,
211 p_txn_qty IN NUMBER,
212 p_tl_mtl_cost IN NUMBER,
213 p_tl_mto_cost IN NUMBER,
214 p_tl_res_cost IN NUMBER,
215 p_tl_ovh_cost IN NUMBER,
216 p_tl_osp_cost IN NUMBER,
217 p_cost_element_id IN NUMBER,
218 p_user_id IN NUMBER,
219 p_login_id IN NUMBER,
220 p_request_id IN NUMBER,
221 p_prog_appl_id IN NUMBER,
222 p_program_id IN NUMBER,
223 p_debug IN VARCHAR2,
224 p_err_num IN OUT NOCOPY NUMBER,
225 p_err_code IN OUT NOCOPY VARCHAR2,
226 p_err_msg IN OUT NOCOPY VARCHAR2);
227
228 /*------------------------------------------------------------------+
229 | INSERT_MAT_TXN_ACCT: Procedure to enter the allocated total |
230 | mtl_material_transaction for cost processor |
231 +------------------------------------------------------------------*/
232 PROCEDURE INSERT_MAT_TXN_ACCT(p_date IN DATE,
233 p_min_acct_unit IN NUMBER,
234 p_ext_prec IN NUMBER,
235 p_sm_txn_type IN NUMBER,
236 p_mtl_txn_id IN NUMBER,
237 p_org_id IN NUMBER,
238 p_wip_id IN NUMBER,
239 p_acct_ltype IN NUMBER,
240 p_txn_qty IN NUMBER,
241 p_tl_mtl_cost IN NUMBER,
242 p_tl_mto_cost IN NUMBER,
243 p_tl_res_cost IN NUMBER,
244 p_tl_ovh_cost IN NUMBER,
245 p_tl_osp_cost IN NUMBER,
246 p_user_id IN NUMBER,
247 p_login_id IN NUMBER,
248 p_request_id IN NUMBER,
249 p_prog_appl_id IN NUMBER,
250 p_program_id IN NUMBER,
251 p_debug IN VARCHAR2,
252 p_err_num IN OUT NOCOPY NUMBER,
253 p_err_code IN OUT NOCOPY VARCHAR2,
254 p_err_msg IN OUT NOCOPY VARCHAR2);
255
256 PROCEDURE BONUS_MAT_TXN_ACCT(p_date IN DATE,
257 p_ext_prec IN NUMBER,
258 p_min_acct_unit IN NUMBER,
259 p_sm_txn_type IN NUMBER,
260 p_sm_txn_id IN NUMBER,
261 p_mtl_txn_id IN NUMBER,
262 p_org_id IN NUMBER,
263 p_wip_id IN NUMBER,
264 p_acct_ltype IN NUMBER,
265 p_total_cost IN NUMBER,
266 p_user_id IN NUMBER,
267 p_login_id IN NUMBER,
268 p_request_id IN NUMBER,
269 p_prog_appl_id IN NUMBER,
270 p_program_id IN NUMBER,
271 p_debug IN VARCHAR2,
272 p_err_num IN OUT NOCOPY NUMBER,
273 p_err_code IN OUT NOCOPY VARCHAR2,
274 p_err_msg IN OUT NOCOPY VARCHAR2);
275
276 PROCEDURE INSERT_WIP_TXN_ACCT(p_date IN DATE,
277 p_min_acct_unit IN NUMBER,
278 p_ext_prec IN NUMBER,
279 p_sm_txn_id IN NUMBER,
280 p_sm_txn_type IN NUMBER,
281 p_wip_txn_id IN NUMBER,
282 p_org_id IN NUMBER,
283 p_wip_id IN NUMBER,
284 p_acct_ltype IN NUMBER,
285 p_txn_qty IN NUMBER,
286 p_pl_mtl_cost IN NUMBER,
287 p_pl_mto_cost IN NUMBER,
288 p_pl_res_cost IN NUMBER,
289 p_pl_ovh_cost IN NUMBER,
290 p_pl_osp_cost IN NUMBER,
291 p_user_id IN NUMBER,
292 p_login_id IN NUMBER,
293 p_request_id IN NUMBER,
294 p_prog_appl_id IN NUMBER,
295 p_program_id IN NUMBER,
296 p_debug IN VARCHAR2,
297 p_err_num IN OUT NOCOPY NUMBER,
298 p_err_code IN OUT NOCOPY VARCHAR2,
299 p_err_msg IN OUT NOCOPY VARCHAR2);
300
301 PROCEDURE BONUS_WIP_TXN_ACCT(p_date IN DATE,
302 p_ext_prec IN NUMBER,
303 p_min_acct_unit IN NUMBER,
304 p_sm_txn_id IN NUMBER,
305 p_sm_txn_type IN NUMBER,
306 p_wip_txn_id IN NUMBER,
307 p_org_id IN NUMBER,
308 p_wip_id IN NUMBER,
309 p_acct_ltype IN NUMBER,
310 p_total_cost IN NUMBER,
311 p_user_id IN NUMBER,
312 p_login_id IN NUMBER,
313 p_request_id IN NUMBER,
314 p_prog_appl_id IN NUMBER,
315 p_program_id IN NUMBER,
316 p_debug IN VARCHAR2,
317 p_err_num IN OUT NOCOPY NUMBER,
318 p_err_code IN OUT NOCOPY VARCHAR2,
319 p_err_msg IN OUT NOCOPY VARCHAR2);
320
321 -- from WSMJBUDS
322
323 PROCEDURE START_LOT (
324 p_sl_mtl_txn_id IN NUMBER,
325 p_sl_wip_txn_id IN NUMBER,
326 p_sl_wip_id IN NUMBER,
327 p_acct_period_id IN NUMBER,
328 p_user_id IN NUMBER,
329 p_login_id IN NUMBER,
330 p_request_id IN NUMBER,
331 p_prog_appl_id IN NUMBER,
332 p_program_id IN NUMBER,
333 p_err_num in OUT NOCOPY number,
334 p_err_code in OUT NOCOPY varchar2,
335 p_err_msg in OUT NOCOPY varchar2);
336
337 PROCEDURE RESULT_LOT(
338 p_rl_mtl_txn_id IN NUMBER,
339 p_rl_wip_txn_id IN NUMBER,
340 p_rl_wip_id IN NUMBER,
341 p_acct_period_id IN NUMBER,
342 p_user_id IN NUMBER,
343 p_login_id IN NUMBER,
344 p_request_id IN NUMBER,
345 p_prog_appl_id IN NUMBER,
346 p_program_id IN NUMBER,
347 p_debug IN VARCHAR2,
348 p_err_num IN OUT NOCOPY NUMBER,
349 p_err_code IN OUT NOCOPY VARCHAR2,
350 p_err_msg IN OUT NOCOPY VARCHAR2);
351
352
353 END CSTPSMUT;