462: -- Also, assign transaction_id, request_id
463:
464: FOR cr IN miss_org_id_csr LOOP
465:
466: SELECT mtl_system_items_interface_s.NEXTVAL
467: INTO l_transaction_id
468: FROM dual;
469:
470: UPDATE mtl_item_categories_interface
468: FROM dual;
469:
470: UPDATE mtl_item_categories_interface
471: SET
472: -- transaction_id = mtl_system_items_interface_s.NEXTVAL
473: transaction_id = l_transaction_id
474: , request_id = g_request_id
475: , process_flag = 3
476: WHERE CURRENT OF miss_org_id_csr;
539: ELSE
540: l_process_flag := 1;
541: END IF;
542:
543: SELECT mtl_system_items_interface_s.NEXTVAL
544: INTO l_transaction_id
545: FROM dual;
546:
547: l_organization_id := icoi_rec.organization_id;