[Home] [Help]
PACKAGE: APPS.ENG_CHANGE_IMPORT_UTIL
Source
1 package ENG_CHANGE_IMPORT_UTIL as
2 /*$Header: ENGUCMIS.pls 120.16 2007/05/08 10:34:54 sdarbha ship $*/
3
4
5 /********************************************************************
6 * Constant Variables
7 *********************************************************************/
8
9 ---------------------------------------
10 -- Package Name
11 ---------------------------------------
12 G_PKG_NAME CONSTANT VARCHAR2(30):='ENG_CHANGE_IMPORT_UTIL';
13
14 ------------------------------------------------------------------------------
15 -- Return values for RETCODE parameter (standard for concurrent programs)
16 ------------------------------------------------------------------------------
17 RETCODE_SUCCESS NUMBER := 0;
18 RETCODE_WARNING NUMBER := 1;
19 RETCODE_ERROR NUMBER := 2;
20
21 ----------------------------------------------------
22 -- List of PROCESS_STATUS
23 ----------------------------------------------------
24
25 --------------------------------------------------------------------------
26 -- ProcessStatus : To Be Processed
27 -- the status when the record is loaded into Mtl_System_Items_Interface
28 --------------------------------------------------------------------------
29 G_PS_TO_BE_PROCESSED NUMBER := 1;
30 G_CM_TO_BE_PROCESSED NUMBER := 5;
31
32 --------------------------------------------------------------------------
33 -- ProcessStatus : Error
34 --------------------------------------------------------------------------
35 G_PS_ERROR NUMBER := 3;
36 G_PS_IMPORT_FAILURE NUMBER := 4;
37
38 --------------------------------------------------------------------------
39 -- ProcessStatus : Success
40 --------------------------------------------------------------------------
41 G_PS_SUCCESS NUMBER := 7;
42 G_PS_UDA_SUCCESS NUMBER := 4;
43
44
45 --------------------------------------------------------------------------
46 -- ProcessStatus : (INTERNAL) Data Population Phase
47 --------------------------------------------------------------------------
48 G_CM_DATA_POPULATION NUMBER := -5;
49
50
51 ---------------------------------------------------------------
52 -- Interface line Transaction Types. --
53 ---------------------------------------------------------------
54 G_CREATE CONSTANT VARCHAR2(10) := 'CREATE';
55 G_UPDATE CONSTANT VARCHAR2(10) := 'UPDATE';
56 G_DELETE CONSTANT VARCHAR2(10) := 'DELETE';
57 G_SYNC CONSTANT VARCHAR2(10) := 'SYNC';
58
59
60 ---------------------------------------------------------------
61 -- Change Management ACD TYpe --
62 ---------------------------------------------------------------
63 G_ADD_ACD_TYPE CONSTANT VARCHAR2(10) := 'ADD';
64 G_CHANGE_ACD_TYPE CONSTANT VARCHAR2(10) := 'CHANGE';
65 G_DELETE_ACD_TYPE CONSTANT VARCHAR2(10) := 'DELETE';
66
67 G_BOM_ADD_ACD_TYPE CONSTANT NUMBER := 1;
68 G_BOM_CHANGE_ACD_TYPE CONSTANT NUMBER := 2;
69 G_BOM_DISABLE_ACD_TYPE CONSTANT NUMBER := 3;
70
71
72 --------------------------------------------------------------------------
73 -- Caller Identifiers
74 --------------------------------------------------------------------------
75 G_ITEM VARCHAR2(50) := 'ITEM';
76 G_BOM VARCHAR2(50) := 'BOM';
77
78
79 --------------------------------------------------------------------
80 -- Message Type
81 --------------------------------------------------------------------
82
83 -- Specifies an exception of type error.
84 ERROR CONSTANT VARCHAR2(30) := '0';
85
86 -- Specifies an exception of type warning.
87 WARNING CONSTANT VARCHAR2(30) := '1' ;
88
89 -- Specifies an exception of type information.
90 INFORMATION CONSTANT VARCHAR2(30) := '2' ;
91
92 -- Specifies an exception of type confirmation.
93 CONFIRMATION CONSTANT VARCHAR2(30) := '3' ;
94
95 -- Specifies a severe exception.
96 SEVERE CONSTANT VARCHAR2(30) := '4' ;
97
98 --------------------------------------------------------------------
99 -- Exception Action Type
100 --------------------------------------------------------------------
101 -- Specifies no action to be taken when this exception is thrown.
102 NO_ACTION CONSTANT VARCHAR2(30) := '0' ;
103
104 -- Specifies an action to skip the row where this exception was thrown.
105 SKIP_CURRENT_ROW CONSTANT VARCHAR2(30) := '1' ;
106
107 -- Specifies an action to skip the parent of the row where this exception was thrown.
108 SKIP_PARENT CONSTANT VARCHAR2(30) := '2' ;
109
110 -- Specifies an action to skip all ancestors of the row where this exception was thrown.
111 SKIP_ANCESTOR CONSTANT VARCHAR2(30) := '3' ;
112
113 -- Specifies an action to completely stop when this exception is thrown.
114 STOP CONSTANT VARCHAR2(30) := '4' ;
115
116 -- The logging level under which this exception is logged.
117 LOG_ERROR CONSTANT VARCHAR2(30) := '5' ;
118
119
120
121 --------------------------------------------------------------------
122 -- CM Import Process Entity
123 --------------------------------------------------------------------
124 G_IMPORT_ALL CONSTANT VARCHAR2(30) := 'ALL';
125
126 G_ALL_ITEM_ENTITY CONSTANT VARCHAR2(30) := 'ALL_EGO_ITEM';
127 G_ITEM_ENTITY CONSTANT VARCHAR2(30) := 'EGO_ITEM';
128 G_ITEM_REV_ENTITY CONSTANT VARCHAR2(30) := 'EGO_ITEM_REVISION';
129 G_GDSN_ATTR_ENTITY CONSTANT VARCHAR2(30) := 'ITEM_GDSN_ATTR';
130 G_USER_ATTR_ENTITY CONSTANT VARCHAR2(30) := 'ITEM_USER_ATTR';
131 G_MFG_PARTT_NUM_ENTITY CONSTANT VARCHAR2(30) := 'ITEM_MFG_PART_NUM';
132
133 G_ALL_BOM_ENTITY CONSTANT VARCHAR2(30) := 'ALL_BOM';
134 G_BOM_ENTITY CONSTANT VARCHAR2(30) := 'BOM';
135 G_COMP_ENTITY CONSTANT VARCHAR2(30) := 'RC';
136 G_REF_DESG_ENTITY CONSTANT VARCHAR2(30) := 'RD';
137 G_SUB_COMP_ENTITY CONSTANT VARCHAR2(30) := 'SC';
138
139
140 --------------------------------------------------------------------
141 -- INTERFACE TABLE AND COLUMN NAME
142 --------------------------------------------------------------------
143 G_ITEM_INTF CONSTANT VARCHAR2(30) := 'MTL_SYSTEM_ITEMS_INTERFACE' ;
144 G_ITEM_INTF_BACTH_ID CONSTANT VARCHAR2(30) := 'SET_PROCESS_ID' ;
145 G_ITEM_INTF_PROC_FLAG CONSTANT VARCHAR2(30) := 'PROCESS_FLAG' ;
146 G_ITEM_INTF_RI_SEQ_ID CONSTANT VARCHAR2(30) := 'CHANGE_LINE_ID' ;
147
148 G_ITEM_REV_INTF CONSTANT VARCHAR2(30) := 'MTL_ITEM_REVISIONS_INTERFACE' ;
149 G_ITEM_REV_INTF_BACTH_ID CONSTANT VARCHAR2(30) := 'SET_PROCESS_ID' ;
150 G_ITEM_REV_INTF_PROC_FLAG CONSTANT VARCHAR2(30) := 'PROCESS_FLAG' ;
151 G_ITEM_REV_INTF_RI_SEQ_ID CONSTANT VARCHAR2(30) := 'REVISED_ITEM_SEQUENCE_ID' ;
152
153 G_ITEM_USR_ATTR_INTF CONSTANT VARCHAR2(30) := 'EGO_ITM_USR_ATTR_INTRFC' ;
154 G_ITEM_USR_ATTR_INTF_BACTH_ID CONSTANT VARCHAR2(30) := 'DATA_SET_ID' ;
155 G_ITEM_USR_ATTR_INTF_PROC_FLAG CONSTANT VARCHAR2(30) := 'PROCESS_STATUS' ;
156 G_ITEM_USR_ATTR_INTF_RI_SEQ_ID CONSTANT VARCHAR2(30) := 'CHANGE_LINE_ID' ;
157
158
159 G_ITEM_AML_INTF CONSTANT VARCHAR2(30) := 'EGO_AML_INTF' ;
160 G_ITEM_AML_INTF_BACTH_ID CONSTANT VARCHAR2(30) := 'DATA_SET_ID' ;
161 G_ITEM_AML_INTF_PROC_FLAG CONSTANT VARCHAR2(30) := 'PROCESS_FLAG' ;
162 G_ITEM_AML_INTF_RI_SEQ_ID CONSTANT VARCHAR2(30) := 'CHANGE_LINE_ID' ;
163
164 G_BOM_INTF CONSTANT VARCHAR2(30) := 'BOM_BILL_OF_MTLS_INTERFACE' ;
165 G_BOM_INTF_BACTH_ID CONSTANT VARCHAR2(30) := 'BATCH_ID' ;
166 G_BOM_INTF_PROC_FLAG CONSTANT VARCHAR2(30) := 'PROCESS_FLAG' ;
167 G_BOM_INTF_CHG_NOTICE CONSTANT VARCHAR2(30) := 'PENDING_FROM_ECN' ;
168
169 G_COMP_INTF CONSTANT VARCHAR2(30) := 'BOM_INVENTORY_COMPS_INTERFACE' ;
170 G_COMP_INTF_BACTH_ID CONSTANT VARCHAR2(30) := 'BATCH_ID' ;
171 G_COMP_INTF_PROC_FLAG CONSTANT VARCHAR2(30) := 'PROCESS_FLAG' ;
172 G_COMP_INTF_RI_SEQ_ID CONSTANT VARCHAR2(30) := 'REVISED_ITEM_SEQUENCE_ID' ;
173 G_COMP_INTF_CHG_NOTICE CONSTANT VARCHAR2(30) := 'CHANGE_NOTICE' ;
174
175 G_REF_DESG_INTF CONSTANT VARCHAR2(30) := 'BOM_REF_DESGS_INTERFACE' ;
176 G_REF_DESG_INTF_BACTH_ID CONSTANT VARCHAR2(30) := 'BATCH_ID' ;
177 G_REF_DESG_INTF_PROC_FLAG CONSTANT VARCHAR2(30) := 'PROCESS_FLAG' ;
178 G_REF_DESG_INTF_CHG_NOTICE CONSTANT VARCHAR2(30) := 'CHANGE_NOTICE' ;
179
180 G_SUB_COMP_INTF CONSTANT VARCHAR2(30) := 'BOM_SUB_COMPS_INTERFACE' ;
181 G_SUB_COMP_INTF_BACTH_ID CONSTANT VARCHAR2(30) := 'BATCH_ID' ;
182 G_SUB_COMP_INTF_PROC_FLAG CONSTANT VARCHAR2(30) := 'PROCESS_FLAG' ;
183 G_SUB_COMP_INTF_CHG_NOTICE CONSTANT VARCHAR2(30) := 'CHANGE_NOTICE' ;
184
185
186
187 --------------------------------------------------------------------
188 -- ITEM ATTRIBUTE GROUP TYPE NAME
189 --------------------------------------------------------------------
190 G_EGO_ITEMMGMT_GROUP CONSTANT VARCHAR2(30) := 'EGO_ITEMMGMT_GROUP' ;
191 G_EGO_ITEM_GTIN_ATTRS CONSTANT VARCHAR2(30) := 'EGO_ITEM_GTIN_ATTRS' ;
192 G_EGO_ITEM_GTIN_MULTI_ATTRS CONSTANT VARCHAR2(30) := 'EGO_ITEM_GTIN_MULTI_ATTRS' ;
193
194
195
196 --------------------------------------------------------------------
197 -- BATCH TYPE
198 --------------------------------------------------------------------
199 G_BOM_BATCH CONSTANT VARCHAR2(30) := 'BOM_STRUCTURE' ;
200 G_ITEM_BATCH CONSTANT VARCHAR2(30) := 'EGO_ITEM' ;
201 G_NO_BATCH CONSTANT VARCHAR2(30) := 'NONE' ;
202
203
204 --------------------------------------------------------------------
205 -- CM IMPORT OPTION
206 --------------------------------------------------------------------
207 G_CREATE_NEW_CHANGE CONSTANT VARCHAR2(30) := 'N' ;
208 G_ADD_TO_EXISTING CONSTANT VARCHAR2(30) := 'E' ;
209 G_NO_CHANGE CONSTANT VARCHAR2(30) := 'O' ;
210
211
212
213 --------------------------------------------------------------------
214 -- BATCH IMPORT OPTION: REVISION IMPORT POLICY
215 --------------------------------------------------------------------
216 G_REV_IMPT_POLICY_NEW CONSTANT VARCHAR2(1) := 'N' ;
217 G_REV_IMPT_POLICY_LATEST CONSTANT VARCHAR2(1) := 'L' ;
218
219
220 -----------------------------------------------------------------
221 -- Check the entity is processed or not --
222 -----------------------------------------------------------------
223 FUNCTION Get_Attr_Group_Type_Condition (p_table_alias IN VARCHAR2
224 , p_attr_group_type IN VARCHAR2
225 )
226 RETURN VARCHAR2 ;
227
228
229 /********************************************************************
230 * API Type : Error and Message Handling APIs
231 * Purpose : Error and Message Handling for Change Import
232 *********************************************************************/
233 PROCEDURE WRITE_MSG_TO_INTF_TBL
234 ( p_api_version IN NUMBER
235 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
236 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
237 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
238 , x_return_status OUT NOCOPY VARCHAR2
239 , x_msg_count OUT NOCOPY NUMBER
240 , x_msg_data OUT NOCOPY VARCHAR2
241 , p_api_caller IN VARCHAR2 := NULL
242 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
243 , p_output_dir IN VARCHAR2 := NULL
244 , p_debug_filename IN VARCHAR2 := NULL
245 , p_batch_id IN NUMBER
246 , p_transaction_id IN NUMBER
247 , p_bo_identifier IN VARCHAR2 := NULL
248 , p_error_entity_code IN VARCHAR2 := NULL
249 , p_error_table_name IN VARCHAR2 := NULL
250 , p_error_column_name IN VARCHAR2 := NULL
251 , p_error_msg IN VARCHAR2 := NULL
252 , p_error_msg_type IN VARCHAR2 := NULL
253 , p_error_msg_name IN VARCHAR2 := NULL
254 ) ;
255
256
257
258
259 /********************************************************************
260 * API Type : Validation APIs
261 * Purpose : Perform Validation for Change Import
262 *********************************************************************/
263 PROCEDURE VALIDATE_RECORDS
264 ( p_api_version IN NUMBER
265 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
266 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
267 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
268 , x_return_status OUT NOCOPY VARCHAR2
269 , x_msg_count OUT NOCOPY NUMBER
270 , x_msg_data OUT NOCOPY VARCHAR2
271 , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
272 , p_api_caller IN VARCHAR2 := NULL
273 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
274 , p_output_dir IN VARCHAR2 := NULL
275 , p_debug_filename IN VARCHAR2 := NULL
276 , p_batch_id IN NUMBER
277 , p_batch_type IN VARCHAR2 := NULL
278 , p_process_entity IN VARCHAR2 := NULL
279 , p_cm_process_type IN VARCHAR2 := NULL
280 ) ;
281
282
283
284 PROCEDURE MERGE_GDSN_PENDING_CHG_ROWS
285 ( p_inventory_item_id IN NUMBER
286 ,p_organization_id IN NUMBER
287 ,p_change_id IN NUMBER
288 ,p_change_line_id IN NUMBER
289 ,p_acd_type IN VARCHAR2 := NULL
290 ,x_single_row_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_SINGL_ROW_REC_TYP
291 ,x_multi_row_attrs_tbl IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_ATTRS_MULTI_ROW_TBL_TYP
292 ,x_extra_attrs_rec IN OUT NOCOPY EGO_ITEM_PUB.UCCNET_EXTRA_ATTRS_REC_TYP
293 ) ;
294
295 PROCEDURE VALIDATE_GDSN_ATTR_CHGS
296 ( p_api_version IN NUMBER
297 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
298 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
299 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
300 , x_return_status OUT NOCOPY VARCHAR2
301 , x_msg_count OUT NOCOPY NUMBER
302 , x_msg_data OUT NOCOPY VARCHAR2
303 , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
304 , p_api_caller IN VARCHAR2 := NULL
305 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
306 , p_output_dir IN VARCHAR2 := NULL
307 , p_debug_filename IN VARCHAR2 := NULL
308 , p_batch_id IN NUMBER
309 , p_cm_process_type IN VARCHAR2 := NULL
310 ) ;
311
312
313
314 /********************************************************************
315 * API Type : Derive and Populate Values APIs
316 * Purpose : Perform Deriving and Populating values to Interface table
317 *********************************************************************/
318
319
320 PROCEDURE POPULATE_EXISTING_CHANGE
321 ( p_api_version IN NUMBER
322 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
323 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
324 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
325 , x_return_status OUT NOCOPY VARCHAR2
326 , x_msg_count OUT NOCOPY NUMBER
327 , x_msg_data OUT NOCOPY VARCHAR2
328 , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
329 , p_api_caller IN VARCHAR2 := NULL
330 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
331 , p_output_dir IN VARCHAR2 := NULL
332 , p_debug_filename IN VARCHAR2 := NULL
333 , p_batch_id IN NUMBER
334 , p_change_number IN VARCHAR2 := NULL
335 , p_process_entity IN VARCHAR2 := NULL
336 , p_cm_process_type IN VARCHAR2 := NULL
337 , p_item_id IN NUMBER := NULL
338 , p_org_id IN NUMBER := NULL
339 , p_create_new_flag IN VARCHAR2 := NULL -- N: New, E: Add to Existing
340 ) ;
341
342
343 PROCEDURE POPULATE_EXISTING_REV_ITEMS
344 ( p_api_version IN NUMBER
345 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
346 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
347 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
348 , x_return_status OUT NOCOPY VARCHAR2
349 , x_msg_count OUT NOCOPY NUMBER
350 , x_msg_data OUT NOCOPY VARCHAR2
351 , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
352 , p_api_caller IN VARCHAR2 := NULL
353 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
354 , p_output_dir IN VARCHAR2 := NULL
355 , p_debug_filename IN VARCHAR2 := NULL
356 , p_batch_id IN NUMBER
357 , p_process_entity IN VARCHAR2 := NULL
358 , p_cm_process_type IN VARCHAR2 := NULL
359 , p_item_id IN NUMBER := NULL
360 , p_org_id IN NUMBER := NULL
361 ) ;
362
363
364 PROCEDURE UPDATE_PROCESS_STATUS
365 ( p_api_version IN NUMBER
366 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
367 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
368 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
369 , x_return_status OUT NOCOPY VARCHAR2
370 , x_msg_count OUT NOCOPY NUMBER
371 , x_msg_data OUT NOCOPY VARCHAR2
372 , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
373 , p_api_caller IN VARCHAR2 := NULL
374 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
375 , p_output_dir IN VARCHAR2 := NULL
376 , p_debug_filename IN VARCHAR2 := NULL
377 , p_batch_id IN NUMBER
378 , p_from_status IN NUMBER
379 , p_to_status IN NUMBER
380 , p_process_entity IN VARCHAR2 := NULL
381 , p_item_id IN NUMBER := NULL
382 , p_org_id IN NUMBER := NULL
383 , p_transaction_id IN NUMBER := NULL
384 ) ;
385
386 FUNCTION get_Rev_item_update_parent ( p_change_id IN NUMBER
387 , p_organization_id IN NUMBER
388 , p_revised_item_id IN NUMBER
389 , p_revision IN VARCHAR2
390 , p_default_seq_id IN NUMBER := NULL
391 , p_revision_import_policy IN VARCHAR2 := NULL
392 )
393 RETURN NUMBER;
394
395 FUNCTION FIND_REV_ITEM_REC ( p_change_notice IN VARCHAR2
396 , p_organization_id IN NUMBER
397 , p_revised_item_id IN NUMBER
398 , p_revision_id IN NUMBER := NULL
399 , p_default_seq_id IN NUMBER := NULL
400 , p_revision_import_policy IN VARCHAR2 := NULL
401 )
402 RETURN NUMBER;
403
404 FUNCTION FIND_REV_ITEM_REC ( p_change_id IN NUMBER
405 , p_organization_id IN NUMBER
406 , p_revised_item_id IN NUMBER
407 , p_revision IN VARCHAR2
408 , p_default_seq_id IN NUMBER := NULL
409 , p_revision_import_policy IN VARCHAR2 := NULL
410 )
411 RETURN NUMBER ;
412
413
414 FUNCTION FIND_REV_ITEM_REC ( p_change_id IN NUMBER
415 , p_organization_id IN NUMBER
416 , p_revised_item_id IN NUMBER
417 , p_revision_id IN NUMBER := NULL
418 , p_default_seq_id IN NUMBER := NULL
419 , p_revision_import_policy IN VARCHAR2 := NULL
420 )
421 RETURN NUMBER ;
422
423 PROCEDURE PREPROCESS_BOM_INTERFACE_ROWS
424 ( p_api_version IN NUMBER
425 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
426 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
427 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
428 , x_return_status OUT NOCOPY VARCHAR2
429 , x_msg_count OUT NOCOPY NUMBER
430 , x_msg_data OUT NOCOPY VARCHAR2
431 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
432 , p_output_dir IN VARCHAR2 := NULL
433 , p_debug_filename IN VARCHAR2 := NULL
434 , p_change_id IN NUMBER
435 , p_change_notice IN VARCHAR2
436 , p_organization_id IN NUMBER
437 , p_revised_item_id IN NUMBER
438 , p_alternate_bom_designator IN VARCHAR2
439 , p_bill_sequence_id IN NUMBER
440 , p_effectivity_date IN DATE := NULL
441 , p_from_end_item_unit_number IN VARCHAR2 := NULL
442 , p_from_end_item_rev_id IN NUMBER := NULL
443 , p_current_date IN DATE := NULL
444 , p_revised_item_sequence_id IN NUMBER
445 , p_parent_rev_eff_date IN DATE := NULL
446 , p_parent_revision_id IN NUMBER := NULL
447 , p_batch_id IN NUMBER
448 , p_request_id IN NUMBER
449 ) ;
450
451 PROCEDURE CREATE_ORPHAN_COMPONENT_INTF
452 ( p_api_version IN NUMBER
453 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
454 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
455 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
456 , x_return_status OUT NOCOPY VARCHAR2
457 , x_msg_count OUT NOCOPY NUMBER
458 , x_msg_data OUT NOCOPY VARCHAR2
459 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
460 , p_output_dir IN VARCHAR2 := NULL
461 , p_debug_filename IN VARCHAR2 := NULL
462 , p_organization_id IN NUMBER
463 , p_assembly_item_id IN NUMBER
464 , p_alternate_bom_designator IN VARCHAR2
465 , p_bill_sequence_id IN NUMBER
466 , p_component_item_id IN NUMBER
467 , p_op_seq_number IN NUMBER
468 , p_effectivity_date IN DATE := NULL
469 , p_component_seq_id IN NUMBER
470 , p_from_end_item_unit_number IN VARCHAR2 := NULL
471 , p_from_end_item_rev_id IN NUMBER := NULL
472 , p_batch_id IN NUMBER
473 );
474
475 PROCEDURE CREATE_ORPHAN_HEADER_INTF
476 ( p_api_version IN NUMBER
477 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
478 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
479 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
480 , x_return_status OUT NOCOPY VARCHAR2
481 , x_msg_count OUT NOCOPY NUMBER
482 , x_msg_data OUT NOCOPY VARCHAR2
483 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
484 , p_output_dir IN VARCHAR2 := NULL
485 , p_debug_filename IN VARCHAR2 := NULL
486 , p_organization_id IN NUMBER
487 , p_assembly_item_id IN NUMBER
488 , p_alternate_bom_designator IN VARCHAR2
489 , p_bill_sequence_id IN NUMBER
490 , p_batch_id IN NUMBER
491 );
492
493 PROCEDURE PREPROCESS_COMP_CHILD_ROWS
494 ( p_api_version IN NUMBER
495 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
496 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
497 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
498 , x_return_status OUT NOCOPY VARCHAR2
499 , x_msg_count OUT NOCOPY NUMBER
500 , x_msg_data OUT NOCOPY VARCHAR2
501 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
502 , p_output_dir IN VARCHAR2 := NULL
503 , p_debug_filename IN VARCHAR2 := NULL
504 , p_organization_id IN NUMBER
505 , p_assembly_item_id IN NUMBER
506 , p_alternate_bom_designator IN VARCHAR2
507 , p_bill_sequence_id IN NUMBER
508 , p_change_id IN NUMBER
509 , p_change_notice IN VARCHAR2
510 , p_batch_id IN NUMBER
511 );
512 /********************************************************************
513 * API Type : Imported Changes Handler and APIs
514 * Purpose : Imported Changes Table Handler
515 *********************************************************************/
516 PROCEDURE INSERT_IMPORTED_CHANGE_HISTORY
517 ( p_api_version IN NUMBER
518 , p_init_msg_list IN VARCHAR2 := NULL -- FND_API.G_FALSE
519 , p_commit IN VARCHAR2 := NULL -- FND_API.G_FALSE
520 , p_validation_level IN NUMBER := NULL -- FND_API.G_VALID_LEVEL_FULL
521 , x_return_status OUT NOCOPY VARCHAR2
522 , x_msg_count OUT NOCOPY NUMBER
523 , x_msg_data OUT NOCOPY VARCHAR2
524 , p_write_msg_to_intftbl IN VARCHAR2 := NULL -- FND_API.G_FALSE
525 , p_api_caller IN VARCHAR2 := NULL
526 , p_debug IN VARCHAR2 := NULL -- FND_API.G_FALSE
527 , p_output_dir IN VARCHAR2 := NULL
528 , p_debug_filename IN VARCHAR2 := NULL
529 , p_batch_id IN NUMBER
530 , p_change_ids IN FND_ARRAY_OF_NUMBER_25
531 ) ;
532
533
534 procedure INSERT_IMPORT_CHANGE_ROW (
535 X_ROWID in out nocopy VARCHAR2,
536 X_BATCH_ID in NUMBER,
537 X_CHANGE_ID in NUMBER ,
538 X_CREATION_DATE in DATE,
539 X_CREATED_BY in NUMBER,
540 X_LAST_UPDATE_DATE in DATE,
541 X_LAST_UPDATED_BY in NUMBER,
542 X_LAST_UPDATE_LOGIN in NUMBER);
543
544
545 --
546 -- procedure LOCK_IMPORT_CHANGE_ROW (
547 -- X_BATCH_ID in NUMBER,
548 -- X_CHANGE_ID in NUMBER
549 -- );
550
551 --
552 -- procedure UPDATE_IMPORT_CHANGE_ROW (
553 -- X_BATCH_ID in NUMBER,
554 -- X_CHANGE_ID in NUMBER
555 -- X_LAST_UPDATE_DATE in DATE,
556 -- X_LAST_UPDATED_BY in NUMBER,
557 -- X_LAST_UPDATE_LOGIN in NUMBER
558 -- );
559
560
561 procedure DELETE_IMPORT_CHANGE_ROW (
562 X_BATCH_ID in NUMBER,
563 X_CHANGE_ID in NUMBER
564 );
565
566 FUNCTION Get_Nulled_out_Value(value IN VARCHAR2)
567 RETURN VARCHAR2;
568
569
570 FUNCTION Get_Nulled_out_Value(value IN DATE)
571 RETURN DATE;
572
573
574 FUNCTION Get_Nulled_out_Value(value IN NUMBER)
575 RETURN NUMBER ;
576
577
578 END ENG_CHANGE_IMPORT_UTIL ;