APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 99: UPDATE MTL_ITEM_CATEGORIES_INTERFACE

95: --l_acc_code := 0;
96: --l_acc_catalog := 0;
97: IF l_acc_code IS NOT NULL
98: THEN
99: UPDATE MTL_ITEM_CATEGORIES_INTERFACE
100: SET CATEGORY_id = l_acc_code ,CATEGORY_SET_ID = l_acc_catalog
101: WHERE bundle_id = item_data.bundle_id
102: AND source_system_id = item_data.global_trade_item_number
103: AND source_system_reference = item_data.source_system_reference;

Line 589: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI

585: FROM MTL_ITEM_BULKLOAD_RECS
586: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
587:
588: -- Updating items caetgories rows
589: UPDATE MTL_ITEM_CATEGORIES_INTERFACE MICI
590: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
591: PROCESS_FLAG = C_INIT_PROCESS_FLAG,
592: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID
593: FROM EGO_IMPORT_BATCHES_B

Line 1582: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE(

1578: LOOP
1579: l_alt_cat_concat_seg := l_alt_cat_conc_seg_rec.concatenated_segments;
1580: END LOOP;
1581:
1582: INSERT INTO MTL_ITEM_CATEGORIES_INTERFACE(
1583: transaction_id,
1584: category_set_name,
1585: category_name,
1586: source_system_id,