1 PACKAGE WSMPLBJI AUTHID CURRENT_USER AS
2 /* $Header: WSMLBJIS.pls 115.18 2003/09/17 18:44:48 zchen ship $ */
3
4 lbji_debug VARCHAR2(1):= fnd_profile.value('MRP_DEBUG');
5
6 no_of_workers NUMBER := fnd_profile.value('WSM_LBJIMPORT_WORKER');
7
8 batch_size NUMBER := fnd_profile.value('WSM_LBJIMPORT_BATCHSIZE');
9
10
11
12 g_create_job_copy VARCHAR2(1) := 'Y';
13
14 PROCEDURE process_interface_rows (
15 retcode OUT NOCOPY NUMBER,
16 errbuf OUT NOCOPY VARCHAR2 );
17
18
19 PROCEDURE process_interface_rows (
20 retcode OUT NOCOPY NUMBER,
21 errbuf OUT NOCOPY VARCHAR2,
22 p_group_id IN NUMBER);
23
24
25 PROCEDURE launch_worker (
26 retcode OUT NOCOPY NUMBER,
27 errbuf OUT NOCOPY VARCHAR2,
28 l_group_id IN NUMBER,
29 alotted_rows IN NUMBER );
30
31
32 procedure build_lbji_info(
33 p_routing_seq_id IN number,
34 p_common_bill_sequence_id IN number,
35 p_explode_header_detail IN number,
36 p_status_type IN number,
37 p_class_code IN varchar2,
38 p_org IN number,
39 p_wip_entity_id IN OUT NOCOPY number,
40 p_last_updt_date IN date,
41 p_last_updt_by IN number,
42 p_creation_date IN date,
43 p_created_by IN number,
44 p_last_updt_login IN number,
45 p_request_id IN number,
46 p_program_application_id IN number,
47 p_program_id IN number,
48 p_prog_updt_date IN date,
49 p_source_line_id IN number,
50 p_source_code IN varchar2,
51 p_description IN varchar2,
52 p_item IN number,
53 p_job_type IN number,
54 p_bom_reference_id IN number,
55 p_routing_reference_id IN number,
56 p_firm_planned_flag IN number,
57 p_wip_supply_type IN number,
58 p_fusd IN date,
59 p_lucd IN date,
60 p_start_quantity IN number,
61 p_net_quantity IN number,
62 p_coproducts_supply IN number,
63 p_bom_revision IN varchar2,
64 p_routing_revision IN varchar2,
65 p_bom_revision_date IN date,
66 p_routing_revision_date IN date,
67 p_lot_number IN varchar2,
68 p_alt_bom_designator IN varchar2,
69 p_alt_routing_designator IN varchar2,
70 p_priority IN number,
71 p_due_date IN date,
72 p_attribute_category IN varchar2,
73 p_attribute1 IN varchar2,
74 p_attribute2 IN varchar2,
75 p_attribute3 IN varchar2,
76 p_attribute4 IN varchar2,
77 p_attribute5 IN varchar2,
78 p_attribute6 IN varchar2,
79 p_attribute7 IN varchar2,
80 p_attribute8 IN varchar2,
81 p_attribute9 IN varchar2,
82 p_attribute10 IN varchar2,
83 p_attribute11 IN varchar2,
84 p_attribute12 IN varchar2,
85 p_attribute13 IN varchar2,
86 p_attribute14 IN varchar2,
87 p_attribute15 IN varchar2,
88 p_job_name IN varchar2,
89 p_completion_subinventory IN varchar2,
90 p_completion_locator_id IN number,
91 p_demand_class IN varchar2,
92 p_project_id IN number,
93 p_task_id IN number,
94 p_schedule_group_id IN number,
95 p_build_sequence IN number,
96 p_line_id IN number,
97 p_kanban_card_id IN number,
98 p_overcompl_tol_type IN number,
99 p_overcompl_tol_value IN number,
100 p_end_item_unit_number IN number,
101 p_rtg_op_seq_num IN number,
102 p_src_client_server IN number,
103 p_po_creation_time IN number,
104 p_error_code OUT NOCOPY number,
105 p_error_msg OUT NOCOPY varchar2);
106
107
108 procedure build_lbji_info(
109 p_routing_seq_id IN number,
110 p_common_bill_sequence_id IN number,
111 p_explode_header_detail IN number,
112 p_status_type IN number,
113 p_class_code IN varchar2,
114 p_org IN number,
115 p_wip_entity_id IN OUT NOCOPY number,
116 p_last_updt_date IN date,
117 p_last_updt_by IN number,
118 p_creation_date IN date,
119 p_created_by IN number,
120 p_last_updt_login IN number,
121 p_request_id IN number,
122 p_program_application_id IN number,
123 p_program_id IN number,
124 p_prog_updt_date IN date,
125 p_source_line_id IN number,
126 p_source_code IN varchar2,
127 p_description IN varchar2,
128 p_item IN number,
129 p_job_type IN number,
130 p_bom_reference_id IN number,
131 p_routing_reference_id IN number,
132 p_firm_planned_flag IN number,
133 p_wip_supply_type IN number,
134 p_fusd IN date,
135 p_lucd IN date,
136 p_start_quantity IN number,
137 p_net_quantity IN number,
138 p_coproducts_supply IN number,
139 p_bom_revision IN varchar2,
140 p_routing_revision IN varchar2,
141 p_bom_revision_date IN date,
142 p_routing_revision_date IN date,
143 p_lot_number IN varchar2,
144 p_alt_bom_designator IN varchar2,
145 p_alt_routing_designator IN varchar2,
146 p_priority IN number,
147 p_due_date IN date,
148 p_attribute_category IN varchar2,
149 p_attribute1 IN varchar2,
150 p_attribute2 IN varchar2,
151 p_attribute3 IN varchar2,
152 p_attribute4 IN varchar2,
153 p_attribute5 IN varchar2,
154 p_attribute6 IN varchar2,
155 p_attribute7 IN varchar2,
156 p_attribute8 IN varchar2,
157 p_attribute9 IN varchar2,
158 p_attribute10 IN varchar2,
159 p_attribute11 IN varchar2,
160 p_attribute12 IN varchar2,
161 p_attribute13 IN varchar2,
162 p_attribute14 IN varchar2,
163 p_attribute15 IN varchar2,
164 p_job_name IN varchar2,
165 p_completion_subinventory IN varchar2,
166 p_completion_locator_id IN number,
167 p_demand_class IN varchar2,
168 p_project_id IN number,
169 p_task_id IN number,
170 p_schedule_group_id IN number,
171 p_build_sequence IN number,
172 p_line_id IN number,
173 p_kanban_card_id IN number,
174 p_overcompl_tol_type IN number,
175 p_overcompl_tol_value IN number,
176 p_end_item_unit_number IN number,
177 p_rtg_op_seq_num IN number,
178 p_src_client_server IN number,
179 p_po_creation_time IN number,
180 p_date_released IN date,
181 p_error_code OUT NOCOPY number,
182 p_error_msg OUT NOCOPY varchar2);
183
184 PROCEDURE load_wsli_data(l_group_id IN NUMBER);
185
186
187 PROCEDURE check_errored_mmtt_records (
188 p_header_id IN NUMBER,
189 x_err_code OUT NOCOPY NUMBER,
190 x_err_msg OUT NOCOPY VARCHAR2);
191
192
193 PROCEDURE insert_procedure(
194 p_seq_id IN NUMBER,
195 p_job_seq_num IN NUMBER,
196 p_common_routing_sequence_id IN NUMBER, -- routing of the assembly
197 p_supply_type IN NUMBER,
198 p_wip_entity_id IN NUMBER,
199 p_organization_id IN NUMBER,
200 p_quantity IN NUMBER,
201 p_job_type IN NUMBER,
202 p_bom_reference_id IN NUMBER,
203 p_rtg_reference_id IN NUMBER,
204 p_assembly_item_id IN NUMBER,
205 p_alt_bom_designator IN VARCHAR2,
206 p_alt_rtg_designator IN VARCHAR2,
207 p_fusd IN DATE,
208 p_lucd IN DATE,
209 p_rtg_revision_date IN DATE,
210 p_bom_revision_date IN DATE,
211 p_last_updt_date IN date,
212 p_last_updt_by IN number,
213 p_creation_date IN date,
214 p_created_by IN number,
215 p_last_updt_login IN number,
216 p_request_id IN number,
217 p_program_application_id IN number,
218 p_program_id IN number,
219 p_prog_updt_date IN date,
220 p_error_code OUT NOCOPY NUMBER,
221 p_error_msg OUT NOCOPY VARCHAR2);
222
223
224 FUNCTION discrete_charges_exist(
225 p_wip_entity_id IN NUMBER,
226 p_organization_id IN NUMBER,
227 p_check_mode IN NUMBER ) RETURN BOOLEAN;
228
229
230 PROCEDURE insert_into_period_balances(
231 p_wip_entity_id IN NUMBER,
232 p_organization_id IN NUMBER,
233 p_class_code IN VARCHAR2,
234 p_release_date IN DATE,
235 p_error_code OUT NOCOPY NUMBER,
236 p_err_msg OUT NOCOPY VARCHAR2);
237
238
239 PROCEDURE process_invalid_field (
240 p_fld IN VARCHAR2,
241 aux_string IN VARCHAR2,
242 stmt_number IN NUMBER);
243
244
245 PROCEDURE process_errorred_field (
246 p_product IN VARCHAR2,
247 p_message_name IN VARCHAR2,
248 stmt_number IN NUMBER);
249
250
251 PROCEDURE handle_error (
252 p_err_code IN NUMBER,
253 p_err_msg IN VARCHAR2,
254 stmt_number IN NUMBER);
255
256
257 PROCEDURE handle_warning(
258 p_err_msg IN VARCHAR2,
259 p_header_id IN NUMBER,
260 p_request_id IN NUMBER,
261 p_program_id IN NUMBER,
262 p_program_application_id IN NUMBER);
263
264
265 FUNCTION honor_kanban_size (
266 p_org_id IN NUMBER,
267 p_item_id IN NUMBER,
268 p_subinv IN VARCHAR2,
269 p_locator_id IN NUMBER,
270 p_kanban_plan_id IN NUMBER)
271 return number;
272
273 -- This is the old process_interface_rows, retained to support Option A
274 PROCEDURE process_lbji_rows_1159 (
275 retcode OUT NOCOPY NUMBER,
276 errbuf OUT NOCOPY VARCHAR2,
277 p_group_id IN NUMBER);
278
279
280 PROCEDURE launch_worker_1159 (
281 retcode OUT NOCOPY NUMBER,
282 errbuf OUT NOCOPY VARCHAR2,
283 l_group_id IN NUMBER,
284 alotted_rows IN NUMBER );
285
286 END;