1 PACKAGE WSM_LBJ_INTERFACE_PVT AS
2 /* $Header: WSMVLJIS.pls 120.1.12000000.1 2007/01/12 05:38:08 appldev ship $ */
3
4 lbji_debug varchar2(1):= fnd_profile.value('mrp_debug');
5 g_no_of_workers number := fnd_profile.value('wsm_lbjimport_worker');
6 g_batch_size number := fnd_profile.value('wsm_lbjimport_batchsize');
7
8 /* define constance for load_type */
9 WSM_LOAD_RES number := 1; -- load a resource
10 WSM_LOAD_COMP number := 2; -- load a component
11 WSM_LOAD_OP number := 3; -- load an operation
12 WSM_LOAD_RES_USE number := 4; -- load resource usage
13 WSM_LOAD_LINK number := 5; -- load a link
14 WSM_LOAD_LINK_OP number := 6; -- load link and/or operation
15 WSM_LOAD_RES_INS number := 7; -- load resource instance
16
17 WSM_SUB_DEL number := 1; -- delete
18 WSM_SUB_ADD number := 2; -- add
19 WSM_SUB_CHG number := 3; -- change/update
20 WSM_SUB_REC number := 4; -- recommend
21 WSM_SUB_DIS number := 5; -- discommend
22
23
24 LT_RESOURCE number := 1;
25
26 --
27 -- R12Dev: for secondary quantity
28 --
29 type tbl_wjsq_uom_code is table of wsm_job_secondary_quantities.uom_code%type index by binary_integer;
30 type tbl_wjsq_start_quantity is table of wsm_job_secondary_quantities.start_quantity%type index by binary_integer;
31
32 procedure process_lbji_rows (
33 retcode out nocopy number,
34 errbuf out nocopy varchar2,
35 p_group_id in number);
36
37
38 procedure launch_worker (
39 retcode out nocopy number,
40 errbuf out nocopy varchar2,
41 p_group_id in number,
42 p_alotted_jobs in number );
43
44
45 procedure build_job_header_info(
46 p_common_routing_sequence_id in number,
47 p_common_bill_sequence_id in number,
48 p_status_type in number,
49 p_class_code in varchar2,
50 p_org_id in number,
51 p_wip_entity_id in out nocopy number,
52 p_last_updt_date in date,
53 p_last_updt_by in number,
54 p_creation_date in date,
55 p_created_by in number,
56 p_last_updt_login in number,
57 p_request_id in number,
58 p_program_appl_id in number,
59 p_program_id in number,
60 p_prog_updt_date in date,
61 p_source_line_id in number,
62 p_source_code in varchar2,
63 p_description in varchar2,
64 p_item in number,
65 p_job_type in number,
66 p_bom_reference_id in number,
67 p_routing_reference_id in number,
68 p_firm_planned_flag in number,
69 p_wip_supply_type in number,
70 p_job_scheduled_start_date in date,
71 p_job_scheduled_compl_date in date,
72 p_start_quantity in number,
73 p_net_quantity in number,
74 p_coproducts_supply in number,
75 p_bom_revision in varchar2,
76 p_routing_revision in varchar2,
77 p_bom_revision_date in date,
78 p_routing_revision_date in date,
79 p_lot_number in varchar2,
80 p_alt_bom_designator in varchar2,
81 p_alt_routing_designator in varchar2,
82 p_priority in number,
83 p_due_date in date,
84 p_attribute_category in varchar2,
85 p_attribute1 in varchar2,
86 p_attribute2 in varchar2,
87 p_attribute3 in varchar2,
88 p_attribute4 in varchar2,
89 p_attribute5 in varchar2,
90 p_attribute6 in varchar2,
91 p_attribute7 in varchar2,
92 p_attribute8 in varchar2,
93 p_attribute9 in varchar2,
94 p_attribute10 in varchar2,
95 p_attribute11 in varchar2,
96 p_attribute12 in varchar2,
97 p_attribute13 in varchar2,
98 p_attribute14 in varchar2,
99 p_attribute15 in varchar2,
100 p_job_name in varchar2,
101 p_completion_subinventory in varchar2,
102 p_completion_locator_id in number,
103 p_demand_class in varchar2,
104 p_project_id in number,
105 p_task_id in number,
106 p_schedule_group_id in number,
107 p_build_sequence in number,
108 p_line_id in number,
109 p_kanban_card_id in number,
110 p_overcompl_tol_type in number,
111 p_overcompl_tol_value in number,
112 p_end_item_unit_number in number,
113 p_src_client_server in number,
114 p_po_creation_time in number,
115 p_date_released in date,
116 p_error_code out nocopy number,
117 p_error_msg out nocopy varchar2);
118
119
120 procedure build_job_copy_info(
121 p_common_routing_sequence_id in number,
122 p_common_bill_sequence_id in number,
123 p_org_id in number,
124 p_wip_entity_id in number,
125 p_last_updt_date in date,
126 p_last_updt_by in number,
127 p_creation_date in date,
128 p_created_by in number,
129 p_last_updt_login in number,
130 p_request_id in number,
131 p_program_appl_id in number,
132 p_program_id in number,
133 p_prog_updt_date in date,
134 p_item in number,
135 p_bom_reference_id in number,
136 p_routing_reference_id in number,
137 p_wip_supply_type in number,
138 p_job_scheduled_start_date in date,
139 p_job_scheduled_compl_date in date,
140 p_start_quantity in number,
141 p_bom_revision_date in date,
142 p_routing_revision_date in date,
143 p_alt_bom_designator in varchar2,
144 p_alt_routing_designator in varchar2,
145 p_header_id in number, -- header_id in WLJI, pass null if N/A
146 p_num_of_children in number, -- number of children in WLJDI
147 p_infinite_schedule in varchar2, -- call infinite scheduler or not: Y/N
148 p_error_code out nocopy number,
149 p_error_msg out nocopy varchar2);
150
151
152 procedure build_job_detail_info(
153 p_common_routing_sequence_id in number,
154 p_common_bill_sequence_id in number,
155 p_status_type in number,
156 p_org_id in number,
157 p_wip_entity_id in number,
158 p_last_updt_date in date,
159 p_last_updt_by in number,
160 p_creation_date in date,
161 p_created_by in number,
162 p_last_updt_login in number,
163 p_request_id in number,
164 p_program_appl_id in number,
165 p_program_id in number,
166 p_prog_updt_date in date,
167 p_item in number,
168 p_job_type in number,
169 p_bom_reference_id in number,
170 p_routing_reference_id in number,
171 p_wip_supply_type in number,
172 p_job_scheduled_start_date in date, -- not used
173 p_job_scheduled_compl_date in date, -- not used
174 p_start_quantity in number,
175 p_bom_revision_date in date,
176 p_routing_revision_date in date,
177 p_alt_bom_designator in varchar2,
178 p_alt_routing_designator in varchar2,
179 p_rtg_op_seq_num in number,
180 p_error_code out nocopy number,
181 p_error_msg out nocopy varchar2);
182
183
184 procedure import_lot_job_details(
185 p_wip_entity_id in number,
186 p_org_id in number,
187 p_wo_records_exist in varchar2,
188 p_parent_header_id in number, -- header_id in WLJI not NULL
189 p_job_scheduled_start_date in date,
190 p_job_scheduled_compl_date in date,
191 p_job_scheduled_quantity in number,
192 p_group_id in number, -- only passed when handling independent wljdi records
193 p_last_updt_date in date,
194 p_last_updt_by in number,
195 p_creation_date in date,
196 p_created_by in number,
197 p_last_updt_login in number,
198 p_request_id in number,
199 p_program_appl_id in number,
200 p_program_id in number,
201 p_prog_updt_date in date,
202 p_error_code out nocopy number,
203 p_error_msg out nocopy varchar2);
204
205
206 procedure load_wsli_data(
207 p_group_id in number);
208
209
210 procedure check_errored_mmtt_records (
211 p_header_id in number,
212 x_err_code out nocopy number,
213 x_err_msg out nocopy varchar2);
214
215
216 function discrete_charges_exist(
217 p_wip_entity_id in number,
218 p_organization_id in number,
219 p_check_mode in number ) return boolean;
220
221
222 procedure insert_into_period_balances (
223 p_wip_entity_id in number,
224 p_organization_id in number,
225 p_class_code in varchar2,
226 p_release_date in date,
227 p_error_code out nocopy number,
228 p_err_msg out nocopy varchar2);
229
230
231 -- overloaded
232 procedure build_job_detail_info(
233 p_common_routing_sequence_id in number,
234 p_common_bill_sequence_id in number,
235 p_status_type in number,
236 p_org_id in number,
237 p_wip_entity_id in number,
238 p_last_updt_date in date,
239 p_last_updt_by in number,
240 p_creation_date in date,
241 p_created_by in number,
242 p_last_updt_login in number,
243 p_request_id in number,
244 p_program_appl_id in number,
245 p_program_id in number,
246 p_prog_updt_date in date,
247 p_item in number,
248 p_job_type in number,
249 p_bom_reference_id in number,
250 p_routing_reference_id in number,
251 p_wip_supply_type in number,
252 p_job_scheduled_start_date in date, -- not used
253 p_job_scheduled_compl_date in date, -- not used
254 p_start_quantity in number,
255 p_bom_revision_date in date,
256 p_routing_revision_date in date,
257 p_alt_bom_designator in varchar2,
258 p_alt_routing_designator in varchar2,
259 p_rtg_op_seq_num in number,
260 p_error_code out nocopy number,
261 p_error_msg out nocopy varchar2,
262 p_src_client_server in number, -- bug 3311985 new parameter
263 p_po_creation_time in number); -- bug 3311985 new parameter
264
265 --
266 -- R12Dev: for secondary quantity, overloaded
267 --
268 procedure build_job_header_info(
269 p_common_routing_sequence_id in number,
270 p_common_bill_sequence_id in number,
271 p_status_type in number,
272 p_class_code in varchar2,
273 p_org_id in number,
274 p_wip_entity_id in out nocopy number,
275 p_last_updt_date in date,
276 p_last_updt_by in number,
277 p_creation_date in date,
278 p_created_by in number,
279 p_last_updt_login in number,
280 p_request_id in number,
281 p_program_appl_id in number,
282 p_program_id in number,
283 p_prog_updt_date in date,
284 p_source_line_id in number,
285 p_source_code in varchar2,
286 p_description in varchar2,
287 p_item in number,
288 p_job_type in number,
289 p_bom_reference_id in number,
290 p_routing_reference_id in number,
291 p_firm_planned_flag in number,
292 p_wip_supply_type in number,
293 p_job_scheduled_start_date in date,
294 p_job_scheduled_compl_date in date,
295 p_start_quantity in number,
296 p_net_quantity in number,
300 p_bom_revision_date in date,
297 p_coproducts_supply in number,
298 p_bom_revision in varchar2,
299 p_routing_revision in varchar2,
301 p_routing_revision_date in date,
302 p_lot_number in varchar2,
303 p_alt_bom_designator in varchar2,
304 p_alt_routing_designator in varchar2,
305 p_priority in number,
306 p_due_date in date,
307 p_attribute_category in varchar2,
308 p_attribute1 in varchar2,
309 p_attribute2 in varchar2,
310 p_attribute3 in varchar2,
311 p_attribute4 in varchar2,
312 p_attribute5 in varchar2,
313 p_attribute6 in varchar2,
314 p_attribute7 in varchar2,
315 p_attribute8 in varchar2,
316 p_attribute9 in varchar2,
317 p_attribute10 in varchar2,
318 p_attribute11 in varchar2,
319 p_attribute12 in varchar2,
320 p_attribute13 in varchar2,
321 p_attribute14 in varchar2,
322 p_attribute15 in varchar2,
323 p_job_name in varchar2,
324 p_completion_subinventory in varchar2,
325 p_completion_locator_id in number,
326 p_demand_class in varchar2,
327 p_project_id in number,
328 p_task_id in number,
329 p_schedule_group_id in number,
330 p_build_sequence in number,
331 p_line_id in number,
332 p_kanban_card_id in number,
333 p_overcompl_tol_type in number,
334 p_overcompl_tol_value in number,
335 p_end_item_unit_number in number,
336 p_src_client_server in number,
337 p_po_creation_time in number,
338 p_date_released in date,
339 p_wjsq_uom_code in tbl_wjsq_uom_code, -- R12Dev new parameter
340 p_wjsq_start_quantity in tbl_wjsq_start_quantity, -- R12Dev new parameter
341 p_error_code out nocopy number,
342 p_error_msg out nocopy varchar2);
343
344
345 END;