APPS.INV_ITEM_CATALOG_ELEM_PUB dependencies on MTL_DESC_ELEM_VAL_INTERFACE

Line 269: mtl_desc_elem_val_interface mdei_dup

265: mdei_dup.rowid
266: , mdei_dup.transaction_id
267: , mdei_dup.element_name
268: FROM
269: mtl_desc_elem_val_interface mdei_dup
270: WHERE
271: mdei_dup.rowid > (select rowid
272: FROM mtl_desc_elem_val_interface mdei
273: WHERE mdei.set_process_id = g_xset_id

Line 272: FROM mtl_desc_elem_val_interface mdei

268: FROM
269: mtl_desc_elem_val_interface mdei_dup
270: WHERE
271: mdei_dup.rowid > (select rowid
272: FROM mtl_desc_elem_val_interface mdei
273: WHERE mdei.set_process_id = g_xset_id
274: AND mdei.process_flag IN (1, 2)
275: AND rownum < 2
276: AND (mdei.inventory_item_id = mdei_dup.inventory_item_id

Line 294: mtl_desc_elem_val_interface mdei

290: , mdei.element_name, mdei.element_value
291: , mdei.element_sequence, mdei.item_number
292: , mdei.default_element_flag
293: FROM
294: mtl_desc_elem_val_interface mdei
295: WHERE
296: mdei.set_process_id = g_xset_id
297: AND mdei.process_flag IN (1, 2, 4) --R12C
298: ORDER BY mdei.item_number,mdei.inventory_item_id

Line 355: INV_ITEM_MSG.g_Table_Name := 'MTL_DESC_ELEM_VAL_INTERFACE';

351: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
352: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
353: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
354:
355: INV_ITEM_MSG.g_Table_Name := 'MTL_DESC_ELEM_VAL_INTERFACE';
356:
357: INV_ITEM_MSG.g_User_id := g_User_id;
358: INV_ITEM_MSG.g_Login_id := g_Login_id;
359: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;

Line 377: UPDATE mtl_desc_elem_val_interface mdei

373: ---------------------------------------------------------------------------------------
374:
375: INV_ITEM_MSG.Debug(Mctx, ' Set process flag to 2');
376:
377: UPDATE mtl_desc_elem_val_interface mdei
378: SET process_flag = 2
379: WHERE
380: mdei.set_process_id = g_xset_id
381: AND mdei.process_flag = 1;

Line 452: UPDATE mtl_desc_elem_val_interface

448: , p_value1 => l_token_value
449: , p_column_name => l_column_name
450: , p_transaction_id => l_transaction_id
451: );
452: UPDATE mtl_desc_elem_val_interface
453: SET
454: transaction_id = l_transaction_id,
455: request_id = g_request_id,
456: process_flag = 3

Line 460: UPDATE mtl_desc_elem_val_interface

456: process_flag = 3
457: WHERE
458: CURRENT OF icoi_csr;
459: ELSIF ( l_inventory_item_id IS NOT NULL )THEN
460: UPDATE mtl_desc_elem_val_interface
461: SET
462: inventory_item_id = l_inventory_item_id
463: WHERE
464: CURRENT OF icoi_csr;

Line 497: UPDATE mtl_desc_elem_val_interface

493: , p_transaction_id => l_transaction_id
494: );
495:
496:
497: UPDATE mtl_desc_elem_val_interface
498: SET
499: transaction_id = l_transaction_id,
500: request_id = g_request_id,
501: process_flag = 3

Line 591: UPDATE mtl_desc_elem_val_interface

587: --
588:
589: INV_ITEM_MSG.Debug(Mctx, 'update interface record');
590:
591: UPDATE mtl_desc_elem_val_interface
592: SET
593: transaction_id = l_transaction_id
594: , inventory_item_id = l_inventory_item_id
595: , item_number = l_item_number

Line 718: DELETE FROM mtl_desc_elem_val_interface

714: -- Initialize API return status to success
715: x_return_status := FND_API.g_RET_STS_SUCCESS;
716:
717: LOOP
718: DELETE FROM mtl_desc_elem_val_interface
719: WHERE set_process_id = p_rec_set_id
720: AND process_flag = l_del_process_flag
721: AND rownum < G_ROWS_TO_COMMIT;
722: