APPS.ITG_SYNCITEMINBOUND_PVT dependencies on MTL_ITEM_CATEGORIES_INTERFACE

Line 283: INSERT INTO mtl_item_categories_interface(

279: IF (l_Debug_Level <= 1) THEN
280: itg_debug_pub.Add('SI - Inserting into mtl_items_categories_interface', 1);
281: END IF;
282:
283: INSERT INTO mtl_item_categories_interface(
284: set_process_id,
285: item_number,
286: creation_date,
287: last_update_date,

Line 519: FROM mtl_item_categories_interface

515: IF p_mici_rid IS NOT NULL THEN
516: BEGIN
517: SELECT process_flag
518: INTO l_process_flag
519: FROM mtl_item_categories_interface
520: WHERE rowid = p_mici_rid;
521: EXCEPTION
522: WHEN OTHERS THEN
523: l_process_flag := null;

Line 540: error_transactions(p_request_id,'MTL_ITEM_CATEGORIES_INTERFACE');

536:
537: IF l_process_flag NOT IN ('6','7') OR l_process_flag IS NULL THEN
538: ITG_Debug.msg('Item-category import errored out, request-id:' || p_request_id,TRUE);
539: itg_msg.mici_only_failed;
540: error_transactions(p_request_id,'MTL_ITEM_CATEGORIES_INTERFACE');
541: return FND_API.G_RET_STS_SUCCESS;
542: END IF;
543: END IF;
544: IF (l_Debug_Level <= 2) THEN