eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_IMPORT_PVT dependencies on FND_API

Line 73: , p_commit IN FLAG DEFAULT FND_API.G_TRUE

69: * tries to detect discrepencies between user entered CONFIRM_STATUS
70: * (if any) and other data.
71: */
72: PROCEDURE Resolve_SSXref_On_Data_load( p_data_set_id IN NUMBER
73: , p_commit IN FLAG DEFAULT FND_API.G_TRUE
74: );
75:
76: /*
77: * This method sets the confirm_status for an unprocessed row (process_flag = 0) in the master org

Line 137: , p_commit IN FLAG DEFAULT FND_API.G_TRUE

133: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.
134: * with the inventory item id/number and organization id/code.
135: */
136: PROCEDURE Resolve_Child_Entities( p_data_set_id IN NUMBER
137: , p_commit IN FLAG DEFAULT FND_API.G_TRUE
138: );
139:
140: PROCEDURE Stamp_RequestId_For_ReImport( p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE );
141:

Line 173: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch

169: * p_batch_id IN NUMBER =>
170: * The batch identifier (MANDATORY).
171: * p_is_pdh_batch IN FLAG DEFAULT NULL =>
172: * Used to determine the set of keys to use for merging.
173: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch
174: * - Pass FND_API.G_FALSE to indicate that the batch is a non-PIMDH batch
175: * - If not passed, the batch header will be used to determine whether or not
176: * the batch is a PIMDH batch (absence of a header implies that it is).
177: * p_master_org_id IN NUMBER DEFAULT NULL =>

Line 174: * - Pass FND_API.G_FALSE to indicate that the batch is a non-PIMDH batch

170: * The batch identifier (MANDATORY).
171: * p_is_pdh_batch IN FLAG DEFAULT NULL =>
172: * Used to determine the set of keys to use for merging.
173: * - Pass FND_API.G_TRUE to indicate that the batch is a PIMDH batch
174: * - Pass FND_API.G_FALSE to indicate that the batch is a non-PIMDH batch
175: * - If not passed, the batch header will be used to determine whether or not
176: * the batch is a PIMDH batch (absence of a header implies that it is).
177: * p_master_org_id IN NUMBER DEFAULT NULL =>
178: * The ID of the default batch organization, to be used for rows for which neither

Line 182: * p_commit IN FLAG DEFAULT FND_API.G_FALSE =>

178: * The ID of the default batch organization, to be used for rows for which neither
179: * ORGANIZATION_ID nor ORGANIZATION_CODE are provided.
180: * If not passed, the ORGANIZATION_ID in the batch header will be used.
181: *
182: * p_commit IN FLAG DEFAULT FND_API.G_FALSE =>
183: * Pass FND_API.G_TRUE to have a COMMIT issued at the end of the procedure.
184: */
185:
186:

Line 183: * Pass FND_API.G_TRUE to have a COMMIT issued at the end of the procedure.

179: * ORGANIZATION_ID nor ORGANIZATION_CODE are provided.
180: * If not passed, the ORGANIZATION_ID in the batch header will be used.
181: *
182: * p_commit IN FLAG DEFAULT FND_API.G_FALSE =>
183: * Pass FND_API.G_TRUE to have a COMMIT issued at the end of the procedure.
184: */
185:
186:
187: --------------------------------------------------------------------------------------------

Line 196: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

192: PROCEDURE merge_attrs ( p_batch_id IN NUMBER
193: , p_is_pdh_batch IN FLAG DEFAULT NULL
194: , p_ss_id IN NUMBER DEFAULT NULL
195: , p_master_org_id IN NUMBER DEFAULT NULL
196: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
197: );
198: --------------------------------------------------------------------------------------------
199: -- Procedure MERGE_REVS
200: -- Merges unprocessed revisions found in the revisions interface table

Line 207: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

203: PROCEDURE merge_revs( p_batch_id IN NUMBER
204: , p_is_pdh_batch IN FLAG DEFAULT NULL
205: , p_ss_id IN NUMBER DEFAULT NULL
206: , p_master_org_id IN NUMBER DEFAULT NULL
207: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
208: );
209:
210: --------------------------------------------------------------------------------------------
211: -- Procedure MERGE_ITEMS

Line 219: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

215: PROCEDURE merge_items ( p_batch_id IN NUMBER
216: , p_is_pdh_batch IN FLAG DEFAULT NULL
217: , p_ss_id IN NUMBER DEFAULT NULL
218: , p_master_org_id IN NUMBER DEFAULT NULL
219: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
220: );
221:
222: --------------------------------------------------------------------------------------------
223: -- Procedure MERGE_BATCH

Line 230: , p_commit IN FLAG DEFAULT FND_API.G_FALSE

226: PROCEDURE merge_batch ( p_batch_id IN NUMBER
227: , p_is_pdh_batch IN FLAG DEFAULT NULL
228: , p_ss_id IN NUMBER DEFAULT NULL
229: , p_master_org_id IN NUMBER DEFAULT NULL
230: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
231: );
232:
233: --=================================================================================================================--
234: --------------------------------------- End of Merging Section ----------------------------------------------------

Line 312: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

308: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
309: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
310: , p_attr_type IN FLAG
311: , p_from_internal_column IN FLAG
312: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
313: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
314: )
315: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
316:

Line 329: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

325: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
326: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
327: , p_attr_type IN FLAG
328: , p_from_internal_column IN FLAG
329: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
330: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
331: )
332: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
333:

Line 344: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

340: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
341: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
342: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
343: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
344: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
345: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
346: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
347: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
348: , p_use_pdh_keys_to_join IN BOOLEAN

Line 370: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

366: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
367: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
368: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
369: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
370: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
371: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
372: )
373: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
374:

Line 385: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

381: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
382: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
383: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
384: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
385: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
386: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
387: )
388: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
389:

Line 405: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

401: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
402: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
403: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
404: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
405: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
406: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
407: )
408: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
409:

Line 420: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

416: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
417: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
418: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
419: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
420: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
421: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
422: )
423: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
424:

Line 442: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

438: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
439: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
440: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
441: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
442: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
443: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
444: )
445: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
446:

Line 458: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

454: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
455: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
456: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
457: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
458: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
459: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
460: )
461: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
462:

Line 478: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

474: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
475: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
476: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
477: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
478: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
479: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
480: )
481: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
482:

Line 493: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

489: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
490: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
491: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
492: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
493: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
494: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
495: )
496: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
497:

Line 513: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

509: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
510: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
511: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
512: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
513: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
514: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
515: )
516: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
517:

Line 528: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

524: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
525: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
526: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
527: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
528: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
529: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
530: )
531: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
532:

Line 549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
550: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
551: )
552: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
553:

Line 565: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

561: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
562: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
563: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
564: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
565: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
566: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
567:
568: )
569: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;

Line 586: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

582: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
583: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
584: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
585: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
586: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
587: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
588: )
589: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
590:

Line 597: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

593: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
594: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
595: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
596: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
597: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
598: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
599: )
600: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
601:

Line 608: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

604: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
605: , p_source_system_id IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
606: , p_source_system_reference IN MTL_ITEM_REVISIONS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
607: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
608: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
609: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
610: )
611: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
612:

Line 619: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

615: p_batch_id IN MTL_ITEM_REVISIONS_INTERFACE.SET_PROCESS_ID%TYPE
616: , p_inventory_item_id IN MTL_ITEM_REVISIONS_INTERFACE.INVENTORY_ITEM_ID%TYPE
617: , p_item_number IN MTL_ITEM_REVISIONS_INTERFACE.ITEM_NUMBER%TYPE
618: , p_organization_id IN MTL_ITEM_REVISIONS_INTERFACE.ORGANIZATION_ID%TYPE
619: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
620: , p_request_id IN MTL_ITEM_REVISIONS_INTERFACE.REQUEST_ID%TYPE DEFAULT NULL
621: )
622: RETURN MTL_ITEM_REVISIONS_INTERFACE.REVISION%TYPE;
623:

Line 705: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE

701: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
702: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
703: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
704: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL
705: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE
706: ,errmsg OUT NOCOPY VARCHAR2
707: ,retcode OUT NOCOPY VARCHAR2
708: );
709:

Line 757: , p_commit IN FLAG DEFAULT FND_API.G_FALSE );

753: * status_code null is defaulted with 1
754: */
755: PROCEDURE merge_associations ( p_batch_id IN NUMBER
756: , p_is_pdh_batch IN FLAG DEFAULT NULL
757: , p_commit IN FLAG DEFAULT FND_API.G_FALSE );
758:
759:
760: /*
761: * This method cleans up UDA row identifiers, ensuring that all single attr groups

Line 766: p_ignore_item_num_upd IN VARCHAR2, --FND_API.G_TRUE

762: * are represented by only one row identifier in EGO_ITM_USR_ATTR_INTRFC
763: */
764: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS( p_batch_id IN NUMBER,
765: p_process_status IN NUMBER,
766: p_ignore_item_num_upd IN VARCHAR2, --FND_API.G_TRUE
767: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
768: );
769:
770: END EGO_IMPORT_PVT;

Line 767: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

763: */
764: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS( p_batch_id IN NUMBER,
765: p_process_status IN NUMBER,
766: p_ignore_item_num_upd IN VARCHAR2, --FND_API.G_TRUE
767: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
768: );
769:
770: END EGO_IMPORT_PVT;